Flylib.com

Books Software

 
 
 

Beginning Access 2002 VBA (Programmer to Programmer) - page 252

team lib

Index

T

T \t, Chapter 1: Designing Applications

table-type Recordset objects, DAO

RecordCount property \b \rtabletype2, Table-Type Recordsets

table-type Recordset objects, DAO \i \rtabletype1, Table-type Recordset Objects

TableDef objects, DAO

CreateField method, Working with Tables

TableDef objects, DAO \rTableDef1 VBA

TableDef objects , Working with Tables

TableDef objects, DAO \rTableDef2, Working with Tables

TableDef objects, DAO \rTableDef3, Working with Tables

Tabledefs collections, DAO, Working with Tables

Append method, Working with Tables

Tabledefs collections, DAO \i \rTabledefs1 DAO

Database object, The TableDefs Collection

Tabledefs collections, DAO \rTableDefs1, Creating a Library Database

tables

DAO, Working with Tables

linked tables \b \rlinked1, Linked Tables

local tables \b \rlocal1, Differences between Linked and Local Tables

matching records tables \b \rmatching1, Using a Matching Records Table

records \b \rrecords1, Inserting Records

subdatasheets \b \rsubdatasheets1, Sub Datasheets

XML schemas \b \rschemas1, Working with Tables

tables \i \rtables1, Chapter 8: Working with Tables, Table Design, How to Export a Table as XML

TBU (Target Benchmark Users), Jet vs. SQL Server: Why Move?

SQL Server Desktop performance slowdown , Jet vs. SQL Server: Why Move?

technical analysis, Access applications \i \rtechnical1, Technical Analysis

templates, Word, Microsoft Word

Terminate event \rTerminate1, The Class Initialize and Terminate Events

test data \i \rdata1, Creating Test Data

test harnesses \i \rharnesses1, Timing the Code Samples

test tables \i \rtables1, Populating the Test Table

testing, Access applications, Testing

testing, Access applications \i \rtesting1, Testing

text files

CSV files, Specifications

CSV files \b \rCSV1, Text Files

CSV files \b \rCSV2, Specifications

Export Text wizard, Specifications

fixed width files, Specifications

fixed width files \b \rfixed1, Text Files

fixed width files \b \rfixed2, Specifications

specifications \b \rspecifications1, Specifications

text files \i \rtext1, Text Files

TextToDisplay property, Hyperlink type, Hyperlinks in VBA

Then keyword (see If statements) \t, If...Then...

Time function, Other Useful Date and Time Fuctions

timeGetTime function \rtimeGetTime1, Declaring a DLL in Code

Timer function, Timing the Code Samples

Timer function \rTimer1, Timing the Code Samples

times \i \rtimes1, Times

timestamps

SQL Server migration, Upsizing Wizard, Running the Upsizing Wizard

TLAs (three letter acronyms) \rTLAs1, DAO vs ADO

TOP command, SQL

as ORDER BY alternative, views, Views

TransferDatabase method, DoCmd object \rTransferDatabase1, Databases

TransferSpreadsheet method, DoCmd object \rTransferSpreadsheet1, Spreadsheets

TransferText method, DoCmd object, Specifications

TransferText method, DoCmd object \rTransferText1, Text Files

TRANSFORM syntax

T-SQL not supporting, qryxSS

type conversion \i \rconversion1, Type Conversion

TypeName function \i \rTypeName1, The TypeName() Function

types

optimization \b \rtypes1, Use the Right Data Type

structures \b \rstructures1, User-defined Data Types

types \i \rtypes1, Variable Types

 

team lib

team lib

Index

U

U \t, Chapter 1: Designing Applications

UDA (Universal Data Access) \i \rUDA1, Universal Data Access

UDF (user-defined functions), SQL Server, What's New in your Database?, User -Defined Functions (UDFs)

@@ system functions, listing, User-Defined Functions (UDFs)

Access/SQL Server built-in, listing, User-Defined Functions (UDFs)

deterministic/ non-deterministic , User-Defined Functions (UDFs)

multi-line, Multi-Line User-Defined Functions

scalar/in-line, User-Defined Functions (UDFs)

underscores, Parameters or Arguments

Unique property, DAO Index objects, Working with Tables

Unique Records property, queries, Microsoft Outlook

Universal Data Access (UDA) \i \rUDA1, Universal Data Access

Until keyword (see Do loops ) \t, Do...Loop

Updatable property, DAO Recordset objects \rUpdatable1, When a Recordset Can't be Updated

Update method, ADO Recordset objects \rUpdate1, Inserting Records

Update method, ADO Recordset objects \rUpdate2, Try It Out-Updating Records using ADO

Update method, DAO Recordset objects, Editing Records in Recordsets

UpdateBatch method, ADO Recordset objects \i \rUpdateBatch1, Disconnected Recordsets

Upsizing Pro tool, Running the Upsizing Wizard

Upsizing Wizard, running pre-requisites, Running the Upsizing Wizard

Upsizing Wizard, Access, Running the Upsizing Wizard

running, pre-requisites, Running the Upsizing Wizard

SQL Server 2000/Desktop, migrating to, Running the Upsizing Wizard

upsizing database, example, Results of Upsizing the IceCream Database

upsizing database, steps, Running the Upsizing Wizard

URLs \i \rURLs1, The Internet

usability testing \i \rusability1, Testing

user defined errors \i \ruser1, User Defined Errors

user defined types \i \ruser1, User-defined Data Types

user interfaces \i \ruser1, Adding to the User Interface

user requirements analysis \i, The Challenge - Flexibility vs. Manageability

user-defined functions, SQL Server, see UDF\t, User-Defined Functions (UDFs)

users, SQL Server security, Users

creating/adding to database, login example, Try It Out-Create the Whole Works

User32.dll file, Dynamic Link Libraries (DLLs), Declaring a DLL in Code

 

team lib