This repository has been archived by the owner. It is now read-only.
Permalink
Fetching contributors…
Cannot retrieve contributors at this time
3747 lines (3746 sloc) 248 KB

Introduction to Access VBA

Concepts

Settings

Set References to Type Libraries

Set a Reference to a Visual Basic Project in Another Microsoft Access Database or Project

Set Options from Visual Basic

Set Properties by Using Visual Basic

Set Startup Properties and Options in Code

Criteria Expressions

Date and Time Criteria Expressions

Date and Time Criteria from a Control on a Form

Multiple Fields in Criteria Expressions

Numeric Criteria Expressions

Numeric Criteria from a Control on a Form

Textual Criteria Expressions

Textual Criteria from a Control on a Form

Quotation Marks in Strings

Restrict Data to a Subset of Records

Calculate Fields in Domain Aggregate Functions

Functions (Alphabetical List)

Functions (Category List)

Error Codes

Error Trapping

Elements of Run-Time Error Handling

Scoping and Object-Naming Compatibility

Custom Methods and Properties

Improvements in Compilation Performance

Macro Actions and Methods of the DoCmd Object

Using Enumerated Constants in Microsoft Access 2002 and Later

Comparison of Data Types

Call Procedures in a Subform or Subreport

Program with Class Modules

Structured Query Language (SQL)

Use International Date Formats in SQL Statements

Build SQL Statements that Include Variables and Controls

Create and Delete Tables and Indexes Using Access SQL

Define Relationships Between Tables Using Access SQL

Group Records in a Result Set Using Access SQL

Insert, Update, and Delete Records From a Table Using Access SQL

Modify a Table's Design Using Access SQL

Perform Joins Using Access SQL

Retrieve Records Using Access SQL

Use Aggregate Functions to Work with Values in Access SQL

Data Access Objects (DAO)

Add a Record to a DAO Recordset

Build SQL Statements That Include Variables and Controls

Change Tables Involved in a One-to-Many Relationship in a DAO Recordset

Count the Number of Records in a DAO Recordset

Create a DAO Recordset From a Form

Create a DAO Recordset From a Query

Create a DAO Recordset From a Table In the Current Database

Create a User-Defined Property

Delete a Record From a DAO Recordset

Detect the Limits of a DAO Recordset

Extract Data from a Record in a DAO Recordset

Find a Record in a Dynaset-Type or Snapshot-Type DAO Recordset

Find a Record in a Table-Type DAO Recordset

Find the Current Position in a DAO Recordset

Make Bulk Changes to a DAO Recordset

Manipulate Multivalued Fields With DAO

Mark a Position in a DAO Recordset

Modify a Query from a DAO Recordset

Modify an Existing Record in a DAO Recordset

Move Through a DAO Recordset

Read From and Write To a Field in a DAO Recordset

Return a Random Record from a DAO Recordset

Set Properties of Data Access Objects in Visual Basic

Sort Data in a DAO Recordset

Synchronize a DAO Recordset's Record with a Form's Current Record

Track Design Changes to a Table-Type DAO Recordset

Work With Attachments In DAO

Use Transactions in a DAO Recordset

ActiveX Data Objects (ADO)

Bind a Form to an ADO Recordset

Build SQL Statements That Include Variables and Controls

Set Properties of ActiveX Data Objects in Visual Basic

Create an ADO Connection String

XML

Export a Report to XML

Export Data, Schema, and Related Tables to XML

Forms - User Input

Add a Value to a Bound Combo Box

Determine Whether The Current Record is a New Record In a Form

Display a Custom Dialog Box When the User Deletes a Record

Perform Simple Data Validation Checks When Editing a Record in a Form

Prompt a User Before Saving a Record

Use Numeric Criteria from a Control on a Form

Use Textual Criteria from a Control on a Form

Use User Input to Build Filter Criteria

Controls

Add "(All)" to a Combo Box or List Box

Allow Users to Add Items to an Unbound Combo Box

Assign a Control a Value From a Table

