Microsoft Access 2010 Bible

Chapter 10: VBA Programming Fundamentals 413 Project Name Certain changes in an application’s structure require Access to recomp ...

Part II: Programming Microsoft Access 414 As an example, assume you’ve set up the following sort of statements in all the module ...

Chapter 10: VBA Programming Fundamentals 415 Before the Command-Line Arguments option was available, there was no easy way to te ...

Part II: Programming Microsoft Access 416 FIGURE 10.24 Chapter10.accdb includes frmCommandLine to demonstrate using command-line ...

417 CHAPTER Mastering VBA Data Types and Procedures IN THIS CHAPTER Naming and declaring variables Looking at the VBA data types ...

Part II: Programming Microsoft Access 418 In addition to variables, I take a look at code editor options, working with VBA proce ...

Chapter 11: Mastering VBA Data Types and Procedures ............................................................. 419 One partic ...

Part II: Programming Microsoft Access 420 Tip You can adjust the editor font and text colors to suit your particular style. In t ...

Chapter 11: Mastering VBA Data Types and Procedures . . . . . . . . . . . . . 421 Using Variables One of the most powerful conce ...

Part II: Programming Microsoft Access 422 l (^) You provide a meaningful name for the variable as part of the Dim statement. In ...

Chapter 11: Mastering VBA Data Types and Procedures 423 Although you can make up almost any name for a variable, most programmer ...

Part II: Programming Microsoft Access 424 Private Sub Combine_Implicit() strFirstName = txtFirstName strLastName = txtLastName t ...

Chapter 11: Mastering VBA Data Types and Procedures 425 In this example code, the txtSupervisor text box on the form is always e ...

Part II: Programming Microsoft Access 426 Notice that the variable name follows the Dim statement. In addition to naming the var ...

Chapter 11: Mastering VBA Data Types and Procedures 427 Tip You can declare public variables in the code module attached to a fo ...

Part II: Programming Microsoft Access 428 Table 11.1 describes the 12 fundamental data types supported by VBA. TABLE 11.1 VBA Da ...

Chapter 11: Mastering VBA Data Types and Procedures 429 Note How big is a string variable? As shown in Table 11.1, string variab ...

Part II: Programming Microsoft Access 430 Comparing implicit and explicit variables The default data type for VBA variables is t ...

Chapter 11: Mastering VBA Data Types and Procedures 431 Forcing explicit declaration Access provides a simple compiler directive ...

Part II: Programming Microsoft Access 432 One way to ease the burden of managing the code and objects in an application is throu ...