[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]m scope prefix macroscapabilities of compared to VBA programming 2nd 3rd 4th 5th documenting (Database Documenter) executingDoCmd object 2nd running versus modules mail merge documents (Word) 2nd mailing labelsreports with labels maintenancesplitting tables from other objects maintenance activitiesapplications developmentbug fixes frill additions Make Table queriescreating 2nd 3rd 4th 5th performance considerations MakeItBold Subroutine many-to-many relationships 2nd mappingdBASE data types MaxBufferSize settings (Windows registry) MaxRecords propertydata access pages mcr prefix MDE files (compiled database) applicationsdistributing creating restrictions 2nd security Me keyword 2nd 3rd Me property membershipworkgroupschanging Memo field type memo fieldscustomizingTotal Access Memo 2nd memoryDeclare statements freeing optimization 2nd usage considerationsdeclaring variables virtualoptimizing 2nd menu add-inscreating 2nd defined designing installing Menu Add-ins section (registry)library references Menu Bar option Menu Bar propertyforms menus 2nd 3rd 4th 5th 6th associating commands with menu items 2nd creating 2nd 3rd 4th customcreating for runtime version 2nd 3rd deleting Formataligning form objects sizing form objects Snap to Grid (forms) spacing form objects modifying with VBA code 2nd renaming Viewchanging tab order message boxes 2nd 3rd 4th 5th MsgBox function 2nd 3rd 4th preventing rebooting during long processes messageswarningAction queries 2nd suppressing methods 2nd Addcustom collections 2nd Add methodCollection object 2nd AddFromFile 2nd adding to Class modules AddNew 2nd 3rd AddNew methoddata access class 2nd Append 2nd Groups collection Users collection 2nd Application object 2nd 3rd AutoFill AutoFilter automation objects BeginTranstransaction processing 2nd BrokenReferences (Application object) CommitTranstransaction processing 2nd CompactDatabase CompactDatabase method (JetEngine object) 2nd 3rd CompactRepair CompactRepair method (Application object) 2nd compared to properties 2nd ConvertAccessProject ConvertAccessProject (Application object) 2nd CopyFromRecordset 2nd CreateQueryDef customadding to classes 2nd custom methodscreating 2nd Delete 2nd 3rd Catalog object Delete methoddata access class 2nd Edit methoddata access class 2nd ErrorProcess methodcustom error handler class 2nd executing 2nd fieldsprinting Find method (ADO recordsets) 2nd 3rd 4th 5th FindNext FindPrevious Item methodCollection object Move MoveFirst 2nd MoveLast 2nd MoveNext 2nd 3rd MoveNext methoddata access class 2nd MovePrevious 2nd 3rd MovePrevious methoddata access class 2nd objectsobject library OpenDatabase 2nd OpenFormDoCmd object OpenRecordSet Raise (Err object) 2nd 3rd 4th 5th generating errors 2nd user-defined errors 2nd record-movement methods (ADO recordsets) 2nd recordsets Remove method Collection object Requeryrefreshing recordset data 2nd Resyncrefreshing recordset data 2nd Rich Textbox control Rollbacktransaction processing 2nd Save methoddata access class 2nd Scatter methoddata access class 2nd 3rd Seek SetWarnings SupportsRecordset objects TransferDatabasearguments importing external data 2nd 3rd TransferSpreadsheetarguments importing external data 2nd TransferTextimporting external data 2nd Update Microsoft Database Engine (MSDE) Microsoft Office Developer tools [See MOD tools]Microsoft Script Editor (MSE)customizing data access pages 2nd 3rd Mid function migrationimporting tables to client/server environment Upsizing Wizard Min Max Buttons propertyforms reports mmnu object-naming prefix MOD (Microsoft Office Developer) tools modal forms Modal propertyforms Modal property (builder forms) Modify Design permission modifyingtoolbars Module Design windowmodulesviewing design Module property Module windowproceduresexecuting 2nd 3rd module-level variables [See General Declarations section 2nd bookmarks, adding CBF class Classdeclaring procedures Class compared to Standard 2nd Class modules 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th class modules 2nd 3rd 4th Class modulescreating 2nd 3rd 4th 5th class modulescreating Class modulescustom collections 2nd 3rd 4th 5th class modulescustom error handler class 2nd 3rd 4th 5th Class modulesdata access class 2nd 3rd 4th 5th 6th 7th 8th file information class 2nd 3rd 4th Initialize event instantiating objects methods, adding multiple class instances, creating 2nd object orientation 2nd properties, adding Property Get routine 2nd class modulesProperty Get routine Class modulesProperty Let routine 2nd class modulesProperty Let routine Class modulessystem information class 2nd 3rd 4th Terminate event code modulesexporting compiling 2nd Complete Word feature constantsintrinsic 2nd Definition feature 2nd documenting (Database Documenter) event procedures 2nd 3rd features Form and Report Class form modulesexporting function libraries functions 2nd creating 2nd 3rd General Declarations sections List Constants feature List Properties and Methods feature 2nd organizing Parameter Info feature procedurescalling 2nd 3rd 4th 5th private procedures 2nd public procedures scope precedence static procedures Quick Info feature standard statementsOption Explicit Opton Explicit subroutines 2nd creating 2nd 3rd tools 2nd 3rd 4th variablesdeclaring VBA 2nd 3rd 4th 5th 6th 7th versus macros viewingFull Module View viewing (Module Design window) Modules collection monitorsdriversminimum system requirements resolutionperformance considerations Month() function MonthLength propertyCalendar control MonthName function More Controls tool morphingcombo boxesto list boxes text boxesto combo boxes 2nd morphing controls 2nd 3rd mousemoving form objects 2nd reportsselecting objects selecting form objects 2nd sizing objects mouse actionsformsForm event sequence MouseDown eventcontrols forms MouseMove eventcontrols forms MouseUp eventcontrols forms Move methodrecordsets Moveable propertyforms MoveFirst methodrecordsets 2nd MoveLast methodrecordsets 2nd MoveLayout propertyreports 2nd 3rd MoveNext method data access class 2nd recordsets 2nd MovePrevious method data access class 2nd recordsets movingform objects 2nd report objects moving between formsForm event sequence MS Office 97VBA MSDE (Microsoft Database Engine) MSE (Microsoft Script Editor)customizing data access pages 2nd 3rd MsgBox function 2nd 3rd 4th multifact crosstab reportscreating 2nd 3rd 4th multipage formscreating 2nd 3rd 4th multiple class instances (Class modules), creating 2nd Multiselect propertylist boxes 2nd multitable queriescreating 2nd 3rd 4th fieldsupdating pitfalls 2nd row fix-up feature 2nd 3rd multiuser applicationsdesigning installing 2nd installing Access 2nd My Documents folder MyCustomForm function