Execute Existing Query Programattically

[Guest]

I was wondering...I have a number of queries created, some of which make new
tables, etc. I was wondering if there is any slick/easy way to execute a
number of existing queries right inside VBA code (as opposed to create a
massive number of docmd.SQLRun routines).

Thanks!

PatK

 

[Guest]

Try building a macro to run them.

 

[fredg]

I was wondering...I have a number of queries created, some of which make new
tables, etc. I was wondering if there is any slick/easy way to execute a
number of existing queries right inside VBA code (as opposed to create a
massive number of docmd.SQLRun routines).

Thanks!

PatK

If the queries already exist, just use:
DoCmd.OpenQuery "Query1"
DoCmd.OpenQuery "Query2"
etc.

 

[Guest]

Thanks Guys! That I did not know about the OpenQuery. There is so much
that, unless you know it exists, you can't know to use it! Yet nothing to
tell you it exists, either (except kind folks like yourselve!).

Thanks!

Patk