Index

C

CacheSize property (Recordset object), Selected Recordset Methods

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

calculated fields\

data access page reports<$endrange>, Adding Calculated Fields to a Report

data access page reports<$startrange>, Adding Calculated Fields to a Report

CallAddAfterUpdateEvent( ) (example), Programming a Combo Box with an Event Procedure

CallAddAView( ) (example), Adding and Removing Queries

CallAddGroupToUser( ) (example), Assigning Groups to Users

CallAddParamQuery( ) (example), A Delete Parameter Query

CallAddSQLServerAuthentication( ) (example), Setting Mixed Authentication

CallAddUnboundCboToForm( ) (example), Programming a Combo Box with an Event Procedure

CallAndDemoResetCounter( ) (example), Changing AutoNumber Settings

CallAttachADB( ) (example), Attaching and Detaching Database Files

CallCopyFileUtility( ) (example), A Utility for Copying Files Based on FileSystemObject

CallCreateASnapShotReport( ) (example), Creating a Snapshot

CallCreateCustomNamedReport( ) (example), Creating and Saving a Report with a Custom Name

CallDeleteARecordsetRow( ) (example), Deleting a Row

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

CallDeleteLinkedTables( ) (example), Linking Using the DoCmd Method

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

CallDetachADB( ) (example), Attaching and Detaching Database Files

CallFieldNameValue( ) (example), Name and Value Properties

CallFileSearch2XP( ) (example), Generalizing a Search and Sorting Its Return Set

CallFilterForShippers( ) (example), Filtering PivotTables

CallFilterOnCountryAndCity( ) (example), Filtering Records

CallFindCustomersInACountry( ) (example), Finding Records

CallListLinkedTables( ) (example), Linking Using the DoCmd Method

CallListSiteFilesAndFolders( ) (example), Printing the Properties for Web Folder Contents

CallListTablesRaw( ) (example), Listing All Table Types in a Catalog

CallListTablesTypeFilter( ) (example), Filtering Table Types Before Enumerating

CallLoginSecureAndListDBs( ) (example), Ensuring Secure Login and Enumerating Databases

CallMakeAJetDB( ) (example), Creating a New Database

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

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

CallNewDataAccessPageForNewPage( ) (example), Creating and Deleting Data Access Pages

CallOpenSubsetOfView( ) (example), Joining Tables for a Lookup

CallParseAllNodesInATable( ) (example)<$endrange>, Figure 15.12: The table that appears when a browser opens Shippersp21.htm.

CallParseAllNodesInATable( ) (example)<$startrange>, Viewing and Manipulating an XML Document

CallPrintDAPConnectionString( ) (example), Figure 14.18: Automatically generated data access pages can have the same look and feel as Access forms.

CallPrintMetaTags( ) (example), Retrieving Data from Web Files

CallPrintViewsInADBOnLocalServer( ) (example), Adapting Books Online Code for a VBA Project

CallRemoveAView( ) (example), Adding and Removing Queries

CallRemovePriceAndQuantityTotals( ) (example), Removing Totals Fields

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

CallReturnDateStyle( ) (example), Converting Dates and Times to Different Formats

CallReturnTimeStyle( ) (example), Converting Dates and Times to Different Formats

CallSetAllTablePermissionsForGroup( ) (example), Putting It All Together

CallSetRIDTablePermissionsForGroupTable( ) (example), Putting It All Together

CallSortedTableTypes( ) (example), Sorting Recordsets

CallTablesDetail( ) (example), Printing Data for the Table Details View

CallTotalExtendedPriceAndQuantity( ) (example), Adding Totals Fields

CallTrailingCharactersInString( ) (example), Copying a Table's Design from One Database to Another

CallTwoWaysToPopulateTables( ) (example), Inserting vs. Copying

CallUpdateAFieldValue( ) (example), Editing a Row

CallUtilityToNameFieldSetMembersForm1( ) (example), Constructing a PivotTable for a Query

CallVBAPercentChange( ) (example), Scalar User-Defined Functions

candidate keys, The Column Object

Caption property (Label controls), Automatically Publishing a Datasheet to a Web Site

Caption property (PivotCharts), Adding a PivotChart View to a Custom Form

caret (^) as query wildcard, Using SQL Server–Compatible Syntax Switches

CAST function, Converting Dates and Times to Different Formats

Catalog object, The Catalog Object

Catalog object\

creating databases, Creating a New Database

