Running multiple queries in 2003

O

olsen9988

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?
 
M

Michel Walsh

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
 
Top