Call Procedures in a Subform or Subreport

Hide a Subform if the Main Form Contains No Records

Prevent the Accidental Erasure of Data When Moving Between Controls on a Form

Refer to Tab Control Objects in VBA

Set Form, Report, and Control Properties in Code

Forms Design

Create Multiple Instances of a Form

Synchronize Two Combo Boxes on a Form

Create a DAO Recordset From a Form

Use Date and Time Criteria from a Control on a Form

Apply a Filter When Opening a Form or Report

Cancel an Event

Cancel the Deletion of a Record by Using Custom Criteria

Change the Filter or Sort Order of a Form or Report

Disable PAGE UP and PAGE DOWN Keys in a Form

Prompt a User Before Closing a Form

Suspend Code Execution Until a Pop-up Form is Closed

Reports

Create Alternating Row Colors on a Report

Set Form, Report, and Control Properties in Code

Printing

Programmatically Retrieve Printer Capabilities

Retrieve a List of Installed Printers

Work with Form and Report Printer Settings

Retrieve a List of Installed Printers

Close a Report Automatically If It Does Not Contain Any Records

Cancel an Event

Filter a Report Using a Form's Filter

Change the Filter or Sort Order of a Form or Report

Date/Time

Calculate Age

Calculate and Display Specific Date Values

Calculate Elapsed Time

Find the Number of Working Days Between Two Dates

Format Dates as U.S. Dates Regardless of Regional Settings

Specify Date and Time in Criteria Expressions

Criteria Expressions

Calculate Fields in Domain Aggregate Functions

Include Quotation Marks in String Expressions

Sort Records in Case-Sensitive ( ASCII) Order

Use Multiple Fields in Criteria Expressions

Use Numeric Criteria in Expressions

Use Numeric Criteria from a Control on a Form

Use Textual Criteria Expressions

Use Textual Criteria from a Control on a Form

Windows API

Determine When a Shelled Process Ends

Retrieve Information from the Clipboard

Send Information to the Clipboard

Retrieve the Name of the User Logged On To the Network

Maintenance

Compact and Repair a Database

Recover Tables Deleted from a Database

Handle Run-Time Errors in VBA

Miscellaneous

Detect User Idle Time or Inactivity

Detect Whether an Object Is Open

Display and Use the File Dialog Box

Use the Status Bar Progress Meter

Create a Shortcut Menu for a Form, Form Control, or Report

Use Existing Custom Menus and Toolbars

Create a Database Template Programmatically

Create a Deployment Package Programmatically

Object model

AccessObject Object

CurrentView Property

DateCreated Property

DateModified Property

FullName Property

GetDependencyInfo Method

IsLoaded Property

IsDependentUpon Method

IsWeb Property

Name Property

Parent Property

Properties Property

Type Property

AccessObjectProperties Object

Application Property

Count Property

Item Property

Parent Property

Add Method

Remove Method

AccessObjectProperty Object

Name Property

Value Property

AdditionalData Object

Add Method

Count Property

Item Property

Name Property

AllDatabaseDiagrams Object

Application Property

Count Property

Item Property

Parent Property

AllForms Object

Application Property

Count Property

Item Property

Parent Property

AllFunctions Object

Application Property

Count Property

Item Property

Parent Property

AllMacros Object

Application Property

Count Property

Item Property

Parent Property

AllModules Object

Application Property

Count Property

Item Property

Parent Property

AllQueries Object

Application Property

Count Property

Item Property

Parent Property

AllReports Object

Application Property

Count Property

Item Property

Parent Property

AllStoredProcedures Object

Application Property

Count Property

Item Property

Parent Property

AllTables Object

Application Property

Count Property

Item Property

Parent Property

AllViews Object

Application Property

Count Property

Item Property

Parent Property

Application Object

Application Property

Assistance Property

AutoCorrect Property

AutomationSecurity Property

BrokenReference Property

Build Property

CodeContextObject Property

CodeData Property

CodeProject Property

