graphic2
graphic1

Exam 77-424: Microsoft Access 2013
4.0 Create Forms
4.3 Format a Form: Modify Existing Forms (Convert Macros to VBA)

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

graphic3