#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2001
    Location
    Exton, PA
    Posts
    3
    Rep Power
    0

    Question 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:

    Set PassThruQuery.SQL=SQL

    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?

    Thanks!
  2. #2
  3. No Profile Picture
    Seņor Member
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Aug 2000
    Posts
    1,157
    Rep Power
    38
    Try looking here: <http://visualbasicforum.com/>
    Michael
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2001
    Location
    Exton, PA
    Posts
    3
    Rep Power
    0
    thanks, didn't know that site existed. i had looked everywhere. usually go to devshed.com first!
  6. #4
  7. No Profile Picture
    Seņor Member
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Aug 2000
    Posts
    1,157
    Rep Power
    38
    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.
    Michael

IMN logo majestic logo threadwatch logo seochat tools logo