Microsoft Access Programmers Greensboro North Carolina

Microsoft Access Programmer Information

Call MS Access Solutions at (323) 285-0939 For Complimentary Consultation

Creating a Custom Collection

Defining a custom collection is easy: Simply use the Dim keyword to create an object of the type Collection, as shown here:

Dim colSports As New Collection

The Dim statement tells the compiler you want to declare a variable, and the As New keywords indicate that you're creating a new instance of something. Specifically, you're creating a new instance of a Collection object. In the following sections, look at how you can add items to and remove items from a custom collection.

Adding Items to a Custom Collection

The Add method adds a new item to a custom collection. It looks like this:

colSports.Add "Basketball"

This line of code adds the text "Basketball" to the colSports collection. The Add method has three optional arguments: Key, Before, and After. Key is a string name you can use to uniquely identify an element; the Before and After arguments enable you to specify where in the collection the new item will be placed.

CAUTION

Unlike almost every other array or collection in VBA, custom collections are one-based rather than zero-based. This means that the first element is numbered one (rather than zero), the second element is numbered two, and so on. This is a big change if you're accustomed to thinking of arrays and collections as being only zero-based.

Access programmer cities we serve: Access Programmers North Carolina