COMAddIns Property

CommandBars Property

CurrentData Property

CurrentObjectName Property

CurrentObjectType Property

CurrentProject Property

DBEngine Property

DoCmd Property

FeatureInstall Property

FileDialog Property

Forms Property

IsCompiled Property

LanguageSettings Property

MacroError Property

MenuBar Property

Modules Property

Name Property

NewFileTaskPane Property

Parent Property

Printer Property

Printers Property

ProductCode Property

References Property

Reports Property

ReturnVars Property

Screen Property

ShortcutMenuBar Property

TempVars Property

UserControl Property

VBE Property

Version Property

Visible Property

WebServices Property

AccessError Method

AddToFavorites Method

BuildCriteria Method

CloseCurrentDatabase Method

CodeDb Method

ColumnHistory Method

CompactRepair Method

ConvertAccessProject Method

CreateAccessProject Method

CreateAdditionalData Method

CreateControl Method

CreateForm Method

CreateGroupLevel Method

CreateReport Method

CreateReportControl Method

CurrentDb Method

CurrentUser Method

CurrentWebUser Method

CurrentWebUserGroups Method

DAvg Method

DCount Method

DDEExecute Method

DDEInitiate Method

DDEPoke Method

DDERequest Method

DDETerminate Method

DDETerminateAll Method

DefaultWorkspaceClone Method

DeleteControl Method

DeleteReportControl Method

DFirst Method

DirtyObject Method

DLast Method

DLookup Method

DMax Method

DMin Method

DStDev Method

DStDevP Method

DSum Method

DVar Method

DVarP Method

Echo Method

EuroConvert Method

Eval Method

ExportNavigationPane Method

ExportXML Method

FollowHyperlink Method

GetHiddenAttribute Method

GetOption Method

GUIDFromString Method

HtmlEncode Method

hWndAccessApp Method

HyperlinkPart Method

ImportNavigationPane Method

ImportXML Method

InstantiateTemplate Method

IsCurrentWebUserInGroup Method

LoadCustomUI Method

LoadFromAXL Method

LoadPicture Method

NewAccessProject Method

NewCurrentDatabase Method

Nz Method

OpenAccessProject Method

OpenCurrentDatabase Method

PlainText Method

Quit Method

RefreshDatabaseWindow Method

RefreshTitleBar Method

Run Method

RunCommand Method

SaveAsAXL Method

SaveAsTemplate Method

SetDefaultWorkgroupFile Method

SetHiddenAttribute Method

SetOption Method

StringFromGUID Method

SysCmd Method

TransformXML Method

Attachment Object

AddColon Property

AfterUpdate Property

Application Property

AttachmentCount Property

AutoLabel Property

BackColor Property

BackShade Property

BackStyle Property

BackThemeColorIndex Property

BackTint Property

BeforeUpdate Property

BorderColor Property

BorderShade Property

BorderStyle Property

BorderThemeColorIndex Property

BorderTint Property

BorderWidth Property

BottomPadding Property

ColumnHidden Property

ColumnOrder Property

ColumnWidth Property

Controls Property

ControlSource Property

ControlTipText Property

ControlType Property

CurrentAttachment Property

DefaultPicture Property

DefaultPictureType Property

DisplayAs Property

DisplayWhen Property

Enabled Property

EventProcPrefix Property

FileName Property

FileType Property

FileURL Property

GridlineColor Property

GridlineShade Property

GridlineStyleBottom Property

GridlineStyleLeft Property

GridlineStyleRight Property

GridlineStyleTop Property

GridlineThemeColorIndex Property

GridlineTint Property

GridlineWidthBottom Property

GridlineWidthLeft Property

GridlineWidthRight Property

GridlineWidthTop Property

Height Property

HelpContextId Property

HorizontalAnchor Property

InSelection Property

IsVisible Property

LabelAlign Property

LabelX Property

LabelY Property

Layout Property

LayoutID Property

Left Property

LeftPadding Property

Locked Property

Name Property

