Macros can be setup in Access to help streamline your tasks. Typically after saving a macro you would link it to a button or attach it to a form. This post will teach you how to execute automatically a macro when a user opens up the database. Lets say I typically run a few custom reports the first thing after opening the database. So first I will create a macro that opens the reports I want each time the database is opened.
The last thing I do after tasking the macro is to save the macro as “AutoExec”. When a macro is saved as “AutoExec” it will trigger an event to run the macro after the database is opened.
Make sure you do not include spaces while naming it “AutoExec”.