Execute Existing Query Programattically

P

PatK

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
 
F

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
Click to expand...

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