cboCategoryName_AfterUpdate( ) (example), Programming Conditional Combo Boxes

cboCustomers_AfterUpdate( ) (example), Figure 5.23: These forms let the user see monthly sales data for a selected year.

cboLookup_AfterUpdate( ) (example), Displaying Results in a Message Box

cboProductName_AfterUpdate( ) (example), Programming Conditional Combo Boxes

CDATA sections, XML documents, XML Document Syntax

ChangePassword method (User object), Adding and Deleting Users

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

Chart controls, Office Web Components

Chart controls<$endrange>, Office Chart Sample

Chart controls<$startrange>, Office Chart Sample

Chart objects<$startrange>, Charting a Subset of Data

Chart Wizard, Charting a Subset of Data, Creating Reports with Wizards

Chart Wizard<$endrange>, Using the Chart Wizard

Chart Wizard<$startrange>, Using the Chart Wizard

charting data subsets<$startrange>, Charting a Subset of Data

charting PivotTable data. <charcntd>See <Default Para Font>PivotCharts<$nopage>, Chapter 7: Designing and Using PivotTables and PivotCharts

charts, Creating Reports with Wizards

charts<$endrange>, Using the Chart Wizard

charts<$startrange>, Using the Chart Wizard

charts\

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

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

ChartSpace object (forms). <charcntd>See <Default Para Font>PivotCharts<$nopage>, Programmatically Creating PivotCharts

Chatset property (Stream object), Retrieving Data from Web Files

check constraints for columns<$startrange>, Creating Check Constraints for Columns

CHECK keyword<$startrange>, Creating Check Constraints for Columns

CheckEAddress( ) (example), Creating Check Constraints for Columns

CheckMailItTag( ) (example)<$startrange>, Mailing Snapshots

CheckMailItTag( ) (example)<$endrange>, Mailing Snapshots

Circle method (reports), Formatting Reports with the Print Event

Class property (charts), Using the Chart Wizard

Click events (command buttons), Navigating with Code Behind Form

Close event (reports), Making Reports Dynamic

CloseNamedForm( ) (example), Running Procedures from Hyperlinks

Clustered property (Index object), The Index Object

cmdGoHere_Click( ) (example), Navigating with Code Behind Form

cmdNext_Click( ) (example)\

navigating Excel data, Figure 9.6: An Access form used to browse filtered Outlook Inbox items.

cmdPrevious_Click( ) (example)\

navigating Excel data, Figure 9.6: An Access form used to browse filtered Outlook Inbox items.

cmdReturnToMain_Click( ) (example), Figure 5.7: A sample On Click event setting that lets a hyperlink execute a function procedure even though the form on which...

cmdRunQuery_Click( ) (example), Figure 5.22: A form to display customer orders in the List Box control.

cmdShowCustomer_Click( ) (example), Dynamically Displaying Information

code behind forms<$endrange>, Figure 5.7: A sample On Click event setting that lets a hyperlink execute a function procedure even though the form on which...

code behind forms<$startrange>, Navigating with Code Behind Form

colors, hyperlinks, Assigning an ADO Recordset as the Source

column data types, SQL<$endrange>, Mapping SQL Server to Access and ADO Data Types

column data types, SQL<$startrange>, SQL Server Column Data Types

column data types, SQL\

mapping<$endrange>, Mapping SQL Server to Access and ADO Data Types

mapping<$startrange>, Mapping SQL Server to Access and ADO Data Types

setting and looking up<$endrange>, Setting and Looking Up Column Data Types

setting and looking up<$startrange>, Setting and Looking Up Column Data Types

Column object, The Column Object

ColumnAxis property (Fieldsets collection), Constructing a PivotTable for a Query

columns of database tables. <charcntd>See <Default Para Font>Field objects<$nopage>, The Field Object

columns, table, The Column Object

COMAddin objects, Table 8.1: Shared Office Objects

combining tables\

inner joins<$endrange>, Right Outer Joins

inner joins<$startrange>, Selecting with Inner Joins

outer and self joins<$endrange>, Selecting with Subqueries

outer and self joins<$startrange>, Selecting with Outer Joins and Self Joins

Combo Box Wizard, Using the Combo Box Wizard with SQL Server

combo boxes<$endrange>, Figure 5.19: The form at the top displays its result set in message boxes so that users can view the result set but not...

combo boxes<$startrange>, Using a Combo Box for User Input

combo boxes\

