Beginning Access 2002 VBA (Programmer to Programmer)

D

D \t, Chapter 1: Designing Applications

DAO (Data Access Objects)

ADO vs DAO \b \rADO1, DAO vs ADO

ADO vs DAO \b \rDAO1, DAO or ADO?, ADO vs. DAO

application defined properties \b, Custom DAO Properties

custom properties \b \rcustom1, Custom DAO Properties

Database objects \b \rDatabase1, The Database Object

database properties \b \rdatabase1, Custom DAO Properties

Databases collections \rDatabases1, The Database Object

DBEngine object \b \rDBEngine1, The DBEngine Object

Error objects \rError1, Data-Access Objects

Error objects \rError2, Try It Out-The Errors Collection

errors \b \rDAO1, Data-Access Objects

Errors collections \b \rErrors1, Data-Access Objects

Errors collections \rErrors2, Creating a Library Database

Field objects, Working with Tables

Field objects \rField1, Working with Tables

Field objects \rField2, Working with Tables

Field objects \rField3, Working with Tables

Fields collections, Working with Tables

Fields collections \rFields1, Working with Tables

Fields collections \rFields1 DAO

Recordset object, Working with Recordsets

Index objects, Working with Tables

Index objects \rIndex1, Working with Tables

Index objects \rIndex2, Working with Tables

QueryDef objects, The QueryDefs Collection

QueryDef objects \b \rQueryDef1, Creating and Modifying DAO QueryDefs

QueryDef objects \b \rQueryDef2, Modifying the QueryDef

QueryDefs collections, Creating and Modifying DAO QueryDefs

QueryDefs collections \b \rQueryDefs1 DAO

Recordset objects \b \rRecordset1 DAO, Different Types of Recordset

Recordset objects \rRecordset1, Try It Out-Implementing the PaymentStats logic, Use Appropriate Recordset Types

Recordsets collections \b \rRecordsets1, The Recordsets Collection

TableDef objects \rTableDef1 VBA, Working with Tables

TableDef objects \rTableDef2, Working with Tables

TableDef objects \rTableDef3, Working with Tables

Tabledefs collections, Working with Tables

Tabledefs collections \b \rTabledefs1 DAO

Database object, The TableDefs Collection, The QueryDefs Collection

Tabledefs collections \rTableDefs1, Creating a Library Database

tables, Working with Tables

Workspace objects \b \rWorkspace1, The Workspace Object

Workspaces collections \rWorkspaces1, The Workspace Object

DAO (Data Access Objects) \i \rDAO1, Chapter 6: Using DAO

DAPs (data access pages)

connection files \b \rconnection1, DAP Connection Files

events \b \revents1, New DAP Events

DAPs (data access pages) \i \rDAPs1, Data Access Pages and Access XP

Data Access Objects (see DAO) \t, Custom DAO Properties

data access pages (see DAPs) \t, Data Access Pages and Access XP

data analysis, Access applications \i \rdata1, Data Analysis

data consumers, OLEDB \i, So, What is OLE DB?

data providers, OLEDB \i, So, What is OLE DB?

data service providers, OLEDB \i, So, What is OLE DB?

data types (see types) \t, Variable Types

database bloat, Other Considerations

database diagrams, SQL Server, What's New in your Database?

database engines (see engines, databases) \t, Choosing a Storage Engine

Database objects, DAO

CreateQueryDef method, Creating and Modifying DAO QueryDefs

CreateTableDef method, Working with Tables

OpenRecordset method, Dynasets and Snapshots, Try It Out-Implementing the PaymentStats logic

OpenRecordset method \rOpenRecordset1, Different Types of Recordset

OpenRecordset method \rOpenRecordset2, Building Recordsets Dynamically

OpenRecordset method \rOpenRecordset3, Working with Recordsets

Database objects, DAO \i \rDatabase1, The Database Object

database objects, SQL Server, What's New in your Database?

ADO, What's New in your Database?

database diagrams, What's New in your Database?

stored procedures, What's New in your Database?, Stored Procedures

UDF (user-defined functions), What's New in your Database?, User -Defined Functions (UDFs)

views, What's New in your Database?, Views

database properties, DAO \i \rdatabase1, Custom DAO Properties

database roles, SQL Server security, Database Roles

asigning users to, example, Database Roles, Try It Out-Create the Whole Works

default, listing, Database Roles

Database Splitter add-in \i \rSplitter1, The Database Splitter

Databases collections, DAO \rDatabases1, The Database Object

DataChanged property, Form objects, New Object Properties & Methods

Date function, Date, Other Useful Date and Time Fuctions

Date type, Variable Types, Use the Right Data Type

Date type \i \rDate1, Date

DateAdd function, Date

DateAdd function \rDateAdd1, Try It Out-Dates

DateCreated property, AccessObject objects, New Object Properties & Methods

DateDiff function, Date

DateDiff function \rDateDiff1, Try It Out-Dates

DateModified property, AccessObject objects, New Object Properties & Methods

DATENAME function, SQL Server, qrySalesSummary

options, qrySalesSummary

DatePart function, Date

DatePart function \rDatePart1, Try It Out-Dates

DatePart function \rDatePart2, Try It Out-Using DatePart in a Query

dates

reports \b \rdates1, Dates

dates \i \rdates1, Notes on Formatting Dates and Currency Amounts in VBA

DBEngine object, DAO

CompactDatabase method \rCompactDatabase1, Compact the Database

DBEngine object, DAO \i \rDBEngine1, The DBEngine Object

