Running multiple queries in 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had created macros in 2000 which called a series of queries, but now in
2003 this won't work. When I try to run the macro it just closed the
database entirely. How can I run multiple queries in 2003?
 
Hi,


It should work in Access 2003 too, probably a problem of configuration,
Anyhow, you can also run a simple VBA code: in a standard module, create a
subroutine like:



Public Sub RunMyActionQueries()

DoCmd.RunSQL mySaveQuery1
DoCmd.RunSQL mySaveQuery2

End Sub



Hoping it may help,
Vanderghast, Access MVP
 

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

Multiple Queries in One Data Sheet.... 1
Run Macro If Cell have "x" value 0
Combine Duplicates in Query 0
Parameter Query Won't Run 0
Unique Count in Sigma Query 3
Turning off action query confirmation messages 1
Run multiple append queries? 1
open and run access query in excel 1

Back
Top