Table of contents
-
Microsoft Access Visual Basic Reference
- Microsoft Access Object Model
- What's New
-
Programming Concepts
-
Advanced Programming Concepts
- Scoping and Object-Naming Compatibility
- Custom Methods and Properties
- Program Toolbars and Menu Bars
- Improvements in Compilation Performance
- Macro Actions and Methods of the DoCmd Object
- Using Enumerated Constants in Microsoft Access
- Comparison of Data Types
- Call Procedures in a Subform or Subreport
- Class Modules
- Setting References
- Setting Properties and Options
-
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
- Differences in String Function Operations
- Quotation Marks in Strings
- Restrict Data to a Subset of Records
- Calculate Fields in Domain Aggregate Functions
- SQL Statements
- Error Codes
- ActiveX Controls
- Conversion
- Working with Other Applications
-
Advanced Programming Concepts
-
Objects
-
A
- AccessObject Object
- AccessObjectProperties Collection
- AccessObjectProperty Object
- AllDataAccessPages Collection
- AllDatabaseDiagrams Collection
- AllForms Collection
- AllFunctions Collection
- AllMacros Collection
- AllModules Collection
- AllQueries Collection
- AllReports Collection
- AllStoredProcedures Collection
- AllTables Collection
- AllViews Collection
- Application Object
- B-C
- D-F
- G-L
- M-O
- P
- R
- S-W
-
A
-
Methods
- A
-
B-C
- Beep Method
- BuildCriteria Method
- CancelEvent Method
- Circle Method
- Close Method
- CloseConnection Method
- CloseCurrentDatabase Method
- CodeDb Method
- CompactRepair Method
- ConvertAccessProject Method
- CopyDatabaseFile Method
- CopyObject Method
- CreateAccessProject Method
- CreateControl Method
- CreateDataAccessPage Method
- CreateEventProc Method
- CreateForm Method
- CreateGroupLevel Method
- CreateNewDocument Method
- CreateNewWorkgroupFile Method
- CreateReport Method
- CreateReportControl Method
- CurrentDb Method
- CurrentUser Method
-
D
- DAvg Method
- DCount Method
- DDEExecute Method
- DDEInitiate Method
- DDEPoke Method
- DDERequest Method
- DDETerminate Method
- DDETerminateAll Method
- DefaultWorkspaceClone Method
- Delete Method
- DeleteControl Method
- DeleteLines Method
- DeleteObject Method
- DeleteReportControl Method
- DFirst Method
- DiscardConflict Method
- DLast Method
- DLookup Method
- DMax Method
- DMin Method
- DoMenuItem Method
- Dropdown Method
- DStDev Method
- DStDevP Method
- DSum Method
- DVar Method
- DVarP Method
- E-F
- G
- H-I
- L-M
-
N-O
- NewAccessProject Method
- NewCurrentDatabase Method
- Nz Function
- OfflineConflict Method
- OpenAccessProject Method
- OpenConnection Method
- OpenCurrentDatabase Method
- OpenDataAccessPage Method
- OpenDiagram Method
- OpenForm Method
- OpenFunction Method
- OpenModule Method
- OpenQuery Method
- OpenReport Method
- OpenStoredProcedure Method
- OpenTable Method
- OpenView Method
- OutputTo Method
-
P-R
- Print Method
- PrintOut Method
- PSet Method
- Quit Method
- Recalc Method
- Refresh Method
- RefreshDatabaseWindow Method
- RefreshTitleBar Method
- Remove Method
- RemoveItem Method
- Rename Method
- Repaint Method
- RepaintObject Method
- ReplaceLine Method
- Requery Method
- Restore Method
- Run Method
- RunCommand Method
- RunMacro Method
- RunSQL Method
- S
- T-U
-
Properties
-
A
- About Property
- Action Property
- ActiveControl Property
- ActiveDataAccessPage Property
- ActiveDatasheet Property
- ActiveForm Property
- ActiveReport Property
- AddColon Property
- Address Property
- AfterBeginTransaction Property
- AfterCommitTransaction Property
- AfterDelConfirm Property
- AfterFinalRender Property
- AfterInsert Property
- AfterLayout Property
- AfterRender Property
- AfterUpdate Property
- AllDataAccessPages Property
- AllDatabaseDiagrams Property
- AllForms Property
- AllFunctions Property
- AllMacros Property
- AllModules Property
- AllowAdditions Property
- AllowAutoCorrect Property
- AllowDatasheetView Property
- AllowDeletions Property
- AllowDesignChanges Property
- AllowEdits Property
- AllowFilters Property
- AllowFormView Property
- AllowPivotChartView Property
- AllowPivotTableView Property
- AllQueries Property
- AllReports Property
- AllStoredProcedures Property
- AllTables Property
- AllViews Property
- AlwaysSaveInDefaultEncoding Property
- AnswerWizard Property
- Application Property
- AsianLineBreak Property
- Assistant Property
- AutoActivate Property
- AutoCenter Property
- AutoExpand Property
- AutoLabel Property
- AutoRepeat Property
- AutoResize Property
- AutoTab Property
-
B
- BackColor Property
- BackStyle Property
- BaseConnectionString Property
- BatchUpdates Property
- BeforeBeginTransaction Property
- BeforeCommitTransaction Property
- BeforeDelConfirm Property
- BeforeInsert Property
- BeforeQuery Property
- BeforeRender Property
- BeforeScreenTip Property
- BeforeUpdate Property
- BeginBatchEdit Property
- Bookmark Property
- BorderColor Property
- BorderStyle Property
- BorderWidth Property
- BottomMargin Property
- BoundColumn Property
- BrokenReference Property
- Build Property
- BuiltIn Property
-
C
- Cancel Property
- CanGrow Property
- CanShrink Property
- Caption Property
- ChartSpace Property
- CheckIfOfficeIsHTMLEditor Property
- Class Property
- CloseButton Property
- CodeContextObject Property
- CodeData Property
- CodeProject Property
- Collection Property
- ColorMode Property
- Column Property
- ColumnCount Property
- ColumnHeads Property
- ColumnHidden Property
- ColumnOrder Property
- ColumnSpacing Property
- ColumnWidth Property
- ColumnWidths Property
- COMAddIns Property
- CommandBars Property
- CommandBeforeExecute Property
- CommandChecked Property
- CommandEnabled Property
- CommandExecute Property
- CommitOnClose Property
- CommitOnNavigation Property
- Connection Property
- ConnectionString Property
- ControlBox Property
- Controls Property
- ControlSource Property
- ControlTipText Property
- ControlType Property
- Copies Property
- Count Property
- CountOfDeclarationLines Property
- CountOfLines Property
- CurrentData Property
- CurrentObjectName Property
- CurrentObjectType Property
- CurrentProject Property
- CurrentRecord Property
- CurrentSectionLeft Property
- CurrentSectionTop Property
- CurrentView Property
- CurrentX Property
- CurrentY Property
- Custom Property
- Cycle Property
-
D
- DataAccessPages Property
- DataChange Property
- DataEntry Property
- DataOnly Property
- DataSetChange Property
- DatasheetBackColor Property
- DatasheetBorderLineStyle Property
- DatasheetCellsEffect Property
- DatasheetColumnHeaderUnderlineStyle Property
- DatasheetFontHeight Property
- DatasheetFontItalic Property
- DatasheetFontName Property
- DatasheetFontUnderline Property
- DatasheetFontWeight Property
- DatasheetForeColor Property
- DatasheetGridlinesBehavior Property
- DatasheetGridlinesColor Property
- DateCreated Property
- DateGrouping Property
- DateModified Property
- DBEngine Property
- DecimalPlaces Property
- Default Property
- DefaultControl Property
- DefaultSize Property
- DefaultValue Property
- DefaultView Property
- DefaultWebOptions Property
- DeviceName Property
- Dirty Property
- DisplayType Property
- DisplayWhen Property
- DividingLines Property
- DoCmd Property
- Document Property
- DownloadComponents Property
- DrawMode Property
- DrawStyle Property
- DrawWidth Property
- DriverName Property
- Duplex Property
- E
-
F
- FastLaserPrinting Property
- FeatureInstall Property
- FetchDefaults Property
- FileDialog Property
- FileFormat Property
- FileSearch Property
- FillColor Property
- FillStyle Property
- Filter Property
- FilterLookup Property
- FilterOn Property
- FolderSuffix Property
- FollowedHyperlinkColor Property
- FontBold Property
- FontItalic Property
- FontName Property
- FontSize Property
- FontUnderline Property
- FontWeight Property
- ForceNewPage Property
- ForeColor Property
- Form Property
- Format Property
- FormatConditions Property
- FormatCount Property
- Forms Property
- FrozenColumns Property
- FullName Property
- FullPath Property
- FuriganaControl Property
- G
- H
-
I
- ImageHeight Property
- ImageWidth Property
- IMEHold/HoldKanjiConversionMode Property
- IMEMode/KanjiConversion Property
- IMESentenceMode Property
- InputMask Property
- InputParameters Property
- InSelection Property
- InsideHeight Property
- InsideWidth Property
- IsBroken Property
- IsCompiled Property
- IsConnected Property
- IsHyperlink Property
- IsLoaded Property
- IsVisible Property
- Item Property
- ItemData Property
- ItemLayout Property
- ItemsAcross Property
- ItemSizeHeight Property
- ItemSizeWidth Property
- ItemsSelected Property
-
K-L
- KeepTogether Property
- KeyboardLanguage Property
- KeyPreview Property
- Kind Property
- LabelAlign Property
- LabelX Property
- LabelY Property
- LanguageSettings Property
- LayoutForPrint Property
- Left Property
- LeftMargin Property
- LimitToList Property
- Lines Property
- LineSlant Property
- LineSpacing Property
- LinkChildFields Property
- LinkMasterFields Property
- ListCount Property
- ListIndex Property
- ListRows Property
- ListWidth Property
- LocationOfComponents Property
- Locked Property
- LpOleObject Property
-
M
- MailEnvelope Property
- Major Property
- MaxRecButton Property
- MaxRecords Property
- MenuBar Property
- MinMaxButtons Property
- Minor Property
- Modal Property
- Module Property
- Modules Property
- MousePointer Property
- MouseWheel Property
- Moveable Property
- MoveLayout Property
- MSODSC Property
- MultiRow Property
- MultiSelect Property
- N
-
O
- Object Property
- ObjectPalette Property
- ObjectVerbs Property
- ObjectVerbsCount Property
- OldBorderStyle Property
- OldValue Property
- OLEClass Property
- OLEType Property
- OLETypeAllowed Property
- OnActivate Property
- OnApplyFilter Property
- OnChange Property
- OnClick Property
- OnClose Property
- OnConnect Property
- OnCurrent Property
- OnDblClick Property
- OnDeactivate Property
- OnDelete Property
- OnDirty Property
- OnDisconnect Property
- OnEnter Property
- OnError Property
- OnExit Property
- OnFilter Property
- OnFormat Property
- OnGotFocus Property
- OnInsert Property
- OnKeyDown Property
- OnKeyPress Property
- OnKeyUp Property
- OnLoad Property
- OnLostFocus Property
- OnMenu Property
- OnMouseDown Property
- OnMouseMove Property
- OnMouseUp Property
- OnNoData Property
- OnNotInList Property
- OnOpen Property
- OnPage Property
- OnPrint Property
- OnPush Property
- OnRecordExit Property
- OnResize Property
- OnRetreat Property
- OnTimer Property
- OnUndo Property
- OnUnload Property
- OnUpdated Property
- OpenArgs Property
- Operator Property
- OptionValue Property
- OrderBy Property
- OrderByOn Property
- OrganizeInFolder Property
- Orientation Property
-
P
- Page Property
- PageFooter Property
- PageHeader Property
- PageIndex Property
- Pages Property
- Painting Property
- PaintPalette Property
- PaletteSource Property
- PaperBin Property
- PaperSize Property
- Parent Property
- Path Property
- Picture Property
- PictureAlignment Property
- PictureData Property
- PicturePages Property
- PictureSizeMode Property
- PictureTiling Property
- PictureType Property
- PivotTable Property
- PivotTableChange Property
- PopUp Property
- Port Property
- PostalAddress Property
- PreviousControl Property
- PrintCount Property
- Printer Property
- Printers Property
- PrintQuality Property
- PrintSection Property
- ProcBodyLine Property
- ProcCountLines Property
- ProcOfLine Property
- ProcStartLine Property
- ProductCode Property
- ProjectType Property
- Properties Property
- PrtDevMode Property
- PrtDevNames Property
- PrtMip Property
-
Q-R
- Query Property
- ReadingOrder Property
- RecordLocks Property
- RecordSelectors Property
- Recordset Property
- RecordsetClone Property
- RecordsetType Property
- RecordSource Property
- RecordSourceQualifier Property
- References Property
- RemovePersonalInformation Property
- RepeatSection Property
- Report Property
- Reports Property
- ResyncCommand Property
- RightMargin Property
- RollbackTransaction Property
- RowHeight Property
- RowSource Property
- RowSourceType Property
- RowSpacing Property
- RunningSum Property
-
S
- ScaleHeight Property
- ScaleLeft Property
- ScaleMode Property
- ScaleTop Property
- ScaleWidth Property
- Scaling Property
- Screen Property
- ScreenTip Property
- ScrollBarAlign Property
- ScrollBars Property
- Section Property
- Selected Property
- SelectionChange Property
- SelHeight Property
- SelLeft Property
- SelLength Property
- SelStart Property
- SelText Property
- SelTop Property
- SelWidth Property
- ServerFilter Property
- ServerFilterByForm Property
- Shape Property
- ShortcutMenu Property
- ShortcutMenuBar Property
- SizeMode Property
- SortOrder Property
- SourceDoc Property
- SourceItem Property
- SourceObject Property
- SpecialEffect Property
- StatusBarText Property
- Style Property
- SubAddress Property
- SubdatasheetExpanded Property
- SubdatasheetHeight Property
-
T
- TabFixedHeight Property
- TabFixedWidth Property
- TabIndex Property
- TabStop Property
- Tag Property
- TargetBrowser Property
- Text Property
- TextAlign Property
- TextToDisplay Property
- TimerInterval Property
- Toolbar Property
- Top Property
- TopMargin Property
- Transparent Property
- TripleState Property
- Type Property
- U
- V
- W
-
A
- Events
- Visual Basic Conceptual Topics
- Visual Basic Language Reference
- Microsoft Office Visual Basic Reference
- Microsoft Forms Visual Basic Reference
- Microsoft ActiveX Data Objects (ADO)
- Microsoft Data Access Objects 3.60 (DAO)
- Microsoft Jet SQL Reference