Using Query SQL in VBA Module Access 97

  • Thread starter Thread starter John Cole, Jr.
  • Start date Start date
J

John Cole, Jr.

I have an Access 97 database that is used to transfer data from one
computer system to another. The export fields are fixed, and each
project I work requires data from different fields in the input
computer system. Rather than create several mini databases to cover
each of the job situations, I would like to use "Select Case" in my
module and input the SQL statement from each of the queries. How do I
use the SQL from the query in my module?
 
You can use the SQL Property of the QueryDef Object which is the Query
object in code.

Check Access VB Help on QueryDef and its Properties.
 
You must log in or register to reply here.

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

MS Access Parameter Queris 5
Slow ODBC Queries to SQL 2000 4
Query SQL report 4
Issuing Queries to '97 Database 2
Should I use a Class Module? 2
export SQL from Queries 2
Easy way to share vba modules 6
Module Not Found 5

Back
Top