October 3rd, 2001, 03:19 PM
Trouble with VB coding...HELP PLEASE
I have an Access 2000 database serving as a front end to MySQL. In that Access database, I've created a pass-thru query, and a little bit of VB code to create the SQL statement dynamically. I can't figure out how to use VB to put the SQL code into the pass-thru query. What I need to do is something like this:
But I can't figure out the syntax to do it! Once I do that, I'll be able to issue an open report command for a report that uses that query for its results. There has to be a way to set the SQL property, but I just don't know how to do it. Any ideas?
October 3rd, 2001, 04:48 PM
October 3rd, 2001, 05:30 PM
thanks, didn't know that site existed. i had looked everywhere. usually go to devshed.com first!
October 3rd, 2001, 05:58 PM
No problem -- I didn't know it existed either, until I searched for it on <http://www.google.com/>. That's usually the first place I go.