Convert the Form Macros to VBA

Macros are one method of programming actions in your Mighty Access database. As we saw in the previous lesson, Visual Basic for Applications (VBA) is another.


Before You Begin: Change the View

The Customers Form is open in Form View.

Go to Form Design Tools ->Design->Views.

Choose a View: Design View.


1. Try it: Convert the Form's Macros to VBA

Go to Form Design Tools ->Design->Tools.

Click: Convert Form's Macros to Visual Basic.


You will be prompted to select the following:

Add error handling to generated functions.

Include macro comments.


Click Convert.


Now, What Do You See? In a few seconds, a pop up will say: Conversion Finished!


Click OK. Keep going...

Form Design Tools ->Design->Tools->Convert Form's Macros to Visual Basic

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: Convert Macros to Visual Basic