Index

U

UNC notation, Saving a Data Access Page

underscore (_) as query wildcard, Writing Criteria Expressions with Wildcards

UnhideAForm( ) (example), Enumerating Forms in Another Project

Uniform Naming Convention (UNC), Saving a Data Access Page

uniform resource locators (URLs), Recordsets, Records, Streams, and the Web

UNION keyword, SELECT statement<$endrange>, Selecting with Unions

UNION keyword, SELECT statement<$startrange>, Selecting with Unions

union queries<$endrange>, Selecting with Unions

union queries<$startrange>, Selecting with Unions

Unique property (Index object), The Index Object

Unique-identifier data type (SQL server), Table 11.3: SQL Server Column Data Types

Update method (Recordset object), Working with Values from Excel Worksheets

UPDATE statements (SQL)\

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

parameter queries<$startrange>, An Update Parameter Query

UPDATE statements\

object permissions, Managing Permissions

UpdateAFieldValue( ) (example), Editing a Row

UpdateAShipper( ) (example), Updating and Deleting Records from Parameter Values

UpdateBatch method (Recordset object)<$endrange>, Persisting Recordsets

UpdateBatch method (Recordset object)<$startrange>, Persisting Recordsets

UpdateRule property (Key object), The Key Object

UpdateTimeBasedLineChart( ) (example), Creating a 3-D Line Chart

updating databases\

controlling recordset manipulation, Selected Recordset Properties

updating form data\

ADO recordsets as source<$endrange>, Processing Main/Subforms

ADO recordsets as source<$startrange>, Updating Form Data with an ADO Recordset Assignment

updating recordset values<$endrange>, Updating Values

updating recordset values<$startrange>, Updating Values

updating recordset values\

stored procedures for<$endrange>, Creating and Using Triggers from the Access UI

stored procedures for<$startrange>, Inserting, Updating, and Deleting Records

updating recordsets\

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

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

updating reports dynamically<$endrange>, Mailing Snapshots

updating reports dynamically<$startrange>, Dynamically Updating Reports

updating\

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

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

remote data with ISAM applications, Working with Values from Excel Worksheets

URLs (uniform resource locators), Recordsets, Records, Streams, and the Web

user accounts<$endrange>, Login and User Accounts, Creating Login and User Accounts with T-SQL

user accounts<$startrange>, Login and User Accounts, Programming Login and User Accounts

user accounts\

<charcntd>See also<Default Para Font>permissions<$nopage>, Roles

<charcntd>See also<Default Para Font>roles<$nopage>, Roles

creating with SQL-DMO<$startrange>, Creating Login and User Accounts with SQL-DMO

creating with T-SQL<$endrange>, Creating Login and User Accounts