Appendix A: Access Object Model

team lib

The full Access object model is extremely large, so we've decided to give you a cut-down version, highlighting the most important objects. So, unlike the two data access object models, what you've got here are the main objects. One of the reasons why it's not feasible to print the whole object model is that each property, method and event would be shown. When designing a form, if you look at the properties for a control, you'll see how many there are for just that one control. Now add in every other object, and you've got a lot of properties, many repeated.

Below is a list of the objects. We've also added the Method Calls as these are really useful for a reference, but we've left out all of the methods , properties and events of the objects.

Objects

Name

Description

AccessObject

Refers to a particular Access object, such as a Form or Report.

AccessObjectProperty

A built-in or user defined property of an Access object.

AccessObjectProperties

A collection of AccessObjectProperty objects.

AllDataAccessPages

A collection of AccessObject objects for each data access page.

AllDatabaseDiagrams

A collection of AccessObject objects for each database diagram in an Access Project.

AllForms

A collection of AccessObject objects for each form.

AllFunctions

A collection of objects that represent the functions exposed by the CurrentData or CodeData objects. AllFunctions is of type AccessObject .

AllMacros

A collection of AccessObject objects for each macro.

AllModules

A collection of AccessObject objects for each module.

AllQueries

A collection of AccessObject objects for each query.

AllReports

A collection of AccessObject objects for each report.

AllStoredProcedures

A collection of AccessObject objects for each stored procedure in an Access Project.

AllTables

A collection of AccessObject objects for each table.

AllViews

A collection of AccessObject objects for each view in an Access Project.

Application

The main Access application.

BoundObjectFrame

An OLE Object bound to a column in a table.

Checkbox

A Yes/No checkbox.

CodeData

An object containing collections that represent programming objects within a database. These collections include AllTables , AllFunctions , AllQueries , AllViews , AllStoredProcedures and AllDatabaseDiagrams

CodeProject

An object that represents an Access project or database. Contains the following collections of AccessObject type objects: AllForms , AllReports , AllMacros , AllModules and AllDataAccessPages .

Combobox

A combo box.

CommandButton

A command button.

Control

A generic control on a form or report.

Controls

A collection of Control objects.

CurrentData

The current data database.

CurrentProject

The current code database.

CustomControl

An object that represents an ActiveX control used in a form, data access page or report. This object provides programmatic access to the custom properties dialog for the control.

DataAccessPage

A data access page.

DataAccessPages

A collection of DataAccessPage objects.

DefaultWebOptions

Default options for saving web pages.

DoCmd

Allows running of actions.

Form

A form.

Forms

A collection of Form objects.

FormatCondition

A conditional format for a combo box or text box on a form or report.

FormatConditions

A collection of FormatCondition objects.

GroupLevel

The group level used when sorting or grouping in a report.

Hyperlink

Represents an Internet hyperlink.

Image

An image control.

ItemsSelected

A collection of items selected in a multi-select list box.

Label

A label control.

Line

A line control.

ListBox

A list box control.

Module

A code module.

Modules

A collection of Module objects.

ObjectFrame

An OLE Object or ActiveX component.

OptionButton

An option button control.

OptionGroup

An option group control.

Page

A page on a tab control.

Pages

A collection of Page objects.

PageBreak

A page break control on a form or report.

Printer

An object representing a printer.

Printers

A collection of printer objects.

Property

An individual property of an object.

Properties

A collection of Property objects.

Recordset

A collection of records.

Rectangle

A rectangle object.

Reference

A reference set to an external object (such as a type library).

References

A collection of Reference objects.

Report

A report.

Reports

A collection of Report objects.

Screen

The form, report or control that has the focus.

Section

A section of a form or report.

SubForm

A sub-form control.

SubReport

A sub-report control.

TabControl

A tab control.

Textbox

A text box control.

ToggleButton

A toggle button control.

WebOptions

The properties of a data access page.

 
team lib


Beginning Access 2002 VBA
Beginning Access 2002 VBA (Programmer to Programmer)
ISBN: 0764544020
EAN: 2147483647
Year: 2003
Pages: 256

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net