Creating an After Update macro to email a customer


show more Creating an After Update macro to email a customer 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 an After Update macro to email a customer

An After Update data macro allows you to perform an action upon adding, updating or deleting a record. In our database, when a customer's order is marked Complete, it will be nice to send them an e-mail letting them know that their olive oil has been shipped. We can build this action right into our Orders table. To do this, open up your Orders table, and up on the Ribbon under Table tools, click on the Table tab, click on the After Update button. A Macro window will appear. In the first box, pull it down and choose If, and our criterion is going to be [OrderStatus.] And notice, as soon as I start typing, it auto fills with my possible matches.

I will pick OrderStatus off of my list. Put in an equals sign, a quotation mark, and then the word Complete. The square brackets around OrderStatus tell Access to look in that field, the equals sign tells it what to look for, and the Complete goes in quotes to show that it's a text value. Now, we will add an action. So If [OrderStatus] = "...

Creating an After Update macro to email a customer
Video duration: 2m 11s 3h 43m Intermediate

Viewers:

Creating an After Update macro to email a customer 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 ...