Table of Contents
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 Combo Boxes and List Boxes 201
Chapter 11: Creating Your Own Functions 239
Chapter 12: Testing and Debugging Your Code 265
Part V: Reaching Out with VBA 293
Chapter 13: Using VBA with Multiple Databases 295
Chapter 14: Integrating with Other Office Applications 315
Part VI: The Part of Tens 349
Chapter 15: Ten Commandments of Writing VBA 351
Chapter 16: Top Ten Nerdy VBA Tricks 357
Index 367
