Automate Confirmation Of Table Delete Message 1

[RichardOneil]

Hi-

I have a Access macro that runs 4 "Make Table" queries in succession. At the beginning of each macro, I get the "The Existing Table Will Be Deleted, Do You Want To Continue" warning. Is there a way through code that I can automate the response to "Yes" or bypass the message altogether.

 

[PHV]

Take a look at SetWarnings

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RichardOneil]

Thank you for the help.

This code did the trick

DoCmd.SetWarnings False
DoCmd.RunMacro "macroname"
DoCmd.SetWarnings True