Access VBA Programming For Dummies [Paperback]

• This friendly, easy-to-use guide shows experienced Access users how to use
• VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers
• Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects
• Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops
• Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming
• Author has written more than ninety computer books and has been working with databases since the early 1980s

Introduction 1

Part I: Introducing VBA Programming 7

Chapter 1: Where VBA Fits In 9

Chapter 2: Your VBA Toolkit 21

Chapter 3: Jumpstart: Creating a Simple VBA Program 35

Part II: VBA Tools and Techniques 49

Chapter 4: Understanding Your VBA Building Blocks 51

Chapter 5: Controlling Access through VBA 71

Chapter 6: Programming Access Forms 87

Part III: VBA, Recordsets, and SQL 115

Chapter 7: The Scoop on SQL and Recordsets 117

Chapter 8: Putting Recordsets to Work 147

Part IV: Applying VBA in the Real World 173

Chapter 9: Creating Your Own Dialog Boxes 175

Chapter 10: Customizing Lists and Drop-Down Menus 201

Chapter 11: Creating Your Own Functions 241

Chapter 12: Testing and Debugging Your Code 267

Part V: Reaching Out with VBA 295<l+