Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Query w/Function from Excel
I hate to post a repeat of a previous post but, the reply
I received didn't quite solve my problem. 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 it. This also happens when using the "NZ" function in a Access query. I can rule out a need for a reference being set to the ADO Interface or Access Object Model. Thanks in advance, Kev |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query SQL Data in Excel with a function? | Excel Worksheet Functions | |||
SQL & Like Query function in excel | Excel Worksheet Functions | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Run Query w/Function from Excel | Excel Programming | |||
Excel Web Query Function | Excel Programming |