Screen object

ActiveControl property, Special Objects

ActiveDataAccessPage property, Special Objects

ActiveForm property, Special Objects

ActiveForm property \rActiveForm1, Special Objects

ActiveReport property, Special Objects, Filters

PreviousControl property, Special Objects

ScreenTip property, Hyperlink type, Hyperlinks in VBA

security, SQL Server, A Note on Security

database roles, Database Roles

logins/users/roles, Logins

Windows/mixed authentication, using, Roles

Seek method, ADO Recordset objects \i \rSeek1, Seek

Seek method, DAO Recordset objects, Finding Records in Dynasets and Snapshots, The Language Converter Add-In

Seek method, DAO Recordset objects \i \rSeek1, Finding Records in Table-Type Recordsets

Seek method, DAO Recordset objects \i \rSeek3, When to Use Find and Seek

Seek method, DAO Recordset objects \rSeek1, The Language Converter Add-In

Seek method, DAO Recordset objects \rSeek2, Try It Out-Allowing for No Matches, The Language Converter Add-In

Select Case statements

Case Else clauses \rElse2, Select Case

Select Case statements \i \rSelect1, Select Case

SELECT statements, SQL, Working with SQL, Connection

FROM clause, Working with SQL

FROM clause \rFROM1 Select statement, Working with SQL

INTO clause \rINTO1, Using a Matching Records Table

WHERE clause, SQL

WHERE clause \rWHERE1, Working with SQL

WHERE clause \rWHERE2, Working with SQL

WHERE clause \rWHERE3, Working with SQL

SELECT statements, SQL \rSELECT1 Select statement

SQL , Working with SQL

Selection object, Word \rSelection1, Microsoft Word

semantic errors \i, What if I Still Get it Wrong?

semantic errors \i \rsemantic1, Semantic (or logic) Errors

SendObject method, Application object \rSendObject1, Electronic Mail

servers (see web servers) \t, The Internet

Set methods \i, Avoid Get and Set Methods

Set statements \rSet1, Object

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

Show button, Hovering

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

Single type \i \rSingle1, Double and Single

sites (see web sites) \t, The Internet

snapshot-type Recordset objects, DAO, Use Appropriate Recordset Types

RecordCount property \rsnapshottype2, Dynasets and Snapshots

snapshot-type Recordset objects, DAO \i \rsnapshottype1, Snapshot-type Recordset Objects

snapshot-type Recordset objects, DAO \rsnapshottype3, When a Recordset Can't be Updated

Source property, Err objects, The Err Object, Data-Access Objects, The Error Stack

specifications, text files \i \rspecifications1, Specifications

speed (see execution speed) \t, Increasing Execution Speed

splash screens \i \rsplash1, Startup Forms and Splash Screens

spreadsheets

Excel \b \rExcel1, Microsoft Excel

spreadsheets \i \rspreadsheets1, Spreadsheets

SQL

Query Designer \rDesigner1, Why Not Use Parameterized Queries?

query strings, Why Not Use Parameterized Queries?

SELECT statements, Working with SQL, Connection

SELECT statements \rSELECT1 Select statement, Working with SQL

SQL \i \rSQL1, Working with SQL

SQL \rSQL1, When to Use Find and Seek

SQL property, DAO QueryDef objects, Creating and Modifying DAO QueryDefs, Using a Matching Records Table

SQL Server 2000/Desktop, migrating to, Chapter 20: Moving to Client-Server

ADP (Access Data Projects), using, What is an Access Data Project (ADP)?

advantages, Advantages of SQL Server

as client server-based database, What is Client-Server?

database objects, What's New in your Database?, Views, User-Defined Functions (UDFs), Stored Procedures

defining both, Jet vs. SQL Server: Why Move?

disadvantages, Disadvantages of SQL Server

failed upsized queries, repairing, Fixing the Queries, qryxSS, qrySalesSummary

FileName.ldf/mdf database files, Database Files

forms, Forms

installing SQL Server Desktop engine, Installing SQL Server Desktop Engine

security, A Note on Security, Logins, Database Roles

SQL Server Desktop limitations, Jet vs. SQL Server: Why Move?

SQLDMO & system stored procedures, using, SQLDMO

Upsizing Wizard, using, Running the Upsizing Wizard

SQLDMO (SQL Distributed Management Objects), SQLDMO

SQL Server 2000/Desktop, migrating to, SQLDMO, System Management, Try It Out-Connecting to SQL Server and Displaying the Available Databases, Try It Out-Executing a System Stored Procedure, Try It Out-Listing Columns and Tables

standard modules \i \rstandard1, Standard Modules

start-up forms \i \rstartup1, Using a Start-Up Form

State property, ADO Command objects, Command Properties

State property, ADO Command objects \i \rState1, State

static arrays

bounds \b \rbounds1, Upper and Lower Bounds

Erase statements \rstatic1, Erasing Arrays

static arrays \i \rstatic1, Static Arrays

Static keyword, Variable Scope and Lifetime

Static keyword \rStatic3, Static Variables

Static keyword \rStatic4, Static Variables

static variables \i \rstatic1, Variable Scope and Lifetime

static variables \i \rstatic2, Static Variables

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 \i \rStop1, The Stop Statement

Stop statements \rStop1, Working with Recordsets

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

ADP example building, What is an Access Data Project (ADP)?

creating using Query Builder, The Query Builder, Stored Procedure Tab, Stored Procedure Parameters Tab, Data Tab

creating, example, Try It Out-Creating a Stored Procedure

crosstab queries, replacing, qryxSS

definition, What is a Stored Procedure?

form tables, replacing, frmIceCreamPopup

Format queries, replacing, qrySalesSummary

parameters, handling, Try It Out-Creating a Stored Procedure

report, replacing, qrySalesSummary

system stored procedures, System Stored Procedures

String type, Variable Types, Use the Right Data Type

String type \i \rString1, String

strings

fixed length strings, Use the Right Data Type

fixed length strings \b, Passing Strings

null terminated strings \b \rnull1, Passing Strings

strings \i \rstrings1, Passing Strings

structures \i \rstructures1, User-defined Data Types

Sub keyword \rSub1, Subroutines and Functions

SubAddress property, Hyperlink type, Hyperlinks in VBA

subclasses, Inheritance

subclasses \i, Inheritance

subdatasheets

Insert Subdatasheet dialog, Sub Datasheets

subdatasheets \i \rsubdatasheets1, Sub Datasheets

subroutines (see also procedures) \i \rsubroutines1, Subroutines and Functions

summarizing \i \rsummarizing1, Summarizing

support

customer support, Customer Support

e-mail support, E-mail Support

switchboards \i \rswitchboards1, Changing the Switchboard

syntax errors \i \rsyntax1, Syntax Errors

system functions, SQL Server, see @@\t, User-Defined Functions (UDFs)

system stored procedures, SQL Server, System Stored Procedures

security/system management procedures, listing, System Stored Procedures