Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
While I trying to run ADO following statement
rs.Open "abcd", cn, adOpenStatic, adLockOptimistic, adCmdTable I got error "run time error'-2147217900(80040e14)': undefined function "abc" in expression note: abcd is a query defined in access, abc is a function defined in access to get specific date. here is query abcd: SELECT DISTINCT * FROM Order_info INNER JOIN Revenue ON Order_info.O_ID = Revenue.O_ID WHERE ( ((Order_info.CONNECT_DT)=abc() ); |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel error: Undefined Function 'InStrRev' in Expression | Excel Worksheet Functions | |||
Undefined function error | Excel Discussion (Misc queries) | |||
undefined function error when creating xls pivot from mdb qry | Excel Worksheet Functions | |||
'Undefined Function' Error in Microsoft Query | Excel Programming | |||
Excel 2000 VBA undefined function problem | Excel Programming |