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

A

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

Access projects<$endrange>, Installing and Using MSDE 2000

Access projects<$startrange>, Access Projects and SQL Server Versions

Access projects\

<charcntd>See also <Default Para Font>SQL Server<$nopage>, Access Projects and SQL Server Versions

additional educational resources<$endrange>, Working with the Pubs Database

additional educational resources<$startrange>, Books Online and Other SQL Server Learning Resources

architecture of<$endrange>, Access Project Architecture

architecture of<$startrange>, Access Project Architecture

creating and opening<$endrange>, Adapting Books Online Code for the SQL Pane

creating and opening<$startrange>, Creating and Opening Access Projects

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

form server filters, programming<$startrange>, Programming Form Server Filters

hyperlink processing<$endrange>, Processing Hyperlinks in an Access Project Form

hyperlink processing<$startrange>, Processing Hyperlinks in an Access Project Form

opening for .mdf files, Opening an Access Project for an .mdf File

Query Designer, launching, Using the Access Project Query Designer

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

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

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

reports programming\

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

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

supported SQL Server databases, Supported SQL Server Databases

Access 11 security innovations<$startrange>, Access 2003 Security Innovations

Access 2003 security innovations<$endrange>, What Are Digital Signatures and How Do I Use Them?

Access 2003 security innovations\

Jet SandBox<$endrange>, How Do You Disable and Enable the Jet SandBox?

Jet SandBox<$startrange>, Jet SandBox

macro security<$endrange>, What Are Digital Signatures and How Do I Use Them?

macro security<$startrange>, Macro Security

access\

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

recordset mode settings<$startrange>, The Mode Property

AccessObject object, Using the AllTables Collection

AccessObject object\

tables, detecting when open, Detecting When Tables Are Open

AccessObjectProperty objects, Printing the CurrentDB and CurrentProject Properties

accounts, login. <charcntd>See <Default Para Font>login accounts<$nopage>, Programming Login and User Accounts

accounts, user. <charcntd>See <Default Para Font>user accounts<$nopage>, Programming Login and User Accounts

action queries<$endrange>, Creating a Table with Custom AutoNumber Settings

action queries<$startrange>, Creating and Running Action Queries with ADOX

action queries\

delete parameter queries<$endrange>, Creating a Table with Custom AutoNumber Settings

delete parameter queries<$startrange>, A Delete Parameter Query

insert parameter queries<$endrange>, An Insert Parameter Query

insert parameter queries<$startrange>, An Insert Parameter Query

update parameter queries<$endrange>, Creating a Table with Custom AutoNumber Settings

update parameter queries<$startrange>, An Update Parameter Query

Activate event (reports), Making Reports Dynamic

ActiveConnection property (Catalog object), The Catalog Object

ActiveConnection property (Catalog object)\

listing tables of, Listing All Table Types in a Catalog

ActiveConnection property (Command object), Command and Parameter Objects

ActiveConnection property (Recordset object), Selected Recordset Properties

ActiveView property (PivotTables), Adding and Removing PivotTable Totals

ActiveWorkbook objects, Running Excel Procedures from an Access Procedure

ActiveX Data Objects. <charcntd>See <Default Para Font>ADO<$nopage>, Chapter 1: Data Access Models: Part I

ActualSize property (Field object), The Field Object

Add method\

CommandBar object<$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.

CommandBar object<$startrange>, Adding Commands to Built-In Command Bars

Controls collection (command bars), Adding Commands to Built-In Command Bars

FormatConditions collection, Programming Conditional Formats

PropertyTests collection, Specifying Multiple Search Criteria

ADD statements, Jet SQL Statements and Keywords for User-Level Security

AddAShipper( ) (example), Adding a Row

AddAView( ) (example), Adding and Removing Queries

AddCbrBtns(  ) (example), 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.

AddContacts(  ) (example), Adding Multiple Items to the Contacts Folder

AddFooRecord(  ) (example), An Update Parameter Query

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

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

AddLoginAndUserToDBRole(  )  (example), Creating Login and User Accounts with SQL-DMO

AddNew method (Recordset object), Selected Recordset Methods, Adding a Row, Working with Values from Excel Worksheets

AddNewUser2(  ) (example), Figure 10.8:     Output to the Immediate window from the AssignUpdatePermissionsToNewUser2 procedure.

AddOneContact(  ) (example), Adding an Item to the Contacts Folder

AddOpenNorthwindLink(  ) (example), Empowering Users to Create and Open Files from the Task Pane

AddParamQuery( ) (example), A Delete Parameter Query

AddRemoveSQLUsers( ) (example)<$endrange>, Creating Login and User Accounts with T-SQL

AddRemoveSQLUsers( ) (example)<$startrange>, Creating Login and User Accounts with T-SQL

AddShowAssistantsAndRocky(  ) (example), 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.

AddSQLServerAuthentication(  )  (example), Setting Mixed Authentication

AddTotal method (PivotTables)<$endrange>, Adding Totals Fields

AddTotal method (PivotTables)<$startrange>, Adding and Removing PivotTable Totals

