How do you run more than one query at once using a module? (1 Viewer)

[magickatt]

I have not much experience at VB, and I would like (need) to know how to use modules to run more than one query (one after another), if anyone can help could they please mail me the VB Code in a mail quickly please?!
magickatt@hotmail.com

 

[GMC]

Try looking up the following in the Access Help Files:

OpenQuery / RunSQL

Hope this helps
Grant

 

[Travis]

I prefer to use the CurrentDB.Execute method. OpenQuery/Run SQL bring up all of those messages (You know the ones... Updateing 1 record are you sure?)

While CurrentDB.Execute just runs the query with no messages. This makes it excelent for running Action queries one right after the next.