Microsoft Access 2010 Bible

Chapter 11: Mastering VBA Data Types and Procedures 433 address that is known by anyone passing by the building; each office or ...

Part II: Programming Microsoft Access 434 Consider two variables named MyVariable. One of these variables is global (public) in ...

Chapter 11: Mastering VBA Data Types and Procedures 435 between calls to the procedure. Once a value has been assigned to a stat ...

Part II: Programming Microsoft Access 436 you don’t run the risk of an error occurring from having a procedure and module with t ...

Chapter 11: Mastering VBA Data Types and Procedures 437 Note A module is a container for multiple subprocedures and functions. C ...

Part II: Programming Microsoft Access 438 Figure 11.9 shows a typical subroutine. Notice the Sub keyword that begins the routine ...

Chapter 11: Mastering VBA Data Types and Procedures 439 l Statements: A VBA procedure can contain many statements. Usually, howe ...

Part II: Programming Microsoft Access 440 Me.Recalc If Not IsNull(cboBuyerID) Then ‘Verify that the DiscountPercent is valid: If ...

Chapter 11: Mastering VBA Data Types and Procedures 441 FIGURE 11.10 The frmSales cboBuyerID_AfterUpdate event procedure in the ...

Part II: Programming Microsoft Access 442 Move to the bottom of the module, and enter the following code: Public Function Calc ...

Chapter 11: Mastering VBA Data Types and Procedures 443 The completed CalcExtendedPrice function is shown in Figure 11.11. Notic ...

Part II: Programming Microsoft Access 444 FIGURE 11.12 Testing the CalcExtendedPrice function in the Immediate window The next t ...

Chapter 11: Mastering VBA Data Types and Procedures 445 In Figure 11.13, notice that the Control Source property for txtAmount s ...

Part II: Programming Microsoft Access 446 Actually, better would be to place this statement in the AfterUpdate event of fsubSale ...

Chapter 11: Mastering VBA Data Types and Procedures 447 An important feature of this example code is that it combines data extra ...

Part II: Programming Microsoft Access 448 FIGURE 11.15 frmNamedArguments demonstrates the value of using named arguments in VBA ...

Chapter 11: Mastering VBA Data Types and Procedures 449 Summary Building on the VBA programming fundamentals presented in Chapte ...

...

451 CHAPTER The Access Event Model IN THIS CHAPTER Mastering Access event programming Reviewing common events Understanding even ...

Part II: Programming Microsoft Access 452 Programming Events An Access event is the result or consequence of some user action. A ...