Admin user account, What Is User-Level Security?, Step 1 Create Workgroup and Administrator and Force Logon

Administrator account, Login and User Accounts

ADO (ActiveX Data Objects)<$endrange>, Summary

ADO (ActiveX Data Objects)<$startrange>, Chapter 1: Data Access Models: Part I

ADO (ActiveX Data Objects)\

columns in database tables.<charcntd>See <Default Para Font>Field objects<$nopage>, Chapter 2: Data Access Models: Part II

command parameters<charcntd>See <Default Para Font>Parameter objects<$nopage>, Chapter 2: Data Access Models: Part II

commands<charcntd>See <Default Para Font>Command objects<$nopage>, Chapter 2: Data Access Models: Part II

data streams. <charcntd>See <Default Para Font>Stream objects<$nopage>, Chapter 2: Data Access Models: Part II

database connections. <charcntd>See <Default Para Font>Connection objects<$nopage>, Chapter 2: Data Access Models: Part II

JRO library, ADO Components for Microsoft Access Developers

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

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

OLE DB providers<$endrange>, OLE DB Providers and ADO Object Model Summary

OLE DB providers<$startrange>, OLE DB Providers and ADO Object Model Summary

recordsets. <charcntd>See <Default Para Font>Recordset objects<$nopage>, Chapter 2: Data Access Models: Part II

rows in database tables. <charcntd>See <Default Para Font>Record objects<$nopage>, Chapter 2: Data Access Models: Part II

trapping errors. <charcntd>See <Default Para Font>Error objects<$nopage>, Chapter 2: Data Access Models: Part II

trapping errors. <charcntd>See <Default Para Font>Errors collection<$nopage>, Chapter 2: Data Access Models: Part II

user-level security<$endrange>, Figure 10.9:     Form1 from Chapter10.mdb illustrates operational features of the Jet SandBox.

user-level security<$startrange>, User-Level Security via Jet SQL and ADO

ADODB library<$endrange>, ADO Components for Microsoft Access Developers

ADODB library<$startrange>, ADO Components for Microsoft Access Developers

ADOX library, ADO Components for Microsoft Access Developers

ADOX library<$endrange>, Summary

ADOX library<$startrange>, Chapter 3: The ADOX Library and Tables

ADOX library\

action queries, creating and running<$endrange>, Creating a Table with Custom AutoNumber Settings

action queries, creating and running<$startrange>, Creating and Running Action Queries with ADOX

action queries, creating and running\

adding and deleting users<$endrange>, Adding and Deleting Users

adding and deleting users<$startrange>, Adding and Deleting Users

assigning groups to users<$endrange>, Assigning Groups to Users

assigning groups to users<$startrange>, Assigning Groups to Users

connecting to secure databases<$endrange>, Connecting to a Secure Database

connecting to secure databases<$startrange>, Connecting to a Secure Database

delete parameter queries<$endrange>, Creating a Table with Custom AutoNumber Settings

full example of<$endrange>, Jet SQL Statements and Keywords for User-Level Security

full example of<$startrange>, Putting It All Together

groups, managing in catalogs<$endrange>, Creating, Deleting, and Tracking Groups in a Catalog

groups, managing in catalogs<$startrange>, Creating, Deleting, and Tracking Groups in a Catalog

setting permissions<$endrange>, Setting Permissions

setting permissions<$startrange>, Setting Permissions

update parameter queries<$endrange>, Creating a Table with Custom AutoNumber Settings

update parameter queries<$startrange>, An Update Parameter Query

AllTables collection<$endrange>, Importing Data from Text Files

AllTables collection<$startrange>, Using the AllTables Collection

creating databases, Creating a New Database

enumerating tables<$endrange>, Printing Data for the Table Details View

enumerating tables<$startrange>, Enumerating Tables

enumerating tables\

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

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

delete parameter queries<$startrange>, A Delete Parameter Query

insert parameter queries<$endrange>, An Insert Parameter Query

insert parameter queries<$startrange>, An Insert Parameter Query

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

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

printing for Tables Details view, Printing Data for the Table Details View

filtering table types, Filtering Table Types Before Enumerating

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

managing row-returning queries\

object model<$endrange>, The Key Object

object model<$startrange>, Overview of the ADOX Model

populating tables<$startrange>, Populating Tables with Data

user-level security<$endrange>, Jet SQL Statements and Keywords for User-Level Security

user-level security<$startrange>, User-Level Security via ADOX

user-level security\

advanced file search<$endrange>, Figure 8.5:     The Access11Files Properties dialog box with the settings to implement read-only Simple File Sharing with Windows...

advanced file search<$startrange>, Specifying Multiple Search Criteria

AFTER triggers, Triggers

aggregated fields<$endrange>, Right Outer Joins

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

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

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

ALL keyword, SELECT statement, Table 4.2: Jet SQL SELECT Keyword Predicates

AllDataAccessPages collection<$endrange>, Figure 14.18:     Automatically generated data access pages can have the same look and feel as Access forms.

AllDataAccessPages collection<$startrange>, Enumerating Data Access Pages and Their Properties

