Programming MicrosoftВ® Office Access 2003 (Core Reference) (Pro-Developer)

Q-R

Queries class (Access projects), Table 11.1: Object Bar Classes in the Database Window of an Access Project

queries. <charcntd>See <Default Para Font>select queries<$nopage>, Chapter 4: Jet SQL, the ADOX Library, and Queries

Query Analyzer, Getting Books Online

Query Designer, Basic Select Queries, Using the Access Project Query Designer

query, form. <charcntd>See <Default Para Font>forms<$nopage>, Automatically Requerying Forms

Quit method (ActiveWorkbook object), Running Excel Procedures from an Access Procedure

Read method (Stream object), Recordsets, Records , Streams , and the Web

read-only forms, Assigning an ADO Recordset as the Source

ReadAndEditATextFile( ) (example), Importing Data from Text Files

reading text files<$endrange>, Saving To and Recovering From Streams

reading text files<$startrange>, Reading Text Files with Streams

ReadText method (Stream object), Recordsets, Records , Streams , and the Web, Saving To and Recovering From Streams

ReadWriteOrReadOnly(  ) (example), Figure 12.11:     Column values containing hyperlink data from the CreateLinksTable procedure.

Real data type (SQL server), Table 11.3: SQL Server Column Data Types

Record objects<$endrange>, Recordsets, Records , Streams , and the Web

Record objects<$startrange>, Recordsets, Records , Streams , and the Web

Record objects\

GetChildren method, Recordsets, Records , Streams , and the Web

Open method, Recordsets, Records , Streams , and the Web

ParentURL property, Recordsets, Records , Streams , and the Web

printing web folder contents and properties<$endrange>, Printing the Properties for Web Folder Contents

printing web folder contents and properties<$startrange>, Printing Web Folder Contents

Record Selectors property (forms), Creating a Splash Screen

records in database tables<$endrange>, Recordsets, Records , Streams , and the Web

records in database tables<$startrange>, Recordsets, Records , Streams , and the Web

records in database tables\

printing web folder contents and properties<$endrange>, Printing the Properties for Web Folder Contents

printing web folder contents and properties<$startrange>, Printing Web Folder Contents

records in databases. <charcntd>See <Default Para Font>Recordset objects<$nopage>, Adding, Editing, and Deleting Records

records in databases. <charcntd>See <Default Para Font>recordsets<$nopage>, Adding, Editing, and Deleting Records

records\

deleting\

archiving deleted records<$endrange>, Figure 11.24:     A message box generated by the ComputePercentChangeBetweenYears stored procedure when...

archiving deleted records<$startrange>, Archiving Updated and Deleted Records

Recordset objects<$endrange>, Figure 1.8:     The Object Browser showing a selection of data type constants for defining fields.

Recordset objects<$startrange>, The Recordset Object

Recordset objects\

adding, editing, deleting records<$endrange>, Table 1.4: Intrinsic Constants for the SeekEnum

adding, editing, deleting records<$startrange>, Adding, Editing, and Deleting Records

aggregated fields<$endrange>, Right Outer Joins

aggregated fields<$startrange>, Using Aggregates with GROUP BY and HAVING Clauses

assigning as form source<$endrange>, Assigning a SQL Statement as the Source

assigning as form source<$startrange>, Assigning an ADO Recordset as the Source

assigning as form source\

AddNew method, Working with Values from Excel Worksheets

CursorLocation property\: editability of forms, Updating Form Data with an ADO Recordset Assignment

Filter property, Programming Form Server Filters

inserting data<$endrange>, Processing Main/Subforms

inserting data<$startrange>, Inserting Data Using a Form Based on an ADO Recordset

Update method, Working with Values from Excel Worksheets

updating form data<$endrange>, Processing Main/Subforms

updating form data<$startrange>, Updating Form Data with an ADO Recordset Assignment

calculated fields<$endrange>, Figure 4.3:     Output of the SelectGroupBy procedure demonstrates the effect of a GROUP BY ...

