remove about to delete before macro is run

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,
 
W

wesjr

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
 
S

Steve Schapel

Pammy,

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