AddItem, RemoveItem methods, Controlling FileType with a Custom Form and Procedure

IsHyperlink property, Processing Hyperlinks in an Access Project Form

unbound, on forms<$endrange>, Figure 12.11: Column values containing hyperlink data from the CreateLinksTable procedure.

unbound, on forms<$startrange>, Creating Unbound Combo Boxes on Forms

unbound, on forms\

conditional combo boxes<$endrange>, Figure 12.11: Column values containing hyperlink data from the CreateLinksTable procedure.

conditional combo boxes<$startrange>, Programming Conditional Combo Boxes

event procedures with<$endrange>, Figure 12.9: A combo box that's conditional upon another and opens a second form.

event procedures with<$startrange>, Programming a Combo Box with an Event Procedure

command buttons\

Click events, Navigating with Code Behind Form

Command objects<$endrange>, Updating Values

Command objects<$startrange>, Command and Parameter Objects

Command objects\

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

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

deleting recordsets<$endrange>, Inserting Records

deleting recordsets<$startrange>, Deleting Records

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

inserting recordsets<$startrange>, Inserting Records

properties and methods\

CreateParameter method, Command and Parameter Objects, Creating a Recordset with a Parameter Query

Execute method, Command and Parameter Objects

Prepared property, Command and Parameter Objects

ActiveConnection property, Command and Parameter Objects

CommandText property, Command and Parameter Objects

CommandType property, Command and Parameter Objects

CommandTimeout property, Command and Parameter Objects

updating recordset values<$endrange>, Updating Values

updating recordset values<$startrange>, Updating Values

Command property (views and procedures)\

setting, Adding and Removing Queries

CommandBar objects, Table 8.1: Shared Office Objects

CommandBar objects<$endrange>, Deleting Custom Command Bars

CommandBar objects<$startrange>, CommandBar Object

CommandBar objects\

adding commands to<$endrange>, Figure 8.7: A custom popup menu bar with a combo box control. You click anywhere on the form to open the custom menu bar.

adding commands to<$startrange>, Adding Commands to Built-In Command Bars

custom<$endrange>, Creating Custom Command Bars

custom<$startrange>, Creating Custom Command Bars

custom\

creating as popup<$endrange>, Creating Popup Command Bars

creating as popup<$startrange>, Creating Popup Command Bars

deleting<$endrange>, Deleting Custom Command Bars

deleting<$startrange>, Deleting Custom Command Bars

modifying<$endrange>, Figure 8.7: A custom popup menu bar with a combo box control. You click anywhere on the form to open the custom menu bar.

modifying<$startrange>, Modifying Custom Command Bars

disabling and reenabling<$endrange>, Figure 8.7: A custom popup menu bar with a combo box control. You click anywhere on the form to open the custom menu bar.

disabling and reenabling<$startrange>, Disabling and Reenabling Command Bars and Their Controls

disabling Unhide command<$endrange>, Figure 8.7: A custom popup menu bar with a combo box control. You click anywhere on the form to open the custom menu bar.

disabling Unhide command<$startrange>, Securing an Application by Programming Command Bars

enumerating elements<$endrange>, Listing Visible Command Bars

enumerating elements<$startrange>, Enumerating Command Bar Elements

enumerating elements\

menu commands, Listing Menu Commands

enumerating visible command bars<$endrange>, Figure 8.7: A custom popup menu bar with a combo box control. You click anywhere on the form to open the custom menu bar.

enumerating visible command bars<$startrange>, Listing Visible Command Bars

making visible, Making Invisible Command Bars Visible

CommandBarButton objects<$endrange>, Figure 8.7: A custom popup menu bar with a combo box control. You click anywhere on the form to open the custom menu bar.

CommandBarButton objects<$startrange>, Adding Commands to Built-In Command Bars

CommandBarControl objects, Listing Visible Command Bars

commands, database. <charcntd>See <Default Para Font>Command objects<$nopage>, Creating a Recordset with a Select Query

CommandText property (Command object), Command and Parameter Objects

CommandTimeout property (Command object), Command and Parameter Objects

CommandType property (Command object), Command and Parameter Objects

CommandTypeEnum enumeration, Table 2.1: Intrinsic Constants for the CommandTypeEnum

compiled T-SQL statements. <charcntd>See <Default Para Font>stored procedures<$nopage>, Creating and Using Stored Procedures

complex types, XML, XSD Schemas

ComputeOnGas( ) (example), Running Excel Procedures from an Access Procedure

