Turning Off Edit Confirmations
When you are running a macro in Access, you may encounter tons of confirmations for each step of the script to run. This can be disabled easily within Access.
- Go to File → Options → Client Settings
- In the Editing section, scroll down to Confirm, and uncheck all three options
- Click OK
