Access contains a hidden collection called the AllObjects collection. Chances are you'll never use this collection directly, but it happens to be the parent object of several collections that are commonly used. These collections are:
|AllDatabaseDiagrams||Contains an object for each database diagram in a SQL Server database. Applies to ADP files only.|
|AllForms||Contains an object for each form in a database or project file.|
|AllFunctions||Contains an object for each user-defined function in a SQL Server database. Applies to ADP files only.|
|AllMacros||Contains an object for each macro in a database or project file.|
|AllModules||Contains an object for each module in a database or project file.|
|AllQueries||Contains an object for each query in an Access database (ACCDB or MDB).|
|AllReports||Contains an object for each report in a database or project file.|
|AllStoredProcedures||Contains an object for each stored procedure in a SQL Server database. Applies to ADP files only.|
|AllTables||Contains an object for each table in a database or project file.|
|AllViews||Contains an object for each view in a SQL Server database. Applies to ADP files only.|
Each of these collections contains AccessObject objects that are described in a later section. Because these collections all derive from the AllObjects collection, they have the same properties and methods. For example, take a closer look at the AllForms collection.
As its name implies, the AllForms collection contains an Access ...