OldBorderStyle Property

OldValue Property

OnAttachmentCurrent Property

OnChange Property

OnClick Property

OnDblClick Property

OnDirty Property

OnEnter Property

OnExit Property

OnGotFocus Property

OnKeyDown Property

OnKeyPress Property

OnKeyUp Property

OnLostFocus Property

OnMouseDown Property

OnMouseMove Property

OnMouseUp Property

Parent Property

PictureAlignment Property

PictureSizeMode Property

PictureTiling Property

Properties Property

RightPadding Property

Section Property

ShortcutMenuBar Property

SpecialEffect Property

StatusBarText Property

TabIndex Property

TabStop Property

Tag Property

Top Property

TopPadding Property

VerticalAnchor Property

Visible Property

Width Property

Back Method

Forward Method

Move Method

Requery Method

SetFocus Method

SizeToFit Method

AfterUpdate Event

AttachmentCurrent Event

BeforeUpdate Event

Change Event

Click Event

DblClick Event

Dirty Event

Enter Event

Exit Event

GotFocus Event

KeyDown Event

KeyPress Event

KeyUp Event

LostFocus Event

MouseDown Event

MouseMove Event

MouseUp Event

AutoCorrect Object

DisplayAutoCorrectOptions Property

BoundObjectFrame Object

Action Property

AddColon Property

AfterUpdate Property

Application Property

AutoActivate Property

AutoLabel Property

BackColor Property

BackShade Property

BackStyle Property

BackThemeColorIndex Property

BackTint Property

BeforeUpdate Property

BorderColor Property

BorderShade Property

BorderStyle Property

BorderThemeColorIndex Property

BorderTint Property

BorderWidth Property

BottomPadding Property

Class Property

ColumnHidden Property

ColumnOrder Property

ColumnWidth Property

Controls Property

ControlSource Property

ControlTipText Property

ControlType Property

DisplayType Property

DisplayWhen Property

Enabled Property

EventProcPrefix Property

GridlineColor Property

GridlineShade Property

GridlineStyleBottom Property

GridlineStyleLeft Property

GridlineStyleRight Property

GridlineStyleTop Property

GridlineThemeColorIndex Property

GridlineTint Property

GridlineWidthBottom Property

GridlineWidthLeft Property

GridlineWidthRight Property

GridlineWidthTop Property

Height Property

HelpContextId Property

HorizontalAnchor Property

InSelection Property

IsVisible Property

LabelAlign Property

LabelX Property

LabelY Property

Layout Property

LayoutID Property

Left Property

LeftPadding Property

Locked Property

Name Property

Object Property

ObjectPalette Property

ObjectVerbs Property

ObjectVerbsCount Property

OldBorderStyle Property

OldValue Property

OLEType Property

OLETypeAllowed Property

OnClick Property

OnDblClick Property

OnEnter Property

OnExit Property

OnGotFocus Property

OnKeyDown Property

OnKeyPress Property

OnKeyUp Property

OnLostFocus Property

OnMouseDown Property

OnMouseMove Property

OnMouseUp Property

OnUpdated Property

Parent Property

Properties Property

RightPadding Property

Scaling Property

Section Property

ShortcutMenuBar Property

SizeMode Property

SourceDoc Property

SourceItem Property

SpecialEffect Property

StatusBarText Property

TabIndex Property

TabStop Property

Tag Property

Top Property

TopPadding Property

UpdateOptions Property

Value Property

VarOleObject Property

Verb Property

VerticalAnchor Property

Visible Property

Width Property

Move Method

Requery Method

SetFocus Method

SizeToFit Method

AfterUpdate Event

BeforeUpdate Event

Click Event

DblClick Event

Enter Event

Exit Event

GotFocus Event

KeyDown Event

KeyPress Event

KeyUp Event

LostFocus Event

MouseDown Event

MouseMove Event

MouseUp Event

Updated Event

CheckBox Object

AddColon Property

AfterUpdate Property

Application Property

AutoLabel Property

