Turn off Make Table Query Confirmation Prompts in a Database

[Galapagos15]

I have a Report that is generated by running a series of queries and one of them is a Make Table Query. How can I disable the Confirmation Prompt for this Make Table Query in the series so the user doesn't have to click on it when they run the Report? I'm relatively new to Access so my queries were built by the Design function and not SQL etc.

Thanks in advance!

 

[Joe4]

Before the "MakeTable" Action, add a "SetWarnings" Action, and set its value to "No".
If you want to see other warning after this step runs, add another "SetWarnings" Action and set its value to "Yes".

 

[Galapagos15]

Okay, thanks I'm assuming I have to create a macro for your instructions? I thought there would be another way but that works! Thank you!

 

[Joe4]

Yes, you can disable it if you run it in a Macro or VBA code.

Note, if you are running a "series" of steps, you may be able to put them all in Macro (or VBA), and run it all with a single click.