[SYMBOL][A][B][C][D][E][F][G][H][I][J][K][L][M][N][O][P][Q][R][S][T][U][V][W][X][Y][Z]obj data-type prefix objectConnection objectBeginTrans method 2nd CommitTrans method 2nd RollbackTrans method 2nd Object Browser 2nd 3rd information available in intrinsic constants pasting code templates into procdures Project/Library drop-down list running viewing constants Object Browser command (View menu) Object Browser dialog box Object Definition window (Database Documenter) Object Dependencies feature 2nd Object Dependency featureinvoking 2nd object libraries object models object orientation 2nd Object Properties dialog box object types object variables 2nd compared to regular variables 2nd generic compared to specific 2nd Nothing value referencing applications 2nd 3rd objects 2nd Access Object ModelAllDataAccessPages collection AllForms collection AllMacros collection AllModules collection AllQueries collection AllReports collection AllTables collection Application object methods 2nd 3rd Application object properties CodeData object CodeProject object CurrentData object 2nd CurrentProject object 2nd 3rd DataAccessPages collection DoCmd object 2nd Forms collection 2nd Modules collection Reports collection Screen object special properties that refer to objects 2nd ApplicationCompactRepair method 2nd automation automation objects 2nd 3rd binding 2nd creating 2nd methods Object variables 2nd properties bound OLE objects 2nd In-Place activation Catalog objectDelete method CodeData object CodeProject object Collection object Add method 2nd Item method Remove method command buttonsenabling/disabling 2nd 3rd 4th 5th Command objectADO object model compared to collections comparingTotal Access Detective compilation Connection objectADO object model 2nd 3rd ContainersData Access Object model 2nd CurrentData object 2nd CurrentProject object 2nd 3rd custom collections 2nd 3rd 4th 5th adding items to 2nd creating deleting items looping through referencing items DAO code and 2nd 3rd 4th 5th 6th 7th 8th DAOsnaming conventions 2nd Databasecreating variables 2nd database objectssaving as HTML 2nd 3rd 4th splitting 2nd 3rd Database window objectsnaming conventions 2nd DatabasesData Access Object model 2nd DBEngine 2nd declaringdisambiguation dependenciesdisplaying (Object Dependency feature) 2nd DoCmdadding report sections at runtime 2nd 3rd examples 2nd executing macros 2nd importing external data 2nd 3rd 4th OpenForm method DoCmd object 2nd DocumentData Access Object model 2nd Err 2nd Err objectproperties Raise method 2nd 3rd 4th ErrorData Access Object model event procedures creating events 2nd Excel automation objectsclosing 2nd FieldsData Access Object model 2nd FileDialog 2nd 3rd form objectsaligning 2nd moving 2nd selecting 2nd sizing 2nd spacing 2nd tab order, changing 2nd GroupsData Access Object model IndexesData Access Object model 2nd instantiating (Class modules) methods 2nd executing 2nd object library naming (Reddick naming convention) 2nd naming conventions 2nd 3rd 4th 5th 6th 7th Jet object/collection prefixes 2nd object tag prefixes 2nd scope/lifetime prefixes variable data type tags 2nd Object Browser 2nd OLEinserting in reports OLE objectsconverting to images ownershipchanging 2nd ParameterData Access Object model 2nd passing to subroutines and functions 2nd permissionsassigning Printer 2nd procedurescalling prohibiting users/groups from creating 2nd properties 2nd PropertiesData Access Object model propertiesdefault modifying 2nd object library setting for single objects viewing QueryDefsData Access Object model 2nd Recordsetcreating variables Data Access Object model dynasets properties 2nd selecting types Recordset objectADO object model 2nd 3rd consistent compared to inconsistent updates 2nd CursorType parameter 2nd 3rd 4th LockType parameter 2nd Options parameter 2nd selecting location 2nd Supports method referencing 2nd shortcuts 2nd registering RelationsData Access Object model 2nd report objectsaligning moving selecting 2nd sizing Snap to Grid feature spacing reportsmoving Screen object securitySecurity Wizard Table objectProperties collection TableDefsData Access Object model unbound OLE objects UserData Access Object model With...End With construct 2nd WorkspaceData Access Object model OCX controls [See ActiveX, controls]ocx prefix ODBCclient/servers translating SQL statements ODBCDirect OLEcontrols [See ActiveX, controls]objectsconverting to images inserting in reports OLE DB OLE Object field type OLE objectsbound OLE objects 2nd In-Place activation unbound OLE objects ole prefix On Error Goto 0 statement 2nd On Error Goto statement 2nd 3rd On Error Resume Next statement 2nd On Error routinegeneric error handlers 2nd On Error statements 2nd On Error Goto 2nd 3rd On Error Goto 0 2nd On Error Resume Next 2nd one-to-many forms creating (Form Wizard) 2nd creating (Subform/SubReport Wizard) 2nd 3rd one-to-many queriesone-to-many reportscreating 2nd one-to-many relationships 2nd join lines lookups 2nd one-to-many reportscreating 2nd 3rd 4th 5th 6th one-to-many queries 2nd Report Wizard 2nd 3rd 4th Subreport Wizard 2nd one-to-one relationships 2nd join lines OnRowEnter event OnRowExit event Open dialog box Open eventforms reports 2nd 3rd Open Exclusive permission Open keyword Open methodConnectionString argument Open/Run permission OpenArgs propertyforms 2nd OpenDatabase method 2nd OpenForm methodDoCmd object openingdatabasesuser-level security external tables 2nd 3rd 4th 5th connection information, providing OpenDatabase method 2nd filessupported file formats 2nd formsForm event sequence recordsets dynasets windowsdesigning forms 2nd OpenRecordSet method operating systemsActiveX control support operatorsquery criteria 2nd opt prefix optimistic locking optimization 2nd 3rd codebookmarks 2nd Boolean expressions built-in collections 2nd compiling modules 2nd constants Declare statements Dim statements dynamic arrays 2nd inline code Len function 2nd MDE files Me keyword object references object variables organizing modules specific object variables 2nd stored queries 2nd true/false evaluations 2nd unused code variant variables, eliminating 2nd With...End With construct 2nd coding changes data structures 2nd 3rd data types denormalizing indexes normalizing defined form-optimization techniques 2nd 3rd hardware Compact utility defragmenting hard disks disk compression RAM 2nd virtual memory 2nd Jet 3.5 Engine Jet 4.0 Engine 2nd local execution and Performance Analyzer 2nd queries 2nd report-optimization techniques 2nd softwareWindows 95/98 2nd splitting tables from other objects Windows 2000 Terminla Services Windows registry settings 2nd optimizingqueries 2nd 3rd 4th option buttonsformsadding Option Explicit statementavoiding bugs modules 2nd Option Group Wizard 2nd option groupscaptions formsadding 2nd 3rd optional parameters 2nd 3rd Options command (Tools menu) Options parameterADO recordset types 2nd Or (query criteria operator) ORDER BY clauseSQL Order By propertyforms queries order of eventsreport events report section events OrderBy property 2nd OrderByOn property 2nd Orientation propertyforms UpDown object orphan records 2nd Other propertiescontrols outer joinsleft outer joins queries 2nd right outer joins Outlookcontrolling from Access 2nd 3rd Output All Fields propertyqueries ownership (database objects)changing 2nd
لطفا منتظر باشید ...
