
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