Alison Balter’s Mastering Microsoft Access 2002 Desktop Development

Chapter 12. Advanced VBA Techniques

<feature><title>In This Chapter</title>

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

• Working with Constants 512

• Working with Arrays 515

• Advanced Function Techniques 521

• Working with Empty and Null 529

• Creating and Working with Custom Collections 535

• Low-Level File Handling 539

• Understanding and Effectively Using Compilation Options 539

• Importing and Exporting Code Modules 540

• Working with Project Properties 541

</feature>

Why This Chapter Is Important

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