O'Reilly logo

Microsoft® Access VBA Programming for the Absolute Beginner by Michael Vine

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

CHAPTER 11OBJECT-ORIENTED PROGRAMMING WITH ACCESS VBA

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!

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

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