Run Time 3011 (Query building problem) 
Author Message
 Run Time 3011 (Query building problem)

Using VB5.

I'm building a sql statement which, when put together, looks like this...
  select * from open_table where center = 'jc lanes'

When I issue the dtaopen.refresh command I get the Run Time 3011 error
which basically says couldn't find the object. Then it displays my query
statement, which is the same except it has a " instead of a ' ('jc lanes")

Is that the problem and if so, what's causing it? I'm using the dbGrid control
and a db combo box to retrieve what center to look for.

Thanks
  Doug



Wed, 13 Dec 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Run-time error '3011' linking table

2. Problem with error 3011

3. Problem with error 3011

4. Problem with Recordsource Property / Error 3011 or Error 3024 HELP

5. problem with running 2 programms at the same time build in vb6

6. Error code 7874 vs. 3011 in Access 2000

7. Error 3011

8. db.requery causes error 3011 - MS Jet cannot find object

9. Refresh after RecordSource=SQL causes Error 3011 on DataControl

10. Runtime error 3011 - can't open MSysDb

11. DAO Relationships - Error 3011

12. Access queries run from VB gobbling 10 times the disk spaces as when run locally

 

 
Powered by phpBB® Forum Software