Make Table Query Macro

[BigDogTroy]

I have 2 query's, they both make tables, I have a macro that runs these 2 queries, and I would like it to run without prompting the questions: "Do you want to paste x amount of records to the table?" or any other prompts. Can someone tell me how to get around this? Thanks In Advanced.

 

[ColinEssex]

Check out 'warnings' in Access help.

Remember if you switch the warnings off using code, you'll need to switch them on again when the code has run.

Col

 

[ted.martin]

Another way would be to open the database and select Tools/Options/EditFind and uncheck Action Queries.

 

[Mike375]

In your macro select SetWarnings from the drop down list on the action line and use No......at the bottom of the macro screen. Have SetWarning on an action line above your openquery actions