Microsoft Access 2010 Bible

1337

Index

unique identifiers, 20–21. See also foreign keys; primary

keys.

Unique property problems, 1179

Unique Records property, 651

Unique Values property, 651

unknown input data. See data validation rules.

Unload event, 457

unsupported report controls, 1176

untrapped errors, 823

update anomalies, 99, 103

Update method, 512

Update Query action queries, 671, 672–673

Update Retry Interval option, 768

Updated event, 460

updating

fields with data macros, 561

records with action queries, 672–673

updating tables

adding fields, 41

deleting records, 41

renaming fields, 41

updating tables, with VBA code

adding records, 517

ADO (ActiveX Data Objects), 509–513

AfterEventUpdate event procedure, 509–513

deleting records, 517–521

Upsizing Wizard

ADP objects, versus Access objects, 1233–1235

ADPs (Access Data Projects), 1223

conversion issues, 1239

data types, Access versus SQL Server, 1235–1240

field names, 1239

form conversions, 1234

linked tables, 1235

macro conversions, 1234

module conversions, 1234

query conversions, 1234

referential integrity errors, 1231

report conversions, 1234

reports, 1232–1233

ribbon conversions, 1234

running, 1226–1233

upsizing, prerequisites, 1226

usage logs, 920–923

Use Access Special Keys check box, 1084, 1087

Use Control Wizard button, 266

Use Default Paper Size property, 311

Use Transaction property, 653

memory errors, 920

usage logs, 920–923

virtual memory, 920

troubleshooting, record-lock errors

bound forms versus unbound, 780–788

caching, 768–769

Error 3186: Couldn’t save..., 772–774

Error 3188: Could not update..., 774–775

Error 3197: Data has changed..., 775–778

Error 3260: Couldn’t update..., 769–772

ErrorRoutine function, 778–780

latency, 768–769

overview, 768–769

true/false criteria, 200

truncated numeric fields, checking for, 1088

truncating text data, 676

Trust Center, 937–938

tttt:, Long Time format, 64

2NF (second normal form), 97–102

two-pass report processing, 747–749

two-sided printing, 733–735

two-tiered architecture, 1193

TypeText method, 806

U

unanticipated errors, 823–824

unbound combo boxes, 881–883

unbound controls, 266, 285

unbound forms, network applications. See also bound forms.

versus bound forms, 780–781

combo boxes, 785

creating, 781

editing data, 786–788

multiuser errors, 780–788

navigating through records, 783–788

navigation buttons, 783–785

opening, 782–783

overview, 780–781

populating, 782–783

specifying a recordset for, 782

underscore (_), continuation character, 389, 418–419

Undo button, 231

Undo event, 458–459, 460

undoing changes, 231

UnicodeCompression property, 60

52_475348-bindex.indd 133752_475348-bindex.indd 1337 4/1/10 2:02 PM4/1/10 2:02 PM