Description
Book SynopsisGet the scoope on how to use VBA to create more powerful Access databases and applications.
Table of ContentsIntroduction 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
Chapter 13: Using VBA with Multiple Databases 297
Chapter 14: Integrating with Other Office Applications 317
Part VI: The Part of Tens 349
Chapter 15: Ten Commandments of Writing VBA 351
Chapter 16: Top Ten Nerdy VBA Tricks 357
Chapter 17: (Way More Than) Ten Shortcut Keys 367
Index 371
