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] = "Complete ", we want it to send an e-mail.…
Author
Alicia Katz Pollock
Released
2/8/2011- Creating new field with field templates
- Understanding errors
- Filtering data
- Aligning and distributing controls
- Customizing the interface
- Navigating quickly between records
- Speeding up data entry
- Analyzing a table for redundant data
- Creating a multi-field primary key
- Moving records with append and delete queries
- Transforming a query into a PivotTable or PivotChart
- Working with images, charts, and Smart Tags in forms
- Hiding duplicates in reports
- Formatting shortcuts
- Using macros
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome47s
-
-
1. Top Tips
-
Using input masks2m 39s
-
Four ways to filter data2m 56s
-
2. File Management
-
Opening recent files2m 33s
-
-
3. Ribbon and Quick Access Toolbar Tips
-
4. Interface Shortcuts
-
Right-clicking2m 47s
-
Using keyboard shortcuts2m 50s
-
5. Navigation Shortcuts
-
6. Data Entry and Editing Shortcuts
-
Undo and Redo tips2m 18s
-
Copying and pasting content2m 44s
-
Inserting today's date1m 10s
-
Using AutoCorrect1m 36s
-
Using concatenated fields2m 16s
-
Linking Outlook contacts2m 23s
-
-
7. Table Techniques
-
Creating Quick Start fields1m 49s
-
Saving application parts2m 43s
-
Setting default field types2m 55s
-
Using flag fields2m 1s
-
Using an index2m 4s
-
Filtering by selection1m 25s
-
8. Relationship Techniques
-
Using subdatasheets1m 27s
-
Using relationship reports1m 55s
-
9. Query Techniques
-
Using wildcards5m 40s
-
Using IN instead of OR1m 29s
-
Changing captions1m 30s
-
Finding duplicate records2m 13s
-
Using make-table queries2m 12s
-
Creating an update query2m 55s
-
Using SQL statements2m 31s
-
-
10. Form Techniques
-
Creating option groups2m 43s
-
Creating tabbed form layouts4m 45s
-
Inserting charts3m 41s
-
Creating your own smart tags1m 24s
-
Hiding fields in printouts1m 26s
-
Setting tab stops3m 41s
-
11. Report Techniques
-
Creating headers and footers5m 49s
-
12. Formatting Shortcuts
-
Using the Format Painter2m 25s
-
13. Macro and Event Techniques
-
Using AutoExec macros1m 53s
-
14. Database Management Techniques
-
Saving templates2m 10s
-
Locking files42s
-
-
Conclusion
-
Goodbye44s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating an After Update macro to email a customer