Have you ever wondered how objects, methods, properties, and collections in VBA are created? Well, this chapter shows you how to leverage the power of object-oriented programming (also known as OOP) in Access VBA to create your very own custom objects, methods, properties, and collections!
Collections are a data structure similar to arrays in that they allow you to refer to a grouping of items as one entity. Collections, however, provide an ordered means for grouping not only strings and numbers, but objects as well. As demonstrated next, the Collection object is used to create a collection data structure.
Dim myCollection As New Collection
Collections are popular ...