F. Scott Barker's Microsoft® Access 2000 Power Programming

CREATING CUSTOM COLLECTIONS

Chapter 2 introduced you to the object-oriented concepts available in Access 2000. In that chapter, you accessed the various properties and methods of Access objects, and you defined custom properties and methods. You also learned of a special type of object—the collection. Collections allow you to maintain lists of elements without worrying about the complexities revolving around managing the list.

Consistent with your ability to create custom properties and methods, VBA also lets you create your own custom collections. The most obvious use of this feature is to replace arrays. Arrays are very difficult to manage, especially for adding and removing elements. By using collections in place of arrays, you can avoid many ...