1277
Index
bound forms. See also unbound forms.
connecting to data sources, 304
creating, 304
multiuser errors, 780–788
branching
Case Else clause, 404
definition, 401
Else statements, 402
ElseIf clause, 402–403
If...Then...Else...Endif statements, 401–403
If...Then...Endif statements, 401–403
overview, 401
Select Case...End Select statements, 403–404
Break on all Errors option, 411
breakpoints, 539–544. See also Stop statements.
bugs. See also testing.
See also Compatibility Checker
See also debugging
See also error handling
See also testing
See also troubleshooting
definition, 524. See also debugging; logical errors;
troubleshooting.
severity levels, 1092–1093
bulleted lists, 723–725
bulletproofing applications
characteristics of, 898–899
continuous improvement, 938
documenting applications, 1100
error trapping on Visual Basic procedures, 1099
overview, 898
separating tables from applications, 1099–1100
bulletproofing applications, principles of
building to specification, 900–902
development process, 900
documentation, 902–903
bulletproofing applications, security
bulletproofing forms, 928
digital certificates, 935–936
digital signatures, 935
encoding, 930–931
encryption, 930–931
macros, 934–938
passwords, removing, 931–933
privacy settings, 937–938
property values, getting, 927
property values, setting, 926–927Backstage area
Compatibility Checker, 1158
illustration, 28
new features, 1254
overview, 27
SharePoint, 1139–1140
banded reports. See also sections, of reports.
definition, 340
Detail section, 341–342, 344
Group Footer section, 341–342, 344
Group Header section, 341–342, 343–344
overview, 340–342
Page Footer section, 341–342, 344–345
Page Header section, 341–342, 343
Report Footer section, 341–342, 345
Report Header section, 341–342, 343
BeforeDelConfirm event, 458–459
BeforeInsert event, 458–459
BeforeQuery event, 464
BeforeRender event, 464
BeforeScreenTip event, 464
BeforeUpdate event, 458–459, 460
Between...And operator
range indicator, 184, 188, 205–206
in select queries, 188
binding to a data source. See also connecting.
bound controls, 266, 285
bound forms, 304
in reports, 346–348
binding VBA object variables to Automation references,
792–795
Blank Form command, 252
blank lines, inserting in reports, 731–733
blank pages, on reports, 349, 372
BOF (beginning-of-file indicator), 497–498
bookmarks
finding data, 885–888
inserting pictures in Word, 807
marking records, 866
Boolean data type, VBA, 428
Border Style property, 307, 360
borders
dialog boxes, 704
forms, 307
reports, transparent, 360
BorderStyle property, 704
bound controls, 266, 28552_475348-bindex.indd 127752_475348-bindex.indd 1277 4/1/10 2:01 PM4/1/10 2:01 PM