BeforeUpdate Property

BorderColor Property

BorderShade Property

BorderStyle Property

BorderThemeColorIndex Property

BorderTint Property

BorderWidth Property

BottomPadding Property

ColumnHidden Property

ColumnOrder Property

ColumnWidth Property

Controls Property

ControlSource Property

ControlTipText Property

ControlType Property

DefaultValue Property

DisplayWhen Property

Enabled Property

EventProcPrefix Property

GridlineColor Property

GridlineShade Property

GridlineStyleBottom Property

GridlineStyleLeft Property

GridlineStyleRight Property

GridlineStyleTop Property

GridlineThemeColorIndex Property

GridlineTint Property

GridlineWidthBottom Property

GridlineWidthLeft Property

GridlineWidthRight Property

GridlineWidthTop Property

Height Property

HelpContextId Property

HideDuplicates Property

HorizontalAnchor Property

InSelection Property

IsVisible Property

LabelAlign Property

LabelX Property

LabelY Property

Layout Property

LayoutID Property

Left Property

LeftPadding Property

Locked Property

Name Property

OldBorderStyle Property

OldValue Property

OnClick Property

OnDblClick Property

OnEnter Property

OnExit Property

OnGotFocus Property

OnKeyDown Property

OnKeyPress Property

OnKeyUp Property

OnLostFocus Property

OnMouseDown Property

OnMouseMove Property

OnMouseUp Property

OptionValue Property

Parent Property

Properties Property

ReadingOrder Property

RightPadding Property

Section Property

ShortcutMenuBar Property

SpecialEffect Property

StatusBarText Property

TabIndex Property

TabStop Property

Tag Property

Top Property

TopPadding Property

TripleState Property

ValidationRule Property

ValidationText Property

Value Property

VerticalAnchor Property

Visible Property

Width Property

Move Method

Requery Method

SetFocus Method

SizeToFit Method

Undo Method

AfterUpdate Event

BeforeUpdate Event

Click Event

DblClick Event

Enter Event

Exit Event

GotFocus Event

KeyDown Event

KeyPress Event

KeyUp Event

LostFocus Event

MouseDown Event

MouseMove Event

MouseUp Event

CodeData Object

AllDatabaseDiagrams Property

AllFunctions Property

AllQueries Property

AllStoredProcedures Property

AllTables Property

AllViews Property

CodeProject Object

AccessConnection Property

AllForms Property

AllMacros Property

AllModules Property

AllReports Property

Application Property

BaseConnectionString Property

Connection Property

FileFormat Property

FullName Property

ImportExportSpecifications Property

IsConnected Property

IsTrusted Property

IsWeb Property

Name Property

Parent Property

Path Property

ProjectType Property

Properties Property

RemovePersonalInformation Property

Resources Property

WebSite Property

AddSharedImage Method

CloseConnection Method

OpenConnection Method

UpdateDependencyInfo Method

ComboBox Object

AddColon Property

AfterUpdate Property

AllowAutoCorrect Property

AllowValueListEdits Property

Application Property

AutoExpand Property

AutoLabel Property

BackColor Property

BackShade Property

BackStyle Property

BackThemeColorIndex Property

BackTint Property

BeforeUpdate Property

BorderColor Property

BorderShade Property

BorderStyle Property

BorderThemeColorIndex Property

BorderTint Property

BorderWidth Property

BottomMargin Property

BottomPadding Property

BoundColumn Property

CanGrow Property

CanShrink Property

Column Property

ColumnCount Property

ColumnHeads Property

ColumnHidden Property

ColumnOrder Property

ColumnWidth Property

ColumnWidths Property

Controls Property

ControlSource Property

ControlTipText Property

ControlType Property

DecimalPlaces Property

DefaultValue Property

DisplayAsHyperlink Property

DisplayWhen Property

Enabled Property

EventProcPrefix Property

FontBold Property

FontItalic Property

FontName Property

FontSize Property

FontUnderline Property

FontWeight Property

ForeColor Property

