How to make a macro

[lwilt]

I'm trying to figure out how to make a macro in access so that I don't have to individually run 20 queries every time I need this data. How would I set this up. Each query is named pricing Q1...Q20. I assumed the first action needs to be open query pricing Q1 and have a data mode of edit but I wasn't sure.

And then I keep opening the rest of the queries as the next steps but that didn't seem to work....please help

 

[lwilt]

hmm it seems the first data mode needs to be add.... but is that the cause for the whole thing to run all the queries?

 

[Joe4]

What is the nature of all 20 of these queries?
Are they all Action queries (Append, Update, Delete)?
If not, if they are just a bunch of nested Select queries, you shouldn't need to open each one. Just open the last one, they rest will be run automatically.

If these are indeed all action queries, why do you have so many? You may have a design issue which should be corrected, especially if a lot of these queries are basically doing similar tasks.

Also note that you can create a macro with 20 OpenQuery actions. So you would only need to set it up once, then just run this single macro each time to run all 20 Action Queries.