Rum macros without aletrs

[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

 

[Guest]

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.

 

[Guest]

It works, thanks!

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.