To add a macro to a form in Access 2013 or 2016:

1. Create a macro
2. Now, open the form in Design view
3. Click the Button icon in the Ribbon (from the DESIGN tab)
4. In the Form Detail area, click and drag the cursor so that it forms a square or rectangle (i.e. shape of a button). The Command Button Wizard will pop up. Select Miscellaneous > Run Macro and click Next
5. Select the name of the macro you want to run and click Next
6. Choose whether to display text or an image on the button and click Next
7. Give the button a name and click Finish

Continue reading →

To create a macro in Microsoft Access 2013 or 2016:

1. Click Macro from the CREATE tab
2. Add actions by selecting an action from the combo box
3. Customise the actions if required
4. Repeat steps 2 and 3 for each action you want to add
5. Save the macro

Continue reading →