Disable message pop-ups?

[thebign]

Is there any way to customize Access to disable query pop-up messages, such as "You are about to modify 400 records..." or "You are about to delete a table..."? Is this possible either at the application, database, or macro level? Thanks in advance.

 

[ducker]

docmd.SetWarnings

and then either True(-1) or False (0)

You can also disable it within a macro

create a new macro
Action: SetWarnings - Warnings On "No"
Action: OpenQuery.....
Action: SetWarnings - Warnings On "Yes"

etc etc etc.

-Mike

 

[thebign]

Thanks ducker, that worked perfectly.