U

unbound contacts form

building using a disconnected recordset, 142–156

modifying to use SQL, 166–176

sorting records for, 156–157

unbound forms

better than bound, 324

record locking on, 317–318

unhiding the switchboard form, 187

Union statement, 162

unique index number of each array element, 51

updatable, recordsets as, 134

update conflicts, 318

Update method

adding the clsCar class, 112

calling, 120

committing a new empty record to the local disconnected recordset, 144, 152

modifying in clsCar, 114

of the Recordset object, 142

Update statements, 165

Upsizing Wizard, 277–284

URL, decoding, 227

Use Case Diagrams

for the Customer Service application, 462–463

for the Project Tracker application, 334, 335–336

using, 5–7

Use Case Numbers, 5

Use Cases, 5, 8–11

UseOA parameter, 205

user ID, 194

user input, validating, 196–197

user interaction, 195–197

user interface

of an application, 12

building for Project Tracker, 344–357

building for the Customer Service application, 475–480

connecting to code, 410–451, 499–512

determining properties and methods of an object, 102, 103

implementing a basic, 139

separating from the data tables, 318

user interface database, opening exclusively, 323

user interface elements, mapping Use Cases to, 10–11

user interface objects, 344

user-defined data types, 50, 52–53

user-defined functions

described, 275

embedding within a basic SQL statement, 275

user-interface database, 322

user-interface objects, 319

user-level security, 2

users, interacting with controls, 195

UseTrustedConnection parameter, 204