ForeShade Property

ForeThemeColorIndex Property

ForeTint Property

Format Property

FormatConditions Property

GridlineColor Property

GridlineShade Property

GridlineStyleBottom Property

GridlineStyleLeft Property

GridlineStyleRight Property

GridlineStyleTop Property

GridlineThemeColorIndex Property

GridlineTint Property

GridlineWidthBottom Property

GridlineWidthLeft Property

GridlineWidthRight Property

GridlineWidthTop Property

Height Property

HelpContextId Property

HideDuplicates Property

HorizontalAnchor Property

Hyperlink Property

IMEHold Property

IMEMode Property

IMESentenceMode Property

InheritValueList Property

InputMask Property

InSelection Property

IsHyperlink Property

IsVisible Property

ItemData Property

ItemsSelected Property

KeyboardLanguage Property

LabelAlign Property

LabelX Property

LabelY Property

Layout Property

LayoutID Property

Left Property

LeftMargin Property

LeftPadding Property

LimitToList Property

ListCount Property

ListIndex Property

ListItemsEditForm Property

ListRows Property

ListWidth Property

Locked Property

Name Property

NumeralShapes Property

OldBorderStyle Property

OldValue Property

OnChange Property

OnClick Property

OnDblClick Property

OnDirty Property

OnEnter Property

OnExit Property

OnGotFocus Property

OnKeyDown Property

OnKeyPress Property

OnKeyUp Property

OnLostFocus Property

OnMouseDown Property

OnMouseMove Property

OnMouseUp Property

OnNotInList Property

OnUndo Property

Parent Property

Properties Property

ReadingOrder Property

Recordset Property

RightMargin Property

RightPadding Property

RowSource Property

RowSourceType Property

ScrollBarAlign Property

Section Property

Selected Property

SelLength Property

SelStart Property

SelText Property

SeparatorCharacters Property

ShortcutMenuBar Property

ShowOnlyRowSourceValues Property

SmartTags Property

SpecialEffect Property

StatusBarText Property

TabIndex Property

TabStop Property

Tag Property

Text Property

TextAlign Property

ThemeFontIndex Property

Top Property

TopMargin Property

TopPadding Property

ValidationRule Property

ValidationText Property

Value Property

VerticalAnchor Property

Visible Property

Width Property

AddItem Method

Dropdown Method

Move Method

RemoveItem Method

Requery Method

SetFocus Method

SizeToFit Method

Undo Method

AfterUpdate Event

BeforeUpdate Event

Change Event

Click Event

DblClick Event

Dirty Event

Enter Event

Exit Event

GotFocus Event

KeyDown Event

KeyPress Event

KeyUp Event

LostFocus Event

MouseDown Event

MouseMove Event

MouseUp Event

NotInList Event

Undo Event

CommandButton Object

AddColon Property

Alignment Property

Application Property

AutoLabel Property

AutoRepeat Property

BackColor Property

BackShade Property

BackStyle Property

BackThemeColorIndex Property

BackTint Property

Bevel Property

BorderColor Property

BorderShade Property

BorderStyle Property

BorderThemeColorIndex Property

BorderTint Property

BorderWidth Property

BottomPadding Property

Cancel Property

Caption Property

Controls Property

ControlTipText Property

ControlType Property

CursorOnHover Property

Default Property

DisplayWhen Property

Enabled Property

EventProcPrefix Property

FontBold Property

FontItalic Property

FontName Property

FontSize Property

FontUnderline Property

FontWeight Property

ForeColor Property

ForeShade Property

ForeThemeColorIndex Property

ForeTint Property

Glow Property

Gradient Property

GridlineColor Property

GridlineShade Property

GridlineStyleBottom Property

GridlineStyleLeft Property

GridlineStyleRight Property

GridlineStyleTop Property

GridlineThemeColorIndex Property

GridlineTint Property

GridlineWidthBottom Property

GridlineWidthLeft Property

GridlineWidthRight Property

GridlineWidthTop Property