AllForms collction (CurrentProject objects)\

enumerating forms and controls<$endrange>, Enumerating Forms and Controls, Enumerating Forms in Another Project

enumerating forms and controls<$startrange>, Enumerating Forms and Controls, Enumerating Forms in Another Project

hiding and showing forms<$endrange>, Hiding and Showing Forms

hiding and showing forms<$startrange>, Hiding and Showing Forms

AllowBypassKey property (CurrentDB object), Printing the CurrentDB and CurrentProject Properties, Building a Custom Startup in an .mdb File

AllowSpecialKeys property (CurrentDB object), Building a Custom Startup in an .mdb File

AllReports collection, Programmatically Creating a Report with Controls, Manipulating Reports and Report Controls

AllReports collection\

naming new reports, Creating and Saving a Report with a Custom Name

AllTables collection<$endrange>, Importing Data from Text Files

AllTables collection<$startrange>, Using the AllTables Collection

AllTables collection\

detecting when tables are open, Detecting When Tables Are Open

ALTER COLUMN statements<$endrange>, Figure 4.6:     Output from the CallAndDemoResetCounter procedure that confirms programmatic changes to...

ALTER COLUMN statements<$startrange>, Changing AutoNumber Settings

ALTER DATABASE PASSWORD statements<$endrange>, Figure 10.1:     You use the Protection tab of the Project Properties dialog box to set password security for the modules in...

ALTER DATABASE PASSWORD statements<$startrange>, Setting a Database Password Programmatically

ALTER FUNCTION statements, Scalar User-Defined Functions

ALTER PROCEDURE statements, The Access UI for Stored Procedures

ALTER TABLE statements, Changing AutoNumber Settings

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

AndCopyNorthwindLink(  ) (example), Empowering Users to Create and Open Files from the Task Pane

AnswerWizard objects, Table 8.1: Shared Office Objects

Append method (Fields collection)<$endrange>, Figure 1.9:     An excerpt from the report.txt file showing grouping and aggregation by quarter.

Append method (Fields collection)<$startrange>, Creating Fields for a Recordset

Append method (Views collection), Adding and Removing Queries

Append method\

Groups collection, Assigning Groups to Users

Users collection, Adding and Deleting Users

AppendChunk method (Field object), The Field Object

application roles, Roles

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

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

Array function, The OpenSchema Method

AS keyword (T-SQL), Using the LIKE Operator with datetime Column Values

ASP (Active Server Pages), Active Server Pages

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

AssignFreightSortOrder(  ) (example), Sorting Result Sets

assigning users to groups<$endrange>, Assigning Groups to Users

assigning users to groups<$startrange>, Assigning Groups to Users

AssignNewPassword( ) (example), Setting Mixed Authentication

AssignUpdatePermissionsToNewUser2( ) (example), Granting and Revoking Permissions

Assistant objects, Table 8.1: Shared Office Objects

AttachADB(  )  (example), Setting Up the SQL Server Security Demonstrations

AttachDataFiles(  )  (example), Setting Up the SQL Server Security Demonstrations

attaching database files (SQL servers)<$endrange>, Attaching and Detaching Multiple Files

attaching database files (SQL servers)<$startrange>, Attaching and Detaching Database Files

Attributes property (Column object), The Column Object

Attributes property (Field object), The Field Object

attributes, XML, XML Document Syntax

authentication<$endrange>, Roles

authentication<$startrange>, Authentication

authentication\

ensuring secure login<$startrange>, Ensuring Secure Login and Enumerating Databases

ensuring  secure  login<$endrange>, Setting Mixed Authentication

mixed authentication, setting<$startrange>, Setting Mixed Authentication

mixed  authentication,  setting<$endrange>, Figure 13.3:     An Access form that lets a user browse selected database objects on the local SQL server.

SQL Server, Connecting to Non-Jet Databases

AutoForm Wizard, Creating a Simple Bound Form

AutoForm Wizard\

forms based on one-click tables<$endrange>, Another Main/Subform Example

forms based on one-click tables<$startrange>, Creating a Form Based on a Table with One Click

referencing subform fields from main forms<$endrange>, Showing Images Based on Image Addresses

referencing subform fields from main forms<$startrange>, Referencing Subform Fields from a Main Form

showing images based on image addresses<$endrange>, Showing Images Based on Image Addresses

showing images based on image addresses<$startrange>, Showing Images Based on Image Addresses

AutoIncrement property (Table object), The Table Object

Automation, Automation, Closing an Automation Reference

Automation\

Microsoft Word with<$endrange>, Automating Word from Access

Microsoft Word with<$startrange>, Automating Word from Access

AutoNumber settings\

changing<$endrange>, Figure 4.6:     Output from the CallAndDemoResetCounter procedure that confirms programmatic changes to...

changing<$startrange>, Changing AutoNumber Settings

custom<$endrange>, Creating a Table with Custom AutoNumber Settings

custom<$startrange>, Creating a Table with Custom AutoNumber Settings

AutoReport Tabular wizard, Creating Reports

AutoReport wizard, Creating Reports

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