Microsoft Access 2010 Bible

Chapter 9: Presenting Data with Access Reports 373 FIGURE 9.40 The completed report in Print Preview Summary Reports are an impo ...

Part I: Access Building Blocks 374 In this chapter, you read about the different types of Access reports, learned how to use the ...

Part II Programming Microsoft Access IN THIS PART Chapter 10 VBA Programming Fundamentals Chapter 11 Mastering VBA Data Types an ...

14_475348-pp02.indd 37614_475348-pp02.indd 376 4/1/10 1:46 PM4/1/10 1:46 PM ...

377 CHAPTER VBA Programming Fundamentals IN THIS CHAPTER Working with VBA Reviewing VBA terminology Understanding VBA code basic ...

Part II: Programming Microsoft Access Part II: Programming Microsoft Access 378 Introducing Visual Basic for Applications Visual ...

Chapter 10: VBA Programming Fundamentals ............................................................................ 379 If you ...

Part II: Programming Microsoft Access 380 l (^) Statement: A single VBA word or combination of words that constitutes an instruc ...

Chapter 10: VBA Programming Fundamentals  . . . . . . . . . . . . . . . . . . . . 381 Each VBA statement is an instruction that ...

Part II: Programming Microsoft Access 382 Knowing when to use macros and when to use VBA In Access, macros often offer a great w ...

Chapter 10: VBA Programming Fundamentals 383 as you review every macro in your macro libraries. You can’t cut and paste a macro ...

Part II: Programming Microsoft Access 384 Select the options that include error handling and comments, and click Convert. Acce ...

Chapter 10: VBA Programming Fundamentals 385 Using the Command Button Wizard One option when adding a button to an Access form i ...

Part II: Programming Microsoft Access 386 FIGURE 10.5 Examples of Command Button Wizard buttons FIGURE 10.6 The Go To First Reco ...

Chapter 10: VBA Programming Fundamentals 387 filter. You might find yourself saying, “I’m tired of typing this formula into.. .” ...

Part II: Programming Microsoft Access 388 Subprocedures A subprocedure (or sub) is the simplest type of procedure in a VBA proje ...

Chapter 10: VBA Programming Fundamentals 389 Function nSquareFeet(Height As Double, _ Width As Double) As Double ‘Assign this fu ...

Part II: Programming Microsoft Access 390 Standard modules Standard modules are independent from forms and reports. Standard mod ...

Chapter 10: VBA Programming Fundamentals 391 FIGURE 10.7 Accessing a control’s event procedure from the Property Sheet Notice th ...

Part II: Programming Microsoft Access 392 Think of a module as a collection of procedures. Your Access databases can contain tho ...