..Then...Else...End If construct for, 813
labels for, 807??“808, 815??“816, 819??“820
for library database references, 1084
for macros, 1151??“1156
need for, 801??“802, 808??“809
Response argument of Error event procedures, 809
Resume statements for, 817??“820
Select Case...End Select statement for, 810,
812??“813
template for, 807
terminating error handlers, 817
three-step process for, 807
types of errors, 802??“806
for unanticipated errors, 806
untrapped errors, 805
when converting macros to VBA modules, 354
when creating a Word object instance, 736
error messages and warnings. See also debugging; error
handling
for action queries, 615??“616
bypass Error 3270, 899
confirming record deletion, 434??“435
for custom ribbons, 1099
for data type validation, 211
DataErr argument for returning error codes, 809, 810
for deleting parent records, 222
for deleting records from datasheets, 221
for empty reports, 663
enforcing referential integrity, 119
Err.Number property for determining errors, 812??“813
import errors, 576??“577
for primary key duplicate values, 210
providing for users, 882??“883
record-locking Error 3021, 704
record-locking Error 3186, 704, 709??“711
record-locking Error 3188, 711??“712
record-locking Error 3197, 704??“705, 712??“714
record-locking Error 3260, 705??“709
record-locking Error 3421, 705
for Required property, 67
for runtime errors, 804??“805
for synchronization errors, 1004
update Error 7787, 810
update Error 7878, 810
for Validation Rule property, 66, 67
#Error printed in reports, 663, 677
1311
Index E
ErrorRoutine() function
for Error 3186, 704, 711
for Error 3197, 704??“705, 714
for Error 3260, 705, 708??“709
overview, 703??“705
ParseError() sub called by, 711??“712
Errors collection for ADO errors, 811??“812
Euro number format, 58
even-odd page printing, 670??“672
event procedures.
Pages:
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
2379