J
jinsong
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() );
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() );