hello how do i disable the warning messages built in access when i run my delete query? is it in the settings somewhere? thanks
hello how do i disable the warning messages built in access when i run my delete query? is it in the settings somewhere? thanks
I'm using 2007, but this is what I do. Make sure the "Show All Actions" button at the top of the macro design menu is selected. Then, in your action list, you'll see an option for "SetWarning". Choose that, and put "no" in the arguments. Put that line at the TOP of your macro.
However, if you use this, I also recommend using a message box at the end to tell you the macro is done running. With no warnings, there's nothing alerting you to the progress of the process.
hrmm weird, but even though i put the set warnings to no in macro, it still shows up?
The VBA code is as follows.
DoCmd.SetWarnings = True
DoCmd.SetWarnings = False
Make sure if you use one you use the other, or you could get into trouble. For extra insurance I always use the true twice. I put the false right in front on the code that causes the error and the true right after the code. I also add the true code on the main forms OnClose event just to be sure it was turned back on.
thank you!