Microsoft Corp., 2005. — 1117 p.
(Автор не указан).This download contains documentation (such as programming references and technical articles), and may contain tools and sample code designed to help you customize Microsoft Office Access 2003 and to extend Word and integrate with other applications.
Источник: сайт www.microsoft.com
Разработано для версии MS Access 2003, но, в целом, применимо для более ранних и более поздних версий.
Файл перекомпилирован в формат PDF специально для сайта www.twirpx.com .Contents:
Foreword.
Microsoft Access Visual Basic Reference.
Welcome to the Microsoft Access 2003 Language Reference.
Microsoft Access Object Model.
What's New.
New Objects.
New Properties (Alphabetic List).
New Properties (by Object).
New Methods (Alphabetic List).
New Methods (by Object).
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.
Using Enumerated Constants in Microsoft Access 2002 and Later.
Comparison of Data Types.
Call Procedures in a Subform or Subreport.
Program with Class Modules.
ActiveX Controls.
The ActiveX Controls Custom Properties Dialog Box.
View an ActiveX Controls About Box.
Conversion.
Convert Microsoft Access Tables, Forms, and Reports.
Converting DAO Code to ADO.
Working with Other Applications.
Automation with Microsoft Access.
Use Microsoft Access as a DDE Server.
Using ActiveX Data Objects in Microsoft Access 2002 and later.
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.
Eements of Run – Time Error HandIing.
Reference.
Collections.
AccessObjectProperties. AllDataAccessPages. AllDatabaseDiagrams. AllForms. AllFunctions. AllMacros. AllModules. AllQueries. AllReports. AllStoredProcedures. AllTables. AllViews. Controls. DataAccessPages. DependencyObjects. FormatConditions. Forms. Modules. Pages. Printers. Properties. References. Reports. SmartTagActions. SmartTagProperties. SmartTags. Objects. AccessObject. AccessObjectProperty. AdditionalData. Application. AutoCorrect. BoundObjectFrame. CheckBox. CodeData. CodeProject. ComboBox. CommandButton. Control. CurrentData. CurrentProject. CustomControl. DataAccessPage. DefaultWebOptions. DependencyInfo. DoCmd. Form. FormatCondition. GroupLevel. Hyperlink. Image. Label. Line. ListBox. Module. ObjectFrame. OptionButton. OptionGroup. Page. PageBreak. Printer. Rectangle. Reference. Report. Screen. Section. SmartTag. SmartTagAction. SmartTagProperIy. SubForm. SubReport. TabControl. TextBox. ToggleButton. WebOptions.
Methods.
AccessError. Add. AddFromFile. AddFromGuid. AddFromString. AddItem. AddMenu. AddToFavorites. ApplyFilter. ApplyTheme. Beep. BuildCriteria. CancelEvent. Circle. Close. CloseConnection. CloseCurrentDatabase. CodeDb. CompactRepair. ConvertAccessProject. CopyDatabaseFile. CopyObject. CreateAccessProject. CreateAdditional Data. CreateControl. CreateEventProc. CreateForm. CreateGroupLevel. CreateNewDocument. CreateNewWorkgroupFile. CreateReport. CreateReportControl. CurrentDb. CurrentUser. DAvg. DCount. DDEExecute. DDEInitiate. DDEPoke. DDERequest. DDETerminate. DDETerminateAll. DefaultWorkspaceClone. Delete. DeleteControl. DeleteLines. DeleteObject. DeleteReportControl. DFirst. DLast. DLookup. DMax. DMin. DoMenuItem. Dropdown. DStDev. DStDevP. DSum. DVar. DVarP. Echo. EuroConvert. Eval. Execute. ExportXML. Find. FindNext. FindRecord. Follow. Follow Hyperlink. GetDependencyInfo. GetHiddenAttribute. GetOption. GoToControl. GoToPage. GoToRecord. GUIDFromString. Hourglass. hWndAccessApp. HyperlinkPart. ImportXML. InsertLines. InsertText. IsDependentUpon. Item. Line. LoadPicture. Maximize. Minimize. Modify. Move. MoveSize. NewAccessProject. NewCurrentDatabase. Nz. OpenAccessProject. OpenConnection. OpenCurrentDatabase. OpenDataAccessPage. OpenDiagram. OpenForm. OpenFunction. OpenModule. OpenQuery. OpenReport. OpenStoredProcedure. OpenTable. OpenView. OutputTo. PrintMethod. PrintOut. PSet. Quit. Recalc. Refresh. RefreshDatabaseWindow. RefreshTitleBar. Remove. RemoveItem. Rename. Repaint. RepaintObject. ReplaceLine. Requery. Restore. Run. RunCommand. RunMacro. RunSQL. Save. Scale. SelectObject. SendObject. SetDefaultWorkgroupFile. SetFocus. SetHiddenAttribute. SetMenuItem. SetOption. SetWarnings. ShowAllRecords. Show Toolbar. SizeToFit. StringFromGUID. SysCmd. TextHeight. TextWidth. TransferDatabase. TransferSpreadsheet. TransferSQLDatabase. TransferText. TransformXML. Undo. UpdateDependencyInfo. UseDefaultFolderSuffix.
Properties.
About. AccessConnectIon. Action. ActiveControl. ActiveDataAccessPage. ActiveDatasheet. ActiveForm. ActiveReport. AddColon. Address. AfterDelConfirm. AfterFinalRender. AfterInsert. AfterLayout. AfterRender. AfterUpdate. AllDataAccessPages. AllDatabaseDiagrams. AllForms. AllFunctions. AllMacros. AllModules. AllowAdditions. AllowAutoCorrect. AllowDatasheetView. AllowDeletions. AllowDesignChanges. AllowEdits. AllowFilters. AllowFormView. AllowPivotChartView. AllowPivotTableView. AllQueries. AllReports. AutoActivate. AutoCenter. AutoCorrect. AutoExpand. AutoLabel. AutomationSecurity. AutoRepeat. AutoResize. AutoTab. BackColor. BackStyle. BaseConnectionString. BeforeDelConfirm. BeforeInsert. BeforeQuery. BeforeRender. BeforeScreenTip. BeforeUpdate. Bookmark. BorderColor. BorderStyle. BorderWidth. BottomMargin. BoundColumn. BrokenReference. Build. BuiltIn. Cancel. CanGrow. CanShrink. Caption. ChartSpace. CheckIfOfficeIsHTMLEditor. Class. CloseButton. CodeContextObject. CodeData. CodeProject. Collection. ColorMode. Column. ColumnCount. ColumnHeads. ColumnHidden. ColumnOrder. ColumnSpacing. ColumnWidth. ColumnWidths. COMAddIns. CommandBars. CommandBeforeExecute. CommandChecked. CommandEnabled. CommandExecute. Connection. ConnectionString. ControlBox. Controls. ControlSource. ControlTipText. ControlType. Copies. Count. CountOfDeclarationLines. CountOfLines. CurrentData. CurrentObjectName. CurrentObjectType. CurrentProject. CurrentRecord. CurrentSectionLeft. CurrentSectionTop. CurrentView. CurrentX. CurrentY. Custom. Cycle. DataAccessPages. DataChange. DataEntry. DataOnly. DataSetChange. DatasheetBackColor. DatasheetBorderLineStyle. DatasheetCellsEffect. DatasheetColumnHeaderUnderlineStyle. DatasheetFontHeight. DatasheetFontItalic. DatasheetFontName. DatasheetFontUnderline. DatasheetFontWeight. DatasheetForeColor. DatasheetGridlinesBehavior. DatasheetGridlinesColor. DateCreated. DateGrouping. DateModified. DBEngine. DecimalPlaces. Default. DefaultControl. DefaultSize. DefaultValue. DefaultView. DefaultWebOptions. Dependants. Dependencies. DeviceName. Dirty. DisplayAutoCorrectOptions. DisplayType. DisplayWhen. DividingLines. DoCmd. Document. DownloadComponents. DrawMode. DrawStyle. DrawWidth. DriverName. Duplex. EmailSubject. Enabled. Encoding. EnterKeyBehavior. EventProcPrefix. Expression1 . Expression2 . FastLaserPrinting. FeatureInstall. FetchDefaults. FileDialog. FileFormat. FileSearch. FillColor. FillStyle. Filter. FilterLookup. FilterOn. FolderSuffix. FollowedHyperlinkColor. FontBold. FontItalic. FontName. FontSize. FontUnderline. FontWeight. ForceNew Page. ForeColor. Form. Format. FormatConditions. FormatCount. Forms. FrozenColumns. FullName. FullPath. FuriganaControl. GridX. GridY. GroupFooter. GroupHeader. GroupInterval. GroupLevel. GroupOn. GrpKeepTogether. Guid. HasContinued. HasData. HasModule. Height. HelpContextId. HelpFile. HideDuplicates. HorizontalDatasheetGridlineStyle. Hwnd. Hyperlink. HyperlinkAddress. HyperlinkColor. HyperlinkSubAddress. ImageHteight. ImageWidth. IMEHold. IMEMode. IMESentenceMode. InputMask. InputParameters. InSelection. InsideHteight. InsideWidth. InsufficientPermissions. IsBroken. IsCompiled. IsConnected. IsHyperlink. IsLoaded. IsMissing. IsVisible. lem. ItemData. ItemLayout. ItemsAcross. ItemSizeHeight. ItemSizeWidth. ItemsSelected. KeepTogether. KeyboardLanguage. KeyPreview. Kind. LabelAlign. LabelX. LabelY. LanguageSettings. LayoutForPrint. Left. LeftMargin. LimitToList. Lines. LineSlant. LineSpacing. LinkChildFields. LinkMasterFields. ListCount. ListIndex. ListRows. ListWidth. LocationOfComponents. Locked. LpOleObject. MailEnvelope. Major. MaxRecButton. MaxRecords. MenuBar. MinMaxButtons. Minor. Modal. Module. Modules. MousePointer. MouseWheel. Moveable. MoveLayout. MSODSC. MultiRow. MultiSelect. Name. NavigationButtons. New FileTaskPane. New Record. New Row OrCol. NextRecord. NumeralShapes. Object. ObjectPalette. ObjectVerbs. ObjectVerbsCount. OldBorderStyle. OldValue. OLEClass. OLEType. OLETypeAllowed. OnActivate. OnApplyFilter. OnChange. OnClick. OnClose. OnConnect. OnCurrent. OnDblClick. OnDeactivate. OnDelete. OnDirty. OnDisconnect. OnEnter. OnError. OnExit. OnFilter. OnFormat. OnGotFocus. OnInsert. OnKeyDown. OnKeyPress. OnKeyUp. OnLoad. OnLostFocus. OnMenu. OnMouseDown. OnMouseMove. OnMouseUp. OnNoData. OnNotInList. OnOpen. OnPage. OnPrint. OnPush. OnResize. OnRetreat. OnTimer. OnUndo. OnUnload. OnUpdated. OpenArgs. Operator. OptionValue. OrderBy. OrderByOn. OrganizeInFolder. Orientation. OutOfDateObjects. Page. PageFooter. PageHeader. PageIndex. Pages. Painting. PaintPalette. PaletteSource. PaperBin. PaperSize. Parent. Path. Picture. PictureAlignment. PictureData. PicturePages. PicturePalette. PictureSizeMode. PictureTiling. PictureType. PivotTable. PivotTableChange. PopUp. Port. PostalAddress. PreviousControl. PrintCount. Printer. Printers. PrintQuality. PrintSection. ProcBodyLine. ProcCountLines. ProcOfLine. ProcStartLine. ProductCode. ProjectType. Properties. PrtDevMode. PrtDevNames. PrtMip. Query. ReadingOrder. RecordLocks. RecordSelectors. Recordset. RecordsetClone. RecordsetType. RecordSource. RecordSourceQualifier. References. RemovePersonalInformation. RepeatSection. Report. Reports. ResyncCommand. RightMargin. Row Height. Row Source. Row SourceType. Row Spacing. RunningSum. ScaleHeight. ScaleLeft. ScaleMode. ScaleTop. ScaleWidth. Scaling. Screen. ScreenTip. ScrollBarAlign. ScrollBars. Section. Selected. SelectionChange. SelHeight. SelLeft. SelLength. SelStart. SelText. SelTop. SelWidth. ServerFilter. ServerFilterByForm. Shape. ShortcutMenu. ShortcutMenuBar. SizeMode. SmartTagActions. SmartTags. SortOrder. SourceDoc. SourceItem. SourceObject. SpecialEffect. StatusBarText. Style. SubAddress. SubdatasheetExpanded. SubdatasheetHeight. TabFixedHteight. TabFixedWidth. TabIndex. TabStop. TagProperty. TargetBrowser. Text. TextAlign. TextToDisplay. TimerInterval. Toolbar. Top. TopMargin. Transparent. TripleState. Type. UnderlineHyperlinks. UniqueTable. UnsupportedObjects. UpdateOptions. UseDefaultPrinter. UseLongFileNames. UserControl. ValidationRule. ValidationText. Value. VBE. Verb. Version. Vertical. VerticalDatasheetGridlineStyle. ViewChange. ViewsAllowed. Visible. WebOptions. WhatsThisButton. Width. WillContinue. WindowHeight. WindowLeft. WindowTop. WindowWidth. XML.
Events.
Activate. AfterDelConfirm. AfterFinalRender. AfterInsert. AfterLayout. AfterRender. AfterUpdate. ApplyFilter. BeforeDelConfirm. BeforeInsert. BeforeQuery. BeforeRender. BeforeScreenTip. BeforeUpdate. Change. Click. Close. CommandBeforeExecute. CommandChecked. CommandEnabled. CommandExecute. Current. DataChange. DataSetChange. DblClick. Deactivate. Delete. Dirty. Enter. Error. Exit. Filter. GotFocus. ItemAdded. ItemRemoved. KeyDown. KeyPress. KeyUp. Load. LostFocus. MouseDown. MouseMove. MouseUp. MouseWheel. NoData. NotInList. OnConnect. OnDisconnect. Open. Page. PivotTableChange. Query. Resize. SelectionChange. Timer. Undo. Unload. Updated. ViewChange.
Functions.
Functions Reference.
Command. DAvg. DCount. DDE. DDEInitiate. DDERequest. DFirst, DLast. DLookup. DMin, DMax. DStDev, DStDevP. DSum. DVar, DVarP. EuroConvert. Eval. Format. GUIDFromString. Nz. StringFromGUID.
Enumerations.
Microsoft Access Constants.
Index.
