1296
Index
ElseIf clause, 402–403
e-mail, sending with data macros, 561
embedded macros, 552, 1075–1077
embedded pictures versus linked, 307
Enable AutoJoin option, 650
Enable Design Changes check box, 1084, 1088
Enable Layout View check box, 1084, 1088
Enabled property, 682
encapsulation, 982
encoding, 930–931
encryption, 930–931
#End If directive, 535–537
endless loops, preventing, 405
end-user maintenance, SharePoint, 1138
Enter event, 460
entity integrity, 76, 115
EOF (end-of-file indicator), 497–498
Equal Horizontal command, 277
equal sign (=)
assignment operator, 422
Date comparison operator, 152
equal operator, 176, 188
in select queries, 188
Equal Vertical command, 277
equi-joins, 122–125, 165–166
Err object, 827–829
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
Error event, 458–459, 461, 836–837
error events, 452
error handlers
definition, 824–825
exiting, 834–835
error handling. See also debugging; testing; troubleshooting.
in Access, 821–822
access errors, 837–838
ADO objects, 837–838
in applications, 822–823
disabling, 831
error messages, 822–823. See also specific messages.
fatal errors, 821
handled errors, 823
identifying errors, 824–826
logical errors, 820
macros, 552
runtime errors, 821–824editing (continued)
disabled fields, 232
locked fields, 232
multiuser locked records, 232
records with data macros, 559
SharePoint list items, 1110–1111
unbound forms, network applications, 786–788
VBA modules, 393
VBA procedures, 399
editing data
in forms, 295
with queries, 134
editing datasheets
current date/time, inserting, 231
insertion point, moving, 231
line breaks, inserting, 231
protected, 231
records, adding, 231
records, deleting, 231
saving the current record, 231
selecting, 231
techniques, 231
toggling values, 231
undoing changes, 231
values, inserting, 231
values, replacing, 231
editing forms
current date/time, inserting, 231
enabling, 310
insertion point, moving, 231
line breaks, inserting, 231
protected, 231
records, adding, 231
records, deleting, 231
saving the current record, 231
selecting, 231
techniques, 295
toggling values, 231
undoing changes, 231
values, inserting, 231
values, replacing, 231
Editor tab, 410–412, 525–530
editors. See also VBA editor.
macros, 1264
ribbons, 1254–1255
XML, 1012
EditRecord action, 559
#Else directive, 535–537
Else statements, 40252_475348-bindex.indd 129652_475348-bindex.indd 1296 4/1/10 2:02 PM4/1/10 2:02 PM