index_C

C

C \t, Chapter 1: Designing Applications

caches \i \rcaches1, Cache Data Locally

Call Stack button, Hovering

Call Stack button \i \rStack1, The Call Stack

Cancel method, ADO Command objects, Command Methods

CancelUpdate method, DAO Recordset objects, Editing Records in Recordsets

Caption property, buttons, Try It Out-Adding Simple Navigation Buttons to a Form, The Finished Product

Case Else clauses \rElse2, Select Case

Case keyword (see Select Case statements) \t, Select Case

CASE statement, SQL, qryxSS

failed upsized queries, repairing, qryxSS

charts , Excel \i \rcharts1, Microsoft Excel

class inheritance \i, Inheritance

class libraries, Class Libraries

class libraries \i \rclass1, Class Libraries

class modules \i \rclass2, Forms as Class Modules

class modules \i \rclass3, Getting the Most from Class Modules

class modules \i \rmodules2, Form and Report Modules

class modules \rclass1, Differences between Classes and Modules

class modules \rclass2, An ADO Class Library

classes

instances, Differences between Classes and Modules

instances \b, What Are Objects?

subclasses, Inheritance

subclasses \b, Inheritance

classes \i \rclasses1, Classes, Chapter 13: Using Classes

Clear method, Err objects, The Err Object

Click event, buttons, Try It Out-Adding Simple Navigation Buttons to a Form

client servers, What is Client-Server?

file-based databases and, What is Client-Server?

SQL Server 2000/Desktop, migrating to, What is Client-Server?

ClipCursor function \rClipCursor1, User-defined Data Types

ClipCursor function \rClipCursor2, Null Pointers

Close event, reports , Filters

Close event, reports \i \rClose1, Close

Close event, reports \rClose2, Filters

Code Commenter and Error Handler Add-In \i \rAddIn1, Using the Code Commenter and Error Handler Add-In

Code window

object listbox \b \robject1, Code Window

procedure listbox \b \rprocedure1, Code Window

Code window \i \rCode1, Code Window

collections \i \rcollections1, Collections - Creating a Hierarchy

Color Schemes add-in (example) \i \rColor1, The Color Schemes Add-In

Column Headings property, queries, Microsoft Excel

combo boxes

AfterUpdate event \rAfterUpdate1, The Simple Combo Class

combo boxes \i \rcombo1, The Simple Combo Class

comma separated values files (see CSV files) \t, Text Files

Command objects, ADO

ActiveConnection property, Command Properties

ActiveConnection property \b, ActiveConnection

Cancel method, Command Methods

CommandText property, Command Properties, Try It Out-Working with a Command

CommandText property \b, CommandText

CommandTimeout property, Command Properties

CommandTimeout property \b \rCommandTimeout1, CommandTimeout

CommandType property, Command Properties

CommandType property \b \rCommandType1, CommandType Property

CreateParameter method, Command Methods

CreateParameter method \b \rCreateParameter1, CreateParameter

CreateParameter method \b \rCreateParameter2, Try It Out-Using CreateParameter

Execute method, Try It Out-Working with a Command, Command Methods

Execute method \b \rExecute1, Execute

Execute method \b \rExecute2, Execute

Name property, Command Properties

Name property \b \rName1, Name

Prepared property, Command Properties

Prepared property \b \rPrepared1, Prepared

State property, Command Properties

State property \b \rState1, State

Command objects, ADO \i \rCommand1, Command

CommandText property, ADO Command objects, Command Properties, Try It Out-Working with a Command

CommandText property, ADO Command objects \i, CommandText

CommandTimeout property, ADO Command objects, Command Properties

CommandTimeout property, ADO Command objects \i \rCommandTimeout1, CommandTimeout

CommandType property, ADO Command objects, Command Properties

CommandType property, ADO Command objects \i \rCommandType1, CommandType Property

comments

Access-SQL Server, comparing, What's New in your Database?

comments \i \rcomments1, Comments

comments \i \rcomments2, Commenting Out Lines

Compact on Close option, databases, Compact the Database

Compact on Close option, databases \rCompact1, Other Considerations

CompactDatabase method, DAO DBEngine object \rCompactDatabase1, Compact the Database

comparison operators \rcomparison1, Operator Precedence

compile errors \i \rcompile1, Compile Errors

compiling \i \rcompiling1, Compiling Code, Compiling

conditional formatting, reports \i \rconditional1, Conditional Formatting

connection files, DAPs \i \rconnection1, DAP Connection Files

Connection objects, ADO \i \rConnection1, Connection

Const statements \rConst1, Constants

constants

intrinsic constants \b \rintrinsic1, Intrinsic Constants

naming conventions \b \rconstants1, Naming Conventions for Constants

constants \i \rconstants1, Use Constants

constants \i \rconstants2, Constants

Continue button \i, Continuing Execution

controls

ControlType property, Control Types

Enabled property \rEnabled1, Adding Intelligent Navigation Buttons to the Company Contacts Form

Hyperlink property \rHyperlink1, Try It Out-Editing Hyperlinks

naming conventions \b \rcontrols1, Naming Conventions for Controls

Requery method \b \rRequery1 Requery method, Use the Requery Method, not the Requery Action

SetFocus method \rSetFocus1, Adding Intelligent Navigation Buttons to the Company Contacts Form

controls \i \rcontrols2, Forms and Reports

Controls collections \rControls1, Forms and Reports

ControlType property, controls, Control Types

ConvertAccessProject method, Application object, New Object Properties & Methods

CREATE TABLE statements, SQL \rCREATE1, Creating a Library Database

CreateField method, DAO TableDef objects, Working with Tables

CreateNewDocument method, Hyperlink type, Hyperlinks in VBA

CreateParameter method, ADO Command objects, Command Methods

CreateParameter method, ADO Command objects \i \rCreateParameter1, CreateParameter

CreateParameter method, ADO Command objects \i \rCreateParameter2, Try It Out-Using CreateParameter

CreateProperty method, DAO, Custom DAO Properties

CreateQueryDef method, DAO Database objects, Creating and Modifying DAO QueryDefs

CreateTableDef method, DAO Database objects, Working with Tables

criteria forms \i \rcriteria1, Building a Query by Form Interface

crosstab queries, Microsoft Excel

SQL Server not supporting, qryxSS

CSV (comma separated values) files, Specifications

CSV (comma separated values) files \i \rCSV1, Text Files

CSV (comma separated values) files \i \rCSV2, Specifications

currency \i \rcurrency1, Notes on Formatting Dates and Currency Amounts in VBA

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

Currency type \i \rCurrency1, Currency

cursor types, ADO recordsets \i \rcursor1, Cursor Type

custom methods, forms \i \rmethods1, Custom Form Methods

custom properties, DAO \i \rcustom1, Custom DAO Properties

custom properties, forms \i \rproperties3, Creating Custom Properties for Forms

customer support, Customer Support