Microsoft Access 2010 Bible

Chapter 15: Using Access Data Macros ....................................................................................... 553 ...

Part II: Programming Microsoft Access 554 Adding data macros to a table is quite easy. In fact, an Access table doesn’t even hav ...

Chapter 15: Using Access Data Macros 555 Double-clicking on the After Update ribbon command opens the Macro Designer (shown in F ...

Part II: Programming Microsoft Access 556 The same view is obtained somewhat differently if the table is in Design view. If the ...

Chapter 15: Using Access Data Macros 557 Using the Action Catalog The Action Catalog on the right side of the Macro Designer ser ...

Part II: Programming Microsoft Access 558 FIGURE 15.4 The If block conditionally executes macro actions. Condition Additional br ...

Chapter 15: Using Access Data Macros 559 Figure 15.5 also shows how IntelliSense helps you compose the expressions used in data ...

Part II: Programming Microsoft Access 560 l (^) ForEachRecord: The ForEachRecord action is a looping construct. Given the name o ...

Chapter 15: Using Access Data Macros 561 to USysApplicationLog anytime you want from a data macro. The only field in USysApplica ...

Part II: Programming Microsoft Access 562 l (^) RaiseError: The RaiseError macro action passes an error up to the user interface ...

Chapter 15: Using Access Data Macros 563 FIGURE 15.6 Using BeforeChange to update a field BeforeChange fires for both updates to ...

Part II: Programming Microsoft Access 564 FIGURE 15.7 Using IsInsert to determine if BeforeChange fired as the result of adding ...

Chapter 15: Using Access Data Macros 565 FIGURE 15.8 Using AfterInsert to add a record to tblProductActivityLog Setting fields i ...

Part II: Programming Microsoft Access 566 FIGURE 15.9 A typical log table updated with an AfterInsert data macro The AfterInsert ...

Chapter 15: Using Access Data Macros 567 When you double-click an item, it’s added to the macro in its most logical destination. ...

Part II: Programming Microsoft Access 568 FIGURE 15.11 SetLocalVar has been added to the body of the If block Beginning of If bl ...

Chapter 15: Using Access Data Macros 569 FIGURE 15.12 A simple macro that updates a local variable Manipulating macro items In F ...

Part II: Programming Microsoft Access 570 FIGURE 15.13 Hovering the mouse over SetLocalVar Collapse button Builder button Delete ...

Chapter 15: Using Access Data Macros 571 FIGURE 15.14 The Expression Builder helps construct complex expressions. FIGURE 15.15 A ...

Part II: Programming Microsoft Access 572 Moving macro items In Figure 15.16, two more If blocks have been added to the macro. E ...