How to Create Autoexec Macro MS Access

Quick summary

An AutoExec macro in Microsoft Access runs automatically every time a database is opened, making it ideal for automating startup tasks. By naming a macro exactly AutoExec, Access recognizes and executes it without any manual trigger.

Steps

1. Go to the Create tab in the ribbon.
2. Click on Macro in the Macros & Code group.
3. In the macro design window, use the drop-down in the Action column to select the actions you want the macro to perform.
4. Configure each action's properties as needed.
5. Click the save icon to proceed.
6. Name the macro AutoExec — this name is mandatory for it to run automatically — then click OK to save.
7. Close and reopen the database, then click Run to verify.
8. The AutoExec macro will now run automatically each time the database opens.