From the Access menu
Tools, Options, and select the Edit/Find tab.
In the Confirm section, uncheck the warning messages you don't want to see.

Signature
Dave Hargis, Microsoft Access MVP
> How do you bypass all of the "You are about to" messages that pop up when you
> run an append or delete query so it just runs without you having to hit the
> yes button in the message?