Rum macros without aletrs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
How can i run a macro without the alerts to be shown. for example, when
running a delete macro, the messages "You are about to run a delete query
that.." ,and then "You are about to delete X rows" are shown.

Thanks,
Yoav
 
Try adding "Set warnings" to the first line of your macro. This setting
should be set to "no" by default. I beleive this has the same effect as the
VBA code of "DoCmd.SetWarnings False" which will turn off all warnings.
Let me know if this works.
 
It works, thanks!
:)

Mike said:
Try adding "Set warnings" to the first line of your macro. This setting
should be set to "no" by default. I beleive this has the same effect as the
VBA code of "DoCmd.SetWarnings False" which will turn off all warnings.
Let me know if this works.
Click to expand...
 
Back
Top