calculated fields<$startrange>, Selecting and Ordering with Calculated Fields

creating Field objects for<$endrange>, Figure 1.9:     An excerpt from the report.txt file showing grouping and aggregation by quarter.

creating Field objects for<$startrange>, Creating Fields for a Recordset

creating with Command queries<$endrange>, Creating a Recordset with a Parameter Query

creating with Command queries<$startrange>, Creating a Recordset with a Select Query

deleting with Command queries<$endrange>, Inserting Records

deleting with Command queries<$startrange>, Deleting Records

inserting with Command queries<$endrange>, Recordsets, Records , Streams , and the Web

inserting with Command queries<$startrange>, Inserting Records

ISAM applications to update remote data, Working with Values from Excel Worksheets

managing row-returning queries<$startrange>, Managing Row-Returning Queries with ADOX

managing row-returning queries\

methods<$endrange>, Selected Recordset Methods

methods<$startrange>, Selected Recordset Methods

methods\

adding and removing queries<$endrange>, Creating and Using Parameter Queries

adding and removing queries<$startrange>, Adding and Removing Queries

CursorLocation property, Sorting Recordsets

CursorLocation property\:editability of forms, Assigning an ADO Recordset as the Source

Filter property<$endrange>, Figure 1.6:     The XML contents for the file saved by the SaveAccessDBRecordSource procedure, as seen...

Open method, Recordsets, Records , Streams , and the Web

parameter queries<$endrange>, Creating and Using Parameter Queries

parameter queries<$startrange>, Creating and Using Parameter Queries

Save method<$endrange>, Persisting Recordsets

Sort property<$endrange>, Figure 1.8:     The Object Browser showing a selection of data type constants for defining fields.

Sort property<$startrange>, Sorting Recordsets

UpdateBatch method<$endrange>, Persisting Recordsets

UpdateBatch method<$startrange>, Persisting Recordsets

ActiveConnection property, Selected Recordset Properties

AddNew method, Selected Recordset Methods, Adding a Row

CacheSize property, Selected Recordset Methods

CursorLocation property, Selected Recordset Properties

CursorType property, Selected Recordset Properties

Filter property, Selected Recordset Properties

Filter property<$startrange>, Filtering Records

Find method, Selected Recordset Methods

Find method<$endrange>, Table 1.4: Intrinsic Constants for the SeekEnum

Find method<$startrange>, Finding Records

GetRows method, Selected Recordset Methods

GetRows method<$endrange>, Printing Recordset Rows

GetRows method<$startrange>, Printing Recordset Rows

GetString method, Selected Recordset Methods, Printing Recordset Rows

LockType property, Selected Recordset Properties

Open method, Selected Recordset Methods

Open method<$endrange>, Connecting to Jet Databases

Open method<$startrange>, Connecting to Jet Databases

mode settings<$endrange>, Table 1.2: ConnectModeEnum Members

mode settings<$startrange>, The Mode Property

printing rows<$endrange>, Printing Recordset Rows

printing rows<$startrange>, Printing Recordset Rows

properties\

Save method<$startrange>, Persisting Recordsets

Seek method<$endrange>, Seeking Records

Seek method<$startrange>, Seeking Records

Sort property, Selected Recordset Properties

sources for reports <$endrange>, Mailing Snapshots

sources for reports<$startrange>, Using an ADO Recordset as the Report's Record Source

updating values with Command queries<$endrange>, Updating Values

updating values with Command queries<$startrange>, Updating Values

Recordset property (reports), Using an ADO Recordset as the Report's Record Source

recordsets<$endrange>, Figure 1.8:     The Object Browser showing a selection of data type constants for defining fields.

recordsets<$startrange>, The Recordset Object

recordsets\

access mode settings<$endrange>, Table 1.2: ConnectModeEnum Members

access mode settings<$startrange>, The Mode Property

adding, editing, deleting rows<$endrange>, Table 1.4: Intrinsic Constants for the SeekEnum

