Compile error > QueryDefs!

J

Jim Bunton

*** code snippet ****
dim obposn as integer
obPosn = InStr(cdb.QueryDefs!("EventListByDate").sql, "Order By") - 1
*** END Code Snippet ****

PROBLEM:-
Compile Error:-
QueryDefs! > error > Type declaration character does not match declared data type



NB
Available References are:-
Visual basic for Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
 
K

Ken Snell [MVP]

see answer in other thread

--

Ken Snell
<MS ACCESS MVP>


*** code snippet ****
dim obposn as integer
obPosn = InStr(cdb.QueryDefs!("EventListByDate").sql, "Order By") - 1
*** END Code Snippet ****

PROBLEM:-
Compile Error:-
QueryDefs! > error > Type declaration character does not match declared data
type



NB
Available References are:-
Visual basic for Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
 
Top