conditional combo boxes<$endrange>, Figure 12.11: Column values containing hyperlink data from the CreateLinksTable procedure.

conditional combo boxes<$startrange>, Programming Conditional Combo Boxes

conditional form control formatting<$endrange>, Figure 5.17: A form that performs a simple lookup operation.

conditional form control formatting<$startrange>, Conditional Formatting

conditional form control formatting\

event procedures for<$endrange>, Figure 5.17: A form that performs a simple lookup operation.

event procedures for<$startrange>, Formatting with Conditional Formats and Event Procedures

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

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

connecting to databases<$endrange>, The Recordset Object

connecting to databases<$startrange>, The Connection Object

connecting to databases\

Access projects<$endrange>, Opening an Access Project for an Existing Database

Access projects<$startrange>, Opening an Access Project for an Existing Database

Access projects\

<charcntd>See also <Default Para Font>Access projects<$nopage>, Opening an Access Project for an Existing Database

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

browsing objects in<$startrange>, The OpenSchema Method, Sorting Recordsets

Jet databases<$endrange>, Connecting to Jet Databases

Jet databases<$startrange>, Connecting to Jet Databases

non-Jet databases<$endrange>, Connecting to Non-Jet Databases

non-Jet databases<$startrange>, Connecting to Non-Jet Databases

remote data sources, Connecting to Non-Jet Databases

reusing connections, Connecting to Jet Databases

user-level security (ADOX)<$endrange>, Connecting to a Secure Database

user-level security (ADOX)<$startrange>, Connecting to a Secure Database

Connection object\

linking databases<$endrange>, Importing Data from Text Files

linking databases<$startrange>, Linking via the Connection Object

Connection objects<$endrange>, The Recordset Object

Connection objects<$startrange>, The Connection Object

Connection objects\

Jet database connections<$endrange>, Connecting to Jet Databases

Jet database connections<$startrange>, Connecting to Jet Databases

Mode property<$endrange>, Table 1.2: ConnectModeEnum Members

Mode property<$startrange>, The Mode Property

non-Jet database connections<$endrange>, Connecting to Non-Jet Databases

non-Jet database connections<$startrange>, Connecting to Non-Jet Databases

Open method, Connecting to Non-Jet Databases

OpenSchema method<$endrange>, The Recordset Object

OpenSchema method<$startrange>, The OpenSchema Method

OpenSchema method\

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

arranging output<$startrange>, Sorting Recordsets

re-using, Connecting to Jet Databases

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

SQL Server views, creating<$startrange>, Joining Tables for a Lookup

user-level security (ADOX)<$endrange>, Connecting to a Secure Database

user-level security (ADOX)<$startrange>, Connecting to a Secure Database

ConnectModeEnum enumeration, Table 1.2: ConnectModeEnum Members

Connect2OutlookPrintFromFirst( ) (example), Using ISAM Drivers with Outlook

Connect2XLPrintFromFirst( ) (example), Using ISAM Drivers with Excel

constants, intrinsic, The OpenSchema Method

Contacts folder (Microsoft Outlook)\

Access contacts with Outlook messages<$endrange>, Working with Word from Access

Access contacts with Outlook messages<$startrange>, Merging Access Contacts with an Outlook Message

adding and deleting items<$endrange>, Deleting Multiple Items from the Contacts Folder

adding and deleting items<$startrange>, Adding an Item to the Contacts Folder

contents of files, searching<$endrange>, Searching Based on File Contents

contents of files, searching<$startrange>, Searching Based on File Contents

Control Wizards (data access pages), Adding a Drop-Down List Control

ControlName setting (report controls), Programmatically Creating a Report with Controls

Controls collection (CommandBar object), Listing Visible Command Bars

Controls collection (forms), Enumerating Forms and Controls

controls, form. <charcntd>See <Default Para Font>form controls<$nopage>, Chapter 5: Forms, Controls, and Data

controls, report. <charcntd>See <Default Para Font>report controls<$nopage>, Summing Page Values

ControlsInReports( ) (example)<$startrange>, Modifying Report Control Properties

ControlsInReports( ) (example)<$endrange>, Mailing Snapshots

ControlSource property (report controls), Programmatically Creating a Report with Controls

ControlType property (report controls), Modifying Report Control Properties

CONVERT function, Scalar User-Defined Functions

CONVERT function<$endrange>, Figure 11.17: The output from the time conversion sample.

