Can I get rid of "Are you sure?" boxes on Macro?

[Jodi_MHS]

Here's the situation: I have 2 Make table queries that progressively spool into the 3rd parameter query. The report is based off this 3rd query. I needed to create a macro for the switchboard so the user could run the report after updating the database, by simply clicking a button, and all the make-table queries and the 3rd query would be run and the report printed. It works. PROBLEM: I keep having warning boxes popping up "You are about to run a make-table query...." Is there any way that I can shut off this series of questions to make it easier for the user? THANKS!

 

[David R]

For VBA:
DoCmd.SetWarnings = False
Then at the end, set the following:
DoCmd.SetWarnings = True

For a Macro:
SetWarnings action = No
Then after the action(s) in question:
SetWarnings action = Yes

HTH,
David R (Thanks to Carol and chrisk for the original solutions)

 

[Pat Hartman]

You don't need to actually make tables. You can use queries within queries. So the report's recordsource can join two queries rather than two tables. This method will reduce database bloat reducing the need for constant compacts. Every time you run a make table query, Access increases the size of your db to hold the new table. The space used by the existing table that you are intending to replace is NOT reused.