remove about to delete before macro is run

  • Thread starter Thread starter Pammy
  • Start date Start date
P

Pammy

Is there a way to run a macro to delete a table and then append updated
information without it prompting me that it is about to delete and then to
prompt that it is about to append? I do not want to see this if possible.

Thanks,
 
You can use the Set Warnings to false before your query commands then set it
back to true after the commands.
Hope this helps.
wf
 
Pammy,

Add a SetWarnings/No action to your macro, before the first of your
OpenQuery actions.
 
Back
Top