Height Property

HelpContextId Property

HorizontalAnchor Property

HoverColor Property

HoverForeColor Property

HoverForeShade Property

HoverForeThemeColorIndex Property

HoverForeTint Property

HoverShade Property

HoverThemeColorIndex Property

HoverTint Property

Hyperlink Property

HyperlinkAddress Property

HyperlinkSubAddress Property

InSelection Property

IsVisible Property

LabelAlign Property

LabelX Property

LabelY Property

Layout Property

LayoutID Property

Left Property

LeftPadding Property

Name Property

ObjectPalette Property

OldValue Property

OnClick Property

OnDblClick Property

OnEnter Property

OnExit Property

OnGotFocus Property

OnKeyDown Property

OnKeyPress Property

OnKeyUp Property

OnLostFocus Property

OnMouseDown Property

OnMouseMove Property

OnMouseUp Property

OnPush Property

Parent Property

Picture Property

PictureCaptionArrangement Property

PictureData Property

PictureType Property

PressedColor Property

PressedForeColor Property

PressedForeShade Property

PressedForeThemeColorIndex Property

PressedForeTint Property

PressedShade Property

PressedThemeColorIndex Property

PressedTint Property

Properties Property

QuickStyle Property

QuickStyleMask Property

ReadingOrder Property

RightPadding Property

Section Property

Shadow Property

Shape Property

ShortcutMenuBar Property

SoftEdges Property

StatusBarText Property

TabIndex Property

TabStop Property

Tag Property

ThemeFontIndex Property

Top Property

TopPadding Property

Transparent Property

UseTheme Property

VerticalAnchor Property

Visible Property

Width Property

Move Method

Requery Method

SetFocus Method

SizeToFit Method

Click Event

DblClick Event

Enter Event

Exit Event

GotFocus Event

KeyDown Event

KeyPress Event

KeyUp Event

LostFocus Event

MouseDown Event

MouseMove Event

MouseUp Event

Control Object

Application Property

BottomPadding Property

Column Property

Controls Property

Form Property

GridlineColor Property

GridlineStyleBottom Property

GridlineStyleLeft Property

GridlineStyleRight Property

GridlineStyleTop Property

GridlineWidthBottom Property

GridlineWidthLeft Property

GridlineWidthRight Property

GridlineWidthTop Property

HorizontalAnchor Property

Hyperlink Property

ItemData Property

ItemsSelected Property

Layout Property

LayoutID Property

LeftPadding Property

Name Property

Object Property

ObjectVerbs Property

OldValue Property

Pages Property

Parent Property

Properties Property

Report Property

RightPadding Property

Selected Property

SmartTags Property

TopPadding Property

VerticalAnchor Property

Dropdown Method

Move Method

Requery Method

SetFocus Method

SizeToFit Method

Undo Method

Controls Object

Application Property

Count Property

Item Property

Parent Property

CurrentData Object

AllDatabaseDiagrams Property

AllFunctions Property

AllQueries Property

AllStoredProcedures Property

AllTables Property

AllViews Property

CurrentProject Object

AccessConnection Property

AllForms Property

AllMacros Property

AllModules Property

AllReports Property

Application Property

BaseConnectionString Property

Connection Property

FileFormat Property

FullName Property

ImportExportSpecifications Property

IsConnected Property

IsTrusted Property

IsWeb Property

Name Property

Parent Property

Path Property

ProjectType Property

Properties Property

RemovePersonalInformation Property

Resources Property

WebSite Property

AddSharedImage Method

CloseConnection Method

OpenConnection Method

UpdateDependencyInfo Method

CustomControl Object

About Property

Application Property

BorderColor Property

BorderShade Property

BorderStyle Property

BorderThemeColorIndex Property

BorderTint Property

BorderWidth Property

BottomPadding Property

Cancel Property

Class Property

Controls Property

ControlSource Property

ControlTipText Property

ControlType Property

Custom Property

Default Property

DisplayWhen Property

Enabled Property

