CodeProject Object [Access 2003 VBA Language Reference]
Application.gif) CodeProject.gif) Multiple objects |
The CodeProject object refers to the project for the code database of a Microsoft Access project (.adp) or Access database (.mdb).
Using the CodeProject Object
The CodeProject object has several collections that contain specific AccessObject objects within the code database. The following table lists the name of each collection defined by Access project and the types of objects it contains.
| Collections | Object type |
|---|---|
| AllForms | All forms |
| AllReports | All reports |
| AllMacros | All macros |
| AllModules | All modules |
| AllDataAccessPages | All data access pages |
Note The collections in the preceding table contain all of the respective objects in the database regardless if they are opened or closed.
For example, an AccessObject object representing a form is a member of the AllForms collection, which is a collection of AccessObject objects within the current database. Within the AllForms collection, individual members of the collection are indexed beginning with zero. You can refer to an individual AccessObject object in the AllForms collection either by referring to the form by name, or by referring to its index within the collection. If you want to refer to a specific object in the AllForms collection, it's better to refer to it by name because a item's collection index may change. If the object name includes a space, the name must be surrounded by brackets ([ ]).
| Syntax | Example |
|---|---|
| AllForms!formname | AllForms!OrderForm |
| AllForms![form name] | AllForms![Order Form] |
| AllForms("formname") | AllForms("OrderForm") |
| AllForms(index) | AllForms(0) |
Properties | AccessConnection Property | AllDataAccessPages Property | AllForms Property | AllMacros Property | AllModules Property | AllReports Property | BaseConnectionString Property | Connection Property | FileFormat Property | FullName Property | IsConnected Property | Name Property | Path Property | ProjectType Property | Properties Property | RemovePersonalInformation Property
Methods | CloseConnection Method | OpenConnection Method | UpdateDependencyInfo Method
Parent Objects | Application Object
Child Objects | AccessObjectProperties Object | AllDataAccessPages Object | AllForms Object | AllMacros Object | AllModules Object | AllReports Object
See Also | AllDataAccessPages Collection | AllForms Collection | AllMacros Collection | AllModules Collection | AllReports Collection | Application Object | CurrentProject Object