index_S

team lib

S

S \t, Chapter 1: Designing Applications
scalar UDF, SQL Server, User -Defined Functions (UDFs)
schemas, XML \i \rschemas1, Working with Tables
scope, variables \i \rscope1, Variable Scope and Lifetime
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
SQL Server 2000/Desktop, migrating to, System Stored Procedures, 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
 
team lib


Beginning Access 2002 VBA
Beginning Access 2002 VBA (Programmer to Programmer)
ISBN: 0764544020
EAN: 2147483647
Year: 2003
Pages: 256

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net