CONVERT function<$startrange>, Converting Dates and Times to Different Formats

converting date and time formats (SQL Sevrer)<$endrange>, Figure 11.17: The output from the time conversion sample.

converting date and time formats (SQL Sevrer)<$startrange>, Converting Dates and Times to Different Formats

CopyFace method (CommandBarControl object), Adding Commands to Built-In Command Bars

CopyFile method (FileSystemObject object)<$endrange>, A Utility for Copying Files Based on FileSystemObject

CopyFile method (FileSystemObject object)<$startrange>, A Utility for Copying Files Based on FileSystemObject

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

copying files with FileSystemObject<$endrange>, A Utility for Copying Files Based on FileSystemObject

copying files with FileSystemObject<$startrange>, A Utility for Copying Files Based on FileSystemObject

copying\

data into tables<$endrange>, Importing Data from Text Files

data into tables<$startrange>, Inserting vs. Copying

data into tables\

from Excel worksheets<$endrange>, Dynamically Creating Access Tables Based on Excel Worksheets

from Excel worksheets<$startrange>, Dynamically Creating Access Tables Based on Excel Worksheets

correlated subqueries, Selecting with Subqueries

COUNT function (SQL), Using Aggregates with GROUP BY and HAVING Clauses

Count property (Controls collection), Programmatically Referencing Main and Subform Controls

Count property\

AllForms collection, Enumerating Forms and Controls

FoundFiles object, Conducting a Basic File Search

CountCommandBars( ) (example), Enumerating Command Bar Elements

CREATE DATABASE statements, Programming an Access Project for a New Database

CREATE FUNCTION statements, Scalar User-Defined Functions

CREATE PROCEDURE statements, The Access UI for Stored Procedures

CREATE statements, permissions for, Managing Permissions

CREATE TABLE statements<$endrange>, Creating a Table with Custom AutoNumber Settings, Figure 11.12: The Properties dialog box for the OrderID column that shows the setting for the Identity,...

CREATE TABLE statements<$startrange>, Creating a Table with Custom AutoNumber Settings, Defining Tables and Inserting Rows

CREATE TABLE statements\

sample tables, creating<$endrange>, Figure 11.14: The three panes for the Access project Query Designer with a view that sorts orders by Freight...

sample tables, creating<$startrange>, Creating Sample Tables

CREATE TRIGGER statements, Creating and Using Triggers from the Access UI

CREATE VIEW statements, Joining Tables for a Lookup

CreateAFormWithPivotTableOnInvoices( ) (example), Constructing a PivotTable for a Query

CreateAndPopulateOrdersTable( ) (example), Creating Sample Tables

CreateAndPopulateShippersTable( ) (example), Figure 11.14: The three panes for the Access project Query Designer with a view that sorts orders by Freight...

CreateAndPopulateShippersTable2( ) (example), Problem and Fix for Manual Trigger Creation

CreateAndShowPopUpMenu( ) (example), Creating Popup Command Bars

CreateAPivotChartBasedOnACustomQuery( ) (example), Adding a PivotChart View to a Custom Form

CreateArchivedShippersTable( ) (example), Archiving Updated and Deleted Records

CreateArchivingTrigger( ) (example), Archiving Updated and Deleted Records

CreateAReportWithASource( ) (example), Programmatically Creating a Report with Controls

CreateASnapShotReport( ) (example), Figure 6.23: An Access chart-based report viewed from Internet Explorer 6.

CreateChart( ) (example)<$endrange>, Adding a PivotChart View to a Custom Form

CreateChart( ) (example)<$startrange>, Adding a PivotChart View to a Custom Form

CreateConditionalFormat( ) (example), Programming Conditional Formats

CreateControl method (Application object)<$endrange>, Constructing a PivotTable for a Query

CreateControl method (Application object)<$startrange>, Constructing a PivotTable for a Query

CreateCustomNamedReport( ) (example), Creating and Saving a Report with a Custom Name

CreateDataAccess Page method, Creating and Deleting Data Access Pages

CreateDBForAccessProject( ) (example), Programming an Access Project for a New Database

CreateDBOnCurrentProjectServer( ) (example), Programming an Access Project for a New Database, Adapting Books Online Code for the SQL Pane

CreateDBPassword( ) (example), Setting a Database Password Programmatically

CreateDBRoleAndGrantSelectPermission( ) (example), Selectively Applying Object Permissions

CreateDefaultNamedReport ( ) (example), Creating and Saving an Unnamed Empty Report

