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
 

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

compile error > QueryDefs Access 2000 2
Run-time error 2287 1
VBA Compile error when converting to Access 2007 4
Problem with Allen Browne's Function TableInfo() 3
Compile Error : Type Mismatch 2
BeginTrans . . 6
Access2000 converted to Access2007 4
Converting Access 2000 database to Access 2007 2

Top