Turn Off query pops

To turn off the confirmation pop‑ups that appear when a macro runs action queries in Access, use the SetWarnings macro action.

For a specific set of tasks in a macro:

1. Open the macro in Macro Builder (or create a new macro).
2. In the drop‑down list at the top of Macro Builder, select the SetWarnings action.
   • If SetWarnings is not listed, on the Macro Design tab, in the Show/Hide group, select Show All Actions.
3. Under the SetWarnings action, click the arrow next to Warnings On and select No.
4. Add the macro actions that run the queries (and any other tasks) that should run without confirmation messages.
5. After the last task action, add another SetWarnings action.
6. For this second SetWarnings, set Warnings On to Yes to re‑enable messages after the macro finishes.
7. Save the macro.

To turn off action query confirmations for the whole database at startup:

1. On the Create tab, in the Macros & Code group, click Macro.
2. In Macro Builder, choose the SetWarnings action.
   • If needed, enable Show All Actions on the Macro Design tab.
3. Set Warnings On to the desired option (to suppress confirmations, choose No).
4. Click Save.
5. In the Save As dialog, name the macro AutoExec and click OK.
6. Close Macro Builder. The macro will run automatically the next time the database opens.

Note: The database must be trusted for the SetWarnings action to run.

References:

• Turn delete object and action query confirmation messages on or off