adding, editing, deleting rows<$startrange>, Adding, Editing, and Deleting Records

aggregated fields<$endrange>, Right Outer Joins

aggregated fields<$startrange>, Using Aggregates with GROUP BY and HAVING Clauses

aggregating in SQL Server views<$endrange>, Converting Dates and Times to Different Formats

aggregating in SQL Server views<$startrange>, Aggregating Records in a View

assigning as form source<$endrange>, Assigning a SQL Statement as the Source

assigning as form source<$startrange>, Assigning an ADO Recordset as the Source

assigning as form source\

form interactivity<$endrange>, Figure 5.23:     These forms let the user see monthly sales data for a selected year.

form interactivity<$startrange>, User Interactivity Based on Parameter Queries and ADO

inserting data<$endrange>, Processing Main/Subforms

inserting data<$startrange>, Inserting Data Using a Form Based on an ADO Recordset

server filters<$endrange>, Sorting on Any Field in Any Direction

server filters<$startrange>, Programming Form Server Filters

stored procedure results<$endrange>, Figure 11.22:     The output to the Immediate window for the InOutReturnDemo VBA procedure.

stored procedure results<$startrange>, Sorting Result Sets

stored procedures for<$endrange>, Creating and Using Triggers from the Access UI

stored procedures for<$startrange>, Inserting, Updating, and Deleting Records

updating form data<$endrange>, Processing Main/Subforms

updating form data<$startrange>, Updating Form Data with an ADO Recordset Assignment

calculated fields<$endrange>, Figure 4.3:     Output of the SelectGroupBy procedure demonstrates the effect of a GROUP BY ...

calculated fields<$startrange>, Selecting and Ordering with Calculated Fields

controlling manipulation (with LockType), Selected Recordset Properties

copying into memory, Selected Recordset Methods

copying into memory<$endrange>, Printing Recordset Rows

copying into memory<$startrange>, Printing Recordset Rows

creating fields for<$endrange>, Figure 1.9:     An excerpt from the report.txt file showing grouping and aggregation by quarter.

creating fields for<$startrange>, Creating Fields for a Recordset

creating with parameter queries<$endrange>, Creating a Recordset with a Parameter Query

creating with parameter queries<$startrange>, Creating a Recordset with a Parameter Query

creating with parameter queries\

creating with select queries<$endrange>, Creating a Recordset with a Select Query

creating with select queries<$startrange>, Creating a Recordset with a Select Query

cursor types, Connecting to Jet Databases, Selected Recordset Properties

deleting<$endrange>, Inserting Records

deleting<$startrange>, Deleting Records

deleting\

filtering records, Selected Recordset Properties

filtering records<$endrange>, Figure 1.6:     The XML contents for the file saved by the SaveAccessDBRecordSource procedure, as seen...

filtering records<$startrange>, Filtering Records

filtering records\

inserting new, Selected Recordset Methods

inserting rows with SQL Server<$endrange>, Figure 11.12:     The Properties dialog box for the OrderID column that shows the setting for the Identity,...

inserting rows with SQL Server<$startrange>, Defining Tables and Inserting Rows

inserting<$endrange>, Recordsets, Records , Streams , and the Web

inserting<$startrange>, Inserting Records

inserting\

managing row-returning queries<$startrange>, Managing Row-Returning Queries with ADOX

managing row-returning queries\

MaxRecords property, Aggregating Records in a View

navigating, Selected Recordset Methods

opening, Selected Recordset Methods

persisting<$endrange>, Persisting Recordsets

persisting<$startrange>, Persisting Recordsets

persisting\

adding and removing queries<$endrange>, Creating and Using Parameter Queries

adding and removing queries<$startrange>, Adding and Removing Queries

parameter queries<$endrange>, Creating and Using Parameter Queries

parameter queries<$startrange>, Creating and Using Parameter Queries

to streams<$endrange>, Saving To and Recovering From Streams

