Make query macro with automatic YES

[Pierce]

I have a macro that runs a Make table query once a button is pushed
When the macro runs the Make table query it prompts the user to be sur
if they would like to overwrite the original table. Is it possible fo
me to make the macro so that it will answer yes for the user and the
never see the prompt? I've tried adjusting the options under the tool
menu for prompting table changes but that didn't work.

TIA

 

[diana]

You can use the RUNCOMMAND : CUT in the Macro , to delete the old table,
right before you the Make Table query. This will delete the old table and
there will be no need for the automatic prompt by Access.

 

[Steve Schapel]

Pierce,

Put a SetWarnings/No action in your macro ahead of the OpenQuery action.