F. Scott Barker’s Microsoft Access 2002 Power Programming

Chapter 4. Working with Access Collections and Objects

IN THIS CHAPTER

• Creating Custom Collections 80

• Comparing Custom Collections to Arrays 83

• Accessing the Access Object Model 86

• Programming Multiple Copies of the Same Form 104

In Chapter 2, “Coding in Access 2002 with VBA,” you learned how to create custom methods and properties, and were introduced to the basics of collections. In this chapter, you build on those basics to learn about the other objects available in Access 2002. You can find this chapter’s code examples in the \Examples\Chap04 folder on the book’s Web page at www.samspublishing.com. In the Chap04.mdb database, you find code modules that contain all the sample functions and subroutines, as well as forms to demonstrate event-handling ...