Set Warnings Off
Just upgraded to Access 2007. There used to be a feature in Macros to Set Warnings to off - so when your macro was running update or append queries you didn't get a message.
How to you turn those off in Access 2007?
well, first off, VBA > Macros.
As far as it having changed in 20087, I dont believe it has. It should be under SetWarnings, like always
Note that 2007 does not enable all macro actions by default, "for your own good". I think Set Warnings is one of them. With the macro in design view, on the design tab of the ribbon is a button called "Show all actions".