EventProcPrefix Property

GridlineColor Property

GridlineStyleBottom Property

GridlineStyleLeft Property

GridlineStyleRight Property

GridlineStyleTop Property

GridlineWidthBottom Property

GridlineWidthLeft Property

GridlineWidthRight Property

GridlineWidthTop Property

Height Property

HelpContextId Property

HorizontalAnchor Property

InSelection Property

IsVisible Property

Layout Property

LayoutID Property

Left Property

LeftPadding Property

Locked Property

Name Property

Object Property

ObjectPalette Property

ObjectVerbs Property

ObjectVerbsCount Property

OldBorderStyle Property

OldValue Property

OLEClass Property

OnEnter Property

OnExit Property

OnGotFocus Property

OnLostFocus Property

OnUpdated Property

Parent Property

Properties Property

RightPadding Property

Section Property

SpecialEffect Property

TabIndex Property

TabStop Property

Tag Property

Top Property

TopPadding Property

Value Property

VarOleObject Property

Verb Property

VerticalAnchor Property

Visible Property

Width Property

Move Method

Requery Method

SetFocus Method

SizeToFit Method

Enter Event

Exit Event

GotFocus Event

LostFocus Event

Updated Event

DependencyInfo Object

Dependants Property

Dependencies Property

InsufficientPermissions Property

OutOfDateObjects Property

Parent Property

UnsupportedObjects Property

DependencyObjects Object

Application Property

Count Property

Item Property

Parent Property

DoCmd Object

AddMenu Method

ApplyFilter Method

Beep Method

BrowseTo Method

CancelEvent Method

ClearMacroError Method

Close Method

CloseDatabase Method

CopyDatabaseFile Method

CopyObject Method

DeleteObject Method

DoMenuItem Method

Echo Method

FindNext Method

FindRecord Method

GoToControl Method

GoToPage Method

GoToRecord Method

Hourglass Method

LockNavigationPane Method

Maximize Method

Minimize Method

MoveSize Method

NavigateTo Method

OpenDataAccessPage Method

OpenDiagram Method

OpenForm Method

OpenFunction Method

OpenModule Method

OpenQuery Method

OpenReport Method

OpenStoredProcedure Method

OpenTable Method

OpenView Method

OutputTo Method

PrintOut Method

Quit Method

RefreshRecord Method

Rename Method

RepaintObject Method

Requery Method

Restore Method

RunCommand Method

RunDataMacro Method

RunMacro Method

RunSavedImportExport Method

RunSQL Method

Save Method

SearchForRecord Method

SelectObject Method

SendObject Method

SetDisplayedCategories Method

SetFilter Method

SetMenuItem Method

SetOrderBy Method

SetParameter Method

SetProperty Method

SetWarnings Method

ShowAllRecords Method

ShowToolbar Method

SingleStep Method

TransferDatabase Method

TransferSharePointList Method

TransferSpreadsheet Method

TransferSQLDatabase Method

TransferText Method

EmptyCell Object

Application Property

BackColor Property

BackShade Property

BackStyle Property

BackThemeColorIndex Property

BackTint Property

BottomPadding Property

ControlType Property

DisplayWhen Property

EventProcPrefix Property

GridlineColor Property

GridlineShade Property

GridlineStyleBottom Property

GridlineStyleLeft Property

GridlineStyleRight Property

GridlineStyleTop Property

GridlineThemeColorIndex Property

GridlineTint Property

GridlineWidthBottom Property

GridlineWidthLeft Property

GridlineWidthRight Property

GridlineWidthTop Property

Height Property

HelpContextId Property

HorizontalAnchor Property

InSelection Property

IsVisible Property

Layout Property

LayoutID Property

Left Property

LeftPadding Property

Name Property

Parent Property

Properties Property

RightPadding Property

Section Property

ShortcutMenuBar Property

SpecialEffect Property

StatusBarText Property

Tag Property

Top Property

TopPadding Property

VerticalAnchor Property

Visible Property

Width Property