Attaching macros to objects


show more Attaching macros to objects provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Attaching macros to objects

Once you've made your Macros, you need them to be triggered in your database. One of the most common methods of activating a Macro is to assign it to a button in a form. Now that we've built a Macro to open an Order form, let's use it in our database. Click on the Queries header to collapse it, so we can see our Forms. We have a Products Split Form. That allows us to look at our products. I can imagine a sales rep looking at this form to see the prices, and wanting to place a customer's order right from here. We can put a button on the Form up, in the header.

That'll open up a blank Order Form. Click up on the View button to toggle it to Layout View, and let's make a place for the button. Click one time on the Product name. Now a button will always fill up the cell that it's in. So we're going to split this cell into three parts. Go up to the Arrange tab and choose Split Horizontally, and it splits it in half. Click on the right half, and Split it Horizontall...

Attaching macros to objects
Video duration: 2m 26s 3h 30m Beginner

Viewers:

Attaching macros to objects provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...