Creating a user interface macro


show more Creating a user interface macro provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Creating a user interface macro

The User Interface Macro is one that gets triggered when you click somewhere on a form. In the Access 2010 Essential Training course, you learned how to attach a macro to a button. In this lesson, you will see how to trigger a macro just by clicking in a Form field. Open up your Customers Order Form, and let's say you are looking at the form, and it would be handy to have quick access to the SalesReps contact information just by clicking in the SalesRep field. There are a few steps to this process. First, I have to create the little pop- up form, then I have to attach it to the SalesRep field using an Event macro.

So click on the SalesReps table, go to the Create tab and choose Form Design. Click on Add Existing Fields. We're going to add-in from the SalesReps table EmpID, LastName, FirstName, CellPhone and Email address. Now, I have to do a few things here to transform it into a small pop-up. I will highlight all of the controls, go up to the Format ribbon, and change these to size ...

Creating a user interface macro
Video duration: 4m 12s 3h 43m Intermediate

Viewers:

Creating a user interface macro provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...