dbo table owner prefix, SQL Server, Views

Deactivate event, reports \i \rDeactivate1, Deactivate

Debug object

Assert method, Use Variables , Not Properties

debugging (see also errors)

assertions \b \rassertions1, Assertions

breakpoints \b \rbreakpoints1, Breakpoints

Call Stack button, Hovering

Call Stack button \b \rStack1, The Call Stack

Continue button \b, Continuing Execution

Immediate window, Parameters or Arguments, Try It Out-Examining a Variant, Try It Out-How Null Propagates, Try It Out-Dates, Local Variables, Static Variables, Try It Out-Module Variables, Hovering, Visual Basic Errors

Immediate window \b \rImmediate1, Testing the ReportHistory Function in the Immediate Window, The Immediate Window

Immediate window \rImmediate1, Function Types, Working with Recordsets

Immediate window \rImmediate2, Function Types

Immediate window \rImmediate3, Function Types

Immediate window \rImmediate4, Variable Scope and Lifetime

Immediate window \rImmediate5, Local Variables

Locals window, Hovering

Locals window \b \rLocals1, The Locals Window

Locals window \rLocals1, Working with Recordsets

Locals window \rLocals2, Hovering

Quick Watch button, Hovering

Quick Watch button \b \rQuick1, Quick Watches

Quick Watch button \rQuick2, Hovering

Reset button \b, Stopping Execution

Run To Cursor button, Stepping through Code, Skipping Lines of Code, Hovering

Show button, Hovering

Step Into button, Stepping through Code, Hovering

Step Into button \rInto1, Hovering

Step Out button, Stepping through Code, Hovering

Step Over button, Stepping through Code, Hovering

Stop button, Hovering

Stop statements \b \rStop1, The Stop Statement

Stop statements \rStop1, Working with Recordsets

Watches window \b \rWatches1, The Watch Window

Watches window \rWatches2, Hovering

Watches window \rWatches3, Hovering

debugging (see also errors) \i \rdebugging1, Debugging

debugging (see also errors) \i \rdebugging2, Debugging your Debugging Code

Decimal type, Use the Right Data Type

Declarations sections, modules, Try It Out-Creating an Enum

Declarations sections, modules \rDeclarations1, Declaring a DLL in Code

declarations, procedures \i, Procedure Declaration

default events \i \rdefault1, Default Events

default instances, forms \i, Creating Multiple Instances of Forms

default values, arguments

SQL Server migration, Upsizing Wizard, Running the Upsizing Wizard

default values, arguments \i \rdefault1, Default Values

Delete method, ADO Recordset objects, Deleting Records

Delete method, DAO Recordset objects, Editing Records in Recordsets, When a Recordset Can't be Updated

delete queries, Try It Out-Deleting a Company Record from tblcompany

deployment, Access solutions, Other Considerations

Description property, Err objects, The Err Object

Design view, forms \i \rDesign1, Try It Out-Changing a Form's Appearance in Design View

designing for change \i \rchange1, Designing for Change

destructive testing \i \rdestructive1, Testing

deterministic/ non-deterministic UDF, SQL Server, User-Defined Functions (UDFs)

development, Access applications

analysis phase \b \ranalysis1, The Analysis Phase

development, Access applications \i \rdevelopment1, The Development Process

DHTML \i \rDHTML1, The Internet

Dim statements

login, creating, Try It Out-Adding a Login to SQL Server

object variables \rDim1, Creating Automation Objects

Dim statements \rDim1, Declaring Variables, Dynamic Arrays

Dim statements \rDim2, Variant

Dirty event, DAPs, New DAP Events

disconnected recordsets, ADO \i \rdisconnected1, Disconnected Recordsets

DLLs (dynamic link libraries) \i \rDLLs1, Dynamic Link Libraries (DLLs)

Do loops \i \rDo1, Do...Loop

DoCmd object

OpenForm method, Try It Out-Editing Hyperlinks

TransferDatabase method \rTransferDatabase1, Databases

TransferSpreadsheet method \rTransferSpreadsheet1, Spreadsheets

TransferText method, Specifications

TransferText method \rTransferText1, Text Files

documentation, Access applications \i \rdocumentation1, Documentation

Documents collections, Word \rDocuments2, Microsoft Word

documents, Word \i \rdocuments1, Microsoft Word

DoEvents statements \i \rDoEvents1, Use DoEvents Judiciously

Double type, Variable Types, Use the Right Data Type, Use Integer Arithmetic Where Possible

Double type \i \rDouble1, Double and Single

dynamic arrays

Dim statements \rDim1, Dynamic Arrays

Erase statements, Erasing Arrays

multi-dimensional arrays \b \rdynamic1, Dynamic Multi-dimensional Arrays

ReDim statements \b \rReDim1, Redimensioning Existing Arrays

dynamic arrays \i \rdynamic1, Dynamic Arrays

dynamic link libraries (see DLLs) \t, Dynamic Link Libraries (DLLs)

dynamic list boxes (see list boxes) \t, Dynamic Listboxes

dynaset-type Recordset objects, DAO

RecordCount property \b \rdynasettype2, Dynasets and Snapshots

dynaset-type Recordset objects, DAO \i \rdynasettype1, Dynaset-type Recordset Objects

dynaset-type Recordset objects, DAO \rdynasettype1, Use Appropriate Recordset Types

dynaset-type Recordset objects, DAO \rdynasettype3, When a Recordset Can't be Updated