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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.