AccessObject Object

AccessObject Object

See Also         Example         Properties                 

Application object
Multiple objects
Multiple objects
AccessObject object

An AccessObject object refers to a particular Microsoft Access object within the following collections.

AllForms AllTables
AllReports AllQueries
AllMacros AllViews
AllModules AllStoredProcedures
AllDataAccessPages AllDatabaseDiagrams

Remarks

An AccessObject object includes information about one instance of an object. The following table list the types of objects each AccessObject describes, the name of its collection, and what type of information AccessObject contains.

AccessObject Collection Contains information about
Form AllForms Saved forms
Report AllReports Saved reports
Macro AllMacros Saved macros
Module AllModules Saved modules
Data access page AllDataAccessPages Saved data access pages
Table AllTables Saved tables
Query AllQueries Saved queries
View AllViews Saved views
Stored procedure AllStoredProcedures Saved stored procedures
Database diagram AllDatabaseDiagrams Saved database diagrams

Because an AccessObject object corresponds to an existing object, you can't create new AccessObject objects or delete existing ones. To refer to an AccessObject object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:

AllForms(0)
AllForms("name")
AllForms![name]