Microsoft Office Tutorials and References
In Depth Information
Processing data with action queries
Empty and populate a table of data (continued)
3 Click the Create tab.
4 Click Macro.
5 Add an OpenQuery command.
6 Select the query that empties the data from your table.
7 Add an OpenQuery command.
8 Select the query that adds data to the empty table.
9 Save the macro.
10 Type a name for the macro, and click OK. At this point, you should
save and test the macro.
11 Add the Set Warnings command, with Warnings On set to No. This
prevents the prompting boxes from displaying when you are
executing the query. (When you have verified that it executes correctly,
you might want to switch off the built-in warnings when executing
an action query.)
12 Add the Set Warnings command, with Warnings On set to Yes. It is
very important that you always switch the standard warnings back
13 Add a MessageBox command to indicate that the processing is
14 Use the up and down arrows to move your commands to the
correct position in the macro sequence.