Run Query w/Function from Excel

K

Kev

Has anyone run into this before?
I have query in Access with a function that I wrote as
one of the fields. My problem is that when I try to run
the query from Excel using ADODB.Command I get the
following error: "Run-time error '-2147217900(80040e14)':
Undefined function 'Function Name' in expression.." This
query is a parameter query so, I need to be able to pass
the parameters to the query.

Thanks in advance,

Kev
 
G

Guest

Load the reference for ADO in Visual Basic.
Under Tools/References load the latest "Microsoft Activex
Data Objects X.X Library" where X.X is the latest version
you have, i.e. 2.7. This is on the VBA Macro side of your
spreadsheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Query w/Function from Excel 3
Access #Error & Excel Pivot 0
2147217900 undefined function 1
VBA error while using SQL "with rollup" 2
Access Invalid bracketing of parameter name 1
Access query(with custom function) from Excel 3
Use In() Expression as Query criteria with guts from Function 1
Access update query 2

Top