O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required