Enable / Disable Function in VBA and Microsoft Access

Here is a function that first Disables, then Enables (or re-enables) all of the “pop-ups” in Access when running queries. If you use the code, I’d love to hear your comments on how it worked for you and how you’re incorporating it into your projects.

When running code, the last thing you want is something like the “Are You Sure You Want to Delete Record” pop-up intruding upon the progress of your code. Simply insert your code between the functions and place in your module as follows;

Function DisableActionQuery()

Application.SetOption “Confirm Action Queries”, False

End Function

PLACE YOUR CODE HERE

Function EnableActionQuery()

Application.SetOption “Confirm Action Queries”, True

End Function

Enjoy!!

Tagged as: Access, VBA