15. Working with the Application Collections

Investigating the Application Collections

You know, of course, that Access has all sorts of objects in each database: tables, forms, macros, and so on. And you’ve already worked with some of those objects in VBA. For example, you know how to open a form or preview a report from VBA by now. But there are other ways to work with Access objects by using the built-in application collections. Figure 15.1 shows the portion of the Access object model that includes these collections.

Figure 15.1 The application collections and related objects.

Get Business solutions Automating Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.