Alison Balter's Mastering Access 97 Development, Second Edition

Chapter 9. Advanced VBA Techniques

• Navigation Tips and Tricks

• Executing Procedures from the Module Window

• The DoCmd Object: Performing Macro Actions

• What Are User-Defined Types and Why Would You Use Them

• Working with Constants

• Working with Arrays

• Advanced Function Techniques

• Property Let and Get: Working with Custom Properties

• Class Modules

• Working with Empty and Null

• Understanding and Effectively Using Compilation Options

• Customizing the IDE

• Practical Examples: Putting Advanced Techniques to Use in the Time and Billing Application

The Visual Basic for Applications (VBA) language is extremely rich and comprehensive. VBA is covered throughout this book as it applies to different topics, but this chapter focuses on some advanced application development techniques. ...