Turn Off Warnings

[gfbush]

I have a some Queries, that modify / delete data in a couple of tables. When I run them in 2007, I get the 'you are about to delete x records'. As these have been used successfully for a while now, I'd like to suppress them for these queries, I know I can turn off the warnings globally through Access Options, but recognise that this isn't good practice.

I have also seen that in 2003 you can switch them off using a Macro 'SetWarnings' but this doesn't appear to be an option in 2007. I have used the Query Wizard to create them and don't have any SQL VBA experience, is there a way to switch them off.

 

[pbaldy]

SetWarnings is still an option. Some options are disabled by default. With the macro in design view, note the option on the ribbon that says "Show all actions"

 

[boblarson]

It is still there in 2007. But if you are using macros, then you need to click the SHOW ALL ACTIONS button as they don't give you those up front as they are not considered "safe" actions.

 

[boblarson]

Darn, not fast enough today

 

[pbaldy]

Fastest fingers in the west!

 

[gfbush]

Hey, brilliant guys, another problem solved.....

 

[pbaldy]

No problemo. 2007 does a lot to protect us from ourselves.