CreateDelete_a_shipperProcedure( ) (example), Updating and Deleting Records from Parameter Values

CreatefrmForCbo( ) (example), Programming a Combo Box with an Event Procedure

CreateInsert_a_new_shipperProcedure( ) (example), Inserting Records from Parameter Values

CreateLinksTable( ), Processing Hyperlinks in an Access Project Form

CreateMyExtensions( ) (example), Defining Tables and Inserting Rows

CreateObject and GetObject functions, Running Excel Procedures from an Access Procedure

CreateObject and GetObject functions<$endrange>, CreateObject vs. GetObject

CreateObject and GetObject functions<$startrange>, CreateObject vs. GetObject

CreateOrders_with_lookup_from_view( ) (example), Joining Tables for a Lookup

CreateParameter method (Command object), Command and Parameter Objects, Creating a Recordset with a Parameter Query

CreateParamQForUpdating( ) (example), An Update Parameter Query

CreatePic_Addresses( ) (example), Defining Tables and Inserting Rows

CreatePic_Addresses( ) (example), Copying a Table's Design from One Database to Another

CreatePivotTableOnInvoices( ) (example)<$startrange>, Constructing a PivotTable for a Query

CreatePivotTableOnInvoices( ) (example)<$endrange>, Figure 7.6: An excerpt from the PivotTable created by the CreateAFormWithPivotTableOnInvoices sample.

CreateRecordset( ) (example), Creating Fields for a Recordset

CreateReport method (Application object)<$endrange>, Figure 6.1: A report created programmatically based on the CreateReport and CreateReportControl...

CreateReport method (Application object)<$startrange>, Creating Reports Programmatically

CreateReportControl method (Application object), Creating Reports Programmatically

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

CreateReportControl method (Application object)<$startrange>, Programmatically Creating a Report with Controls

CreateSum_of_Freight_by_Year( ) (example), Aggregating Records in a View

CreateTableFromXL( ) (example), Dynamically Creating Access Tables Based on Excel Worksheets

CreateTextFile method (FileSystemObject), Persisting Quarterly Totals to a Text File

CreateTimeBasedLineChart( ) (example), Creating a Time-Based Line Chart

CreateTitleViewInCurrentProject( ) (example), Adapting Books Online Code for a VBA Project

CreateUpdate_a_shipperProcedure( ) (example), Updating and Deleting Records from Parameter Values

Criteria argument (OpenSchema), The OpenSchema Method

cross joins, Adding and Removing Queries

Current event (forms), Referencing Subform Fields from a Main Form

CurrentDB objects (DAO), DocumentProperty, CurrentDB, and CurrentProject Objects

CurrentDB objects (DAO)\

custom startup in Access database files<$endrange>, Figure 8.2: The FileSearch object is one of the shared Office objects.

custom startup in Access database files<$startrange>, Building a Custom Startup in an .mdb File

printing<$endrange>, Building a Custom Startup in an .mdb File

printing<$startrange>, Printing the CurrentDB and CurrentProject Properties

CurrentProject objects, Enumerating Forms in Another Project

CurrentProject objects (DAO), DocumentProperty, CurrentDB, and CurrentProject Objects

CurrentProject objects (DAO)\

custom startup in Access projecfts<$endrange>, FileSearch Object

custom startup in Access projecfts<$startrange>, Building a Custom Startup in an .adp File

printing<$endrange>, Building a Custom Startup in an .mdb File

printing<$startrange>, Printing the CurrentDB and CurrentProject Properties

Cursor Service for OLE, Table 1.1: Selected Microsoft-Supplied OLE DB Providers, Finding Records

cursor, recordsets, Connecting to Jet Databases

CursorLocation property (Recordset object), Selected Recordset Properties, Sorting Recordsets

CursorLocation property (Recordset object)\

editability of forms, Assigning an ADO Recordset as the Source, Updating Form Data with an ADO Recordset Assignment

cursors, recordset, Selected Recordset Properties

CursorType property (Recordset object), Connecting to Jet Databases, Selected Recordset Properties

custom roles, Roles

custom startup\

.adp files<$endrange>, FileSearch Object

.adp files<$startrange>, Building a Custom Startup in an .adp File

.mdb files<$endrange>, Figure 8.2: The FileSearch object is one of the shared Office objects.

.mdb files<$startrange>, Building a Custom Startup in an .mdb File

security possibilities, Using a Custom Interface