documentation
.HELP!
Microsoft Access Visual Basic Documentation
DiscardConflict Method
Microsoft Access Visual Basic
previous page
next page
This keyword is not implemented. It is reserved for future use.
previous page
start
next page
Menu
Homepage
Table of contents
Microsoft Access Visual Basic Reference
Microsoft Access Object Model
What's New
What's New for Microsoft Access 2002 Developers
New Objects
New Events
New Methods (Alphabetic List)
New Methods (By Object)
New Properties (Alphabetic List)
New Properties (By Object)
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
Program with Class Modules
Setting References
Set References to Type Libraries
Set a Reference to a Visual Basic Project in Another Microsoft Access Database or Project
Setting Properties and Options
Set Form, Report, and Control Properties
Set Options from Visual Basic
Set Properties by Using Visual Basic
Set Properties by Using Macros
Set Data Access Page and Control Properties
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
Differences in String Function Operations
Quotation Marks in Strings
Restrict Data to a Subset of Records
Calculate Fields in Domain Aggregate Functions
SQL Statements
Build SQL Statements That Include Variables and Controls
Use International Date Formats in SQL Statements
Error Codes
Error Trapping
Elements of Run-Time Error Handling
ActiveX Controls
The ActiveX Control's Custom Properties Dialog Box
View an ActiveX Control's About Box
Conversion
Convert Microsoft Access Tables, Forms, and Reports
Converting DAO Code to ADO
Working with Other Applications
Automation with Microsoft Access
Using ActiveX Data Objects in Microsoft Access 2002
Use Microsoft Access as a DDE Server
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
BoundObjectFrame Object
CheckBox Object
CodeData Object
CodeProject Object
ComboBox Object
CommandButton Object
Control Object
Controls Collection
CurrentData Object
CurrentProject Object
CustomControl Object
D-F
DataAccessPage Object
DataAccessPages Collection
DefaultWebOptions Object
DoCmd Object
Form Object
FormatCondition Object
FormatConditions Collection
Forms Collection
G-L
GroupLevel Object
Hyperlink Object
Image Object
Label Object
Line Object
ListBox Object
M-O
Module Object
Modules Collection
ObjectFrame Object
OptionButton Object
OptionGroup Object
P
Page Object
PageBreak Object
Pages Collection
Printer Object
Printers Collection
Properties Collection
R
Rectangle Object
Reference Object
References Collection
Report Object
Reports Collection
S-W
Screen Object
Section Object
SubForm Object
SubReport Object
TabControl Object
TextBox Object
ToggleButton Object
WebOptions Object
Methods
A
AccessError Method
Add Method
AddFromFile Method
AddFromGuid Method
AddFromString Method
AddItem Method
AddMenu Method
AddToFavorites Method
ApplyFilter Method
ApplyTheme Method
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
Echo Method
EuroConvert Function
Eval Method
ExportXML Method
Find Method
FindNext Method
FindRecord Method
Follow Method
FollowHyperlink Method
G
GetHiddenAttribute Method
GetOption Method
GoToControl Method
GoToPage Method
GoToRecord Method
GUIDFromString Method
H-I
Hourglass Method
hWndAccessApp Method
HyperlinkPart Method
ImportXML Method
InsertLines Method
InsertText Method
Item Method
L-M
Line Method
LoadPicture Method
Maximize Method
Minimize Method
Modify Method
Move Method
MoveSize Method
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
Save Method
Scale Method
SelectObject Method
SendObject Method
SetDefaultWorkgroupFile Method
SetFocus Method
SetHiddenAttribute Method
SetMenuItem Method
SetOption Method
SetWarnings Method
ShowAllRecords Method
ShowToolbar Method
SizeToFit Method
StringFromGUID Method
SysCmd Method
T-U
TextHeight Method
TextWidth Method
TransferDatabase Method
TransferSpreadsheet Method
TransferSQLDatabase Method
TransferText Method
Undo Method
UseDefaultFolderSuffix Method
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
EmailSubject Property
Enabled Property
Encoding Property
EnterKeyBehavior Property
EventProcPrefix Property
Expression1 Property
Expression2 Property
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
GridX Property
GridY Property
GroupFooter Property
GroupHeader Property
GroupInterval Property
GroupLevel Property
GroupOn Property
GrpKeepTogether Property
Guid Property
H
HasContinued Property
HasData Property
HasModule Property
Height Property
HelpContextId Property
HelpFile Property
HideDuplicates Property
HorizontalDatasheetGridlineStyle Property
Hwnd Property
Hyperlink Property
HyperlinkAddress Property
HyperlinkColor Property
HyperlinkSubAddress Property
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
Name Property
NavigationButtons Property
NewFileTaskPane Property
NewRecord Property
NewRowOrCol Property
NextRecord Property
NumeralShapes Property
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
UnderlineHyperlinks Property
UndoBatchEdit Property
UniqueTable Property
UpdateOptions Property
UseDefaultPrinter Property
UseLongFileNames Property
UserControl Property
V
ValidationRule Property
ValidationText Property
Value Property
VBE Property
Verb Property
Version Property
Vertical Property
VerticalDatasheetGridlineStyle Property
ViewChange Property
ViewsAllowed Property
Visible Property
W
WebOptions Property
WhatsThisButton Property
Width Property
WillContinue Property
WindowHeight Property
WindowLeft Property
WindowTop Property
WindowWidth Property
Events
A
Activate Event
AfterBeginTransaction Event
AfterCommitTransaction Event
AfterDelConfirm Event
AfterFinalRender Event
AfterInsert Event
AfterLayout Event
AfterRender Event
AfterUpdate Event
ApplyFilter Event
B
BeforeBeginTransaction Event
BeforeCommitTransaction Event
BeforeDelConfirm Event
BeforeInsert Event
BeforeQuery Event
BeforeRender Event
BeforeScreenTip Event
BeforeUpdate Event
BeginBatchEdit Event
C
Change Event
Click Event
Close Event
CommandBeforeExecute Event
CommandChecked Event
CommandEnabled Event
CommandExecute Event
Current Event
D
DataChange Event
DataSetChange Event
DblClick Event
Deactivate Event
Delete Event
Dirty Event
E-F
Enter Event
Error Event
Exit Event
Filter Event
Format Event
G-K
GotFocus Event
ItemAdded Event
ItemRemoved Event
KeyDown Event
KeyPress Event
KeyUp Event
L-M
Load Event
LostFocus Event
MouseDown Event
MouseMove Event
MouseUp Event
MouseWheel Event
N-O
NoData Event
NotInList Event
OnConnect Event
OnDisconnect Event
Open Event
P-R
Page Event
PivotTableChange Event
Print Event
Query Event
RecordExit Event
Resize Event
Retreat Event
RollbackTransaction Event
S-V
SelectionChange Event
Timer Event
Undo Event
UndoBatchEdit Event
Unload Event
Updated Event
ViewChange Event
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
Get in touch
Submit feedback about this site to:
[email protected]