Turn_off confirm message"Table will be deleted" inside a Macro

[Don]

I am running a Macro that opens a MkTb Query. This Macro is Sub to a
RunMacro command that repeats a calculated number of times. I can not get
the Macro to run without the confirm message "Table ... will be deleted"
appearing and having to click yes on the confirm message. This Macro will
cycle as many as 200+ times. I have tried to turn off tools -- options --
confirm -- document deletions but this does not work. I am using Access
2002. Thanks for any suggestions

 

[Douglas J. Steele]

Try setting SetWarnings to False before the deletion. Don't forget to set it
back to True when you're done.

 

[Don]

Douglas solved my problem. Thanks
--
Don

Try setting SetWarnings to False before the deletion. Don't forget to set it
back to True when you're done.