1. Record changes
2. Document deletions such as deleting a table or report
3. Action queries such as insert, update, or delete query.

Because the process is long and complex, it quickly becomes annoying and unnecessary that you have to confirm the action each time Access pops up a confirmation dialogue box.

To disable all these Access prompt pop-ups, it's a simple configuration change in Access options and majority of these pop-up dialogue boxes should be gone forever.

For Access 97, 2000, XP, 2003

1. Go to Tools -> Options on the menu bar.

2. Click the Edit/Find tab and uncheck the three checkboxes in Confirm section. See below.

3. Click OK to close the Options windows.

For Access 2007

1. Click the Office Button at the top left corner of Access window.

2. Click Access Options button.

3. Click Advanced tab in the left hand side navigation menu and uncheck the three checkboxes in Confirm section. See below.

4. Click OK to close all the windows.

Now run your process again in Access, you will be pleased you'd not be prompted as to whether or not you want to take the action. Most of the prompts are gone.

However, sometimes you may come across odd occasions where you unselected the three checkboxes, but you still get prompts. The cause could be in either the VBA code or behind the code for Form event properties (e.g. BeforeDelConfirm Event property) in your Access database.

In VBA, the DoCmd.SetWarnings method can be used to turn system messages on or off.

Please note that, if you turn the display of system messages off in Visual Basic, you must turn it back on, or it will remain off. That is, you must use DoCmd.SetWarnings method in pairs. It's something like below. You turn it off, do something, then turn it back on.

DoCmd.SetWarnings False

' Do something here
strSQL = "DELETE * FROM customers"
DoCmd.RunSQL strSQL

DoCmd.SetWarnings True

The effect of the above code may also vary between versions of Access. It may work in Access 2000, but certain actions may not work in Access 2003 or other versions. You need to test the code on individual basis.

Happy Unpromting!


Copyright© GeeksEngine.com