to streams<$startrange>, Saving To and Recovering From Streams

printing rows<$endrange>, Printing Recordset Rows

printing rows<$startrange>, Printing Recordset Rows

properties<$endrange>, Selected Recordset Properties

properties<$startrange>, Selected Recordset Properties

referencing with Open method, Recordsets, Records , Streams , and the Web

referencing with Open method<$endrange>, Connecting to Jet Databases

referencing with Open method<$startrange>, Connecting to Jet Databases

retrieving as text, Selected Recordset Methods, Printing Recordset Rows

searching for records, Selected Recordset Methods

searching for records<$endrange>, Seeking Records

searching for records<$startrange>, Finding Records

sorting, Selected Recordset Properties

sorting<$endrange>, Figure 1.8:     The Object Browser showing a selection of data type constants for defining fields.

sorting<$startrange>, Sorting Recordsets

sorting\

sources for reports<$endrange>, Mailing Snapshots

sources for reports<$startrange>, Using an ADO Recordset as the Report's Record Source

updating values of<$endrange>, Updating Values

updating values of<$startrange>, Updating Values

updating values of\

RecordsetType property (forms), specifying<$endrange>, Figure 12.11:     Column values containing hyperlink data from the CreateLinksTable procedure.

RecordsetType property (forms), specifying<$startrange>, Specifying a Form's RecordsetType Property in Access Projects

RecordSource property (forms), Graphing Child Data in a Main/Subreport Design

RecordSource property (forms)<$endrange>, Assigning a SQL Statement as the Source

RecordSource property (forms)<$startrange>, Assigning an ADO Recordset as the Source

RecordSource property (reports)\

updating reports dynamically<$endrange>, Mailing Snapshots

updating reports dynamically<$startrange>, Dynamically Updating Reports

recordssets\

updating\

archiving updated records<$endrange>, Figure 11.24:     A message box generated by the ComputePercentChangeBetweenYears stored procedure when...

archiving updated records<$startrange>, Archiving Updated and Deleted Records

recovering recordsets from streams<$endrange>, Saving To and Recovering From Streams

recovering recordsets from streams<$startrange>, Saving To and Recovering From Streams

REFERENCES permission, Managing Permissions

Refresh method (forms), Assigning a SQL Statement as the Source

RefreshDatabaseWindow method, Defining Tables and Inserting Rows

RefreshScopes method (FileSearch object), FileSearch Object

related tables, exporting as XML, Exporting Related Tables

RelatedTable property (Key object), The Key Object

relative URLs, Recordsets, Records , Streams , and the Web

releasing memory\

setting objects to Nothing, Connecting to Jet Databases

remote databases, connecting to, Connecting to Non-Jet Databases

Remove method\

CurrentProject object, Printing the CurrentDB and CurrentProject Properties

RemoveAView( ) (example), Adding and Removing Queries

RemoveCopyNorthwindLink(  ) (example), Figure 8.6:     You use the CommandBar object model to customize built-in command bars and create custom...

RemoveEmails(  ) (example), Deleting Multiple Items from the Contacts Folder

RemoveItem method (form controls), Controlling FileType with a Custom Form and Procedure

RemoveOneEmail(  ) (example), Deleting Multiple Items from the Contacts Folder

RemovePriceAndQuantityTotals(  ) (example), Figure 7.8:     The PivotChart view created by the CreateChart procedure.

RemoveTotal method (PivotTables)<$endrange>, Figure 7.8:     The PivotChart view created by the CreateChart procedure.

RemoveTotal method (PivotTables)<$startrange>, Removing Totals Fields

RemoveUserFromGroup(  ) (example), Figure 10.7:     A group membership report from the ListGroupsInCat procedure.

removing. <charcntd>See <Default Para Font>deleting<$nopage>, Report Sections

replication\

JRO library, ADO Components for Microsoft Access Developers

report controls\

adding manually, Manually Laying Out a Customer Phone List Report

creating, Creating Reports Programmatically

creating<$endrange>, Figure 6.2:     The first Report Wizard dialog box for creating the report shown in Figure 6-3.

creating<$startrange>, Programmatically Creating a Report with Controls

formatting with FormatCondition objects<$endrange>, Figure 6.26:     This report uses two event procedures and a text box to compute a page sum in its Page Footer section. A third...

formatting with FormatCondition objects<$startrange>, Formatting Report Controls with FormatCondition Objects

properties of, modifying, Modifying Report Control Properties

Report objects, The OpenDataSource Method

Report Wizard, Creating Reports, Creating Reports with Wizards

Report Wizard\

phone list, creating (example)<$endrange>, Creating a Customer Phone List with the Report Wizard

phone list, creating (example)<$startrange>, Creating a Customer Phone List with the Report Wizard

ReportBasedOnADORecordset(  ) (example), Using an ADO Recordset as the Report's Record Source

ReportDataTypes(  ) (example), Mapping SQL Server to Access and ADO Data Types

Reports class (Access projects), Table 11.1: Object Bar Classes in the Database Window of an Access Project

Reports collection, Programmatically Creating a Report with Controls

reports, basing data access pages on<$endrange>, Basing Data Access Pages on Access Forms and Reports

reports, basing data access pages on<$startrange>, Basing Data Access Pages on Access Forms and Reports

reports, interactive (data access pages)<$endrange>, Applying Conditional Formatting to a Report

reports, interactive (data access pages)<$startrange>, Creating Interactive Reports with Computed Fields

reports, interactive (data access pages)\

calculated fields<$endrange>, Adding Calculated Fields to a Report

calculated fields<$startrange>, Adding Calculated Fields to a Report

conditional formatting<$endrange>, Applying Conditional Formatting to a Report

conditional formatting<$startrange>, Applying Conditional Formatting to a Report

multilevel reports, Building a Three-Level Report

two-level reports, Building a Two-Level Report

reports, programming in Access projects<$endrange>, Setting and Restoring the InputParameters Property

reports, programming in Access projects<$startrange>, Programming Reports in Access Projects

reports, programming in Access projects\

InputParameters property<$startrange>, Setting and Restoring the InputParameters Property

sorting on fields<$endrange>, Sorting on Any Field in Any Direction

sorting on fields<$startrange>, Sorting on Any Field in Any Direction

reports<$endrange>, Summary

reports<$startrange>, Chapter 6: Reports, Controls, and Data

reports\

architecture and strategies<$endrange>, Creating Reports

architecture and strategies<$startrange>, Report Architecture and Creation Strategies

charts , Creating Reports with Wizards

charts<$endrange>, Using the Chart Wizard

charts<$startrange>, Using the Chart Wizard

charts\

creating in Design View<$endrange>, Graphing Child Data in a Main/Subreport Design

creating in Design View<$startrange>, Creating Reports in Design View

creating in Design View\

FormatCondition objects<$endrange>, Figure 6.26:     This report uses two event procedures and a text box to compute a page sum in its Page Footer section. A third...

FormatCondition objects<$startrange>, Formatting Report Controls with FormatCondition Objects

hierarchical reports with<$endrange>, Graphing Child Data in a Main/Subreport Design

hierarchical reports with<$startrange>, Hierarchical Reports with Groups, Subreports, and Charts

hierarchical<$endrange>, Graphing Child Data in a Main/Subreport Design

hierarchical<$startrange>, Hierarchical Reports with Groups, Subreports, and Charts

mailing snapshots<$startrange>, Mailing Snapshots

Print event<$endrange>, Formatting Reports with the Print Event

Print event<$startrange>, Formatting Reports with the Print Event

producing in Microsoft Word<$endrange>, Figure 9.9:     Excerpts from a Word document for printing form letters .

producing in Microsoft Word<$startrange>, Producing Mailing Labels

sorting/grouping by date<$endrange>, Sorting and Grouping by Date

sorting/grouping by date&l