This tutorial explains how to auto run Access Form using AutoExec Macro.
Auto Run Access Form
Access can auto run any Objects, while Access Form is the most popular Object to auto run, this tutorial will cover mainly auto run Form.
AutoExec is a reserved name for Macro, indicating that this Macro will run when Access is opened, we can make use of it to auto run any Procedure in Access.
You may also want to consider Windows Task Scheduler to auto open an Access and then execute Procedure using autoexec. Click the below link to read more about Windows Task Scheduler.
Method 1 to Auto Run Access From – Select Display Form
In Access 2013, navigate to Options > Current Database > Display Form, where you can choose from a list of Forms in the database. The form will auto open once Access is opened.
Method 2 to Auto Run Access From – Create Macro
Create a Macro: Create > Macro > Open Form > select Form1 in Form Name
Save Macro as “autoexec”
Now you see the below autoexec Macro in the Navigation Pane, Form1 will pop up when Access is reopened.
Method 3 to Auto Run Access From – Write VBA code
This method uses DoCmd.openForm to open Form. If you try to run other Procedure other than auto opening a Form, you should use this Method.
Press ALT+F11 > Insert Module > copy and paste the below Function
Create a Macro to use this Function: Create > Macro > RunCode > type openForm() in Function Name
Finally, save Macro as “autoexec”