How to turn off the make-table query warning message.
Q: Steve Mason wants to know how to turn off the warning message saying “X table will be deleted” before the query runs.
A: Open the Options dialog (Tools|Options) and click the Edit/Find tab. In the Confirm section there are three checkboxes that control whether you will get a confirmation for Record changes, Document deletions, or Action queries. Uncheck the Action queries one to suppress the confirmation message when running the make-table query.
In VBA code, you can temporarily suppress warnings with this line of code:
DoCmd.SetWarnings False