1317
Index
P
padlock icon, 223
page breaks, reports, 366–367
Page event, 461
Page Footer section, 341–342, 344–345
Page Header section, 341–342, 343
page headers, appearance adjustments, 368–369
page numbers (forms), 694
page numbers (reports)
adding, 353
in footers, 344–345
resetting by group, 719–720
Page Setup dialog box, 745–747
page size, reports, 348–349
painting formats, 292–293
Palette Source property, 308
paper size, reports, 348–349
parallel processing, 1190
parameters, VBA
definition, 388, 442
naming conventions, 442
passing to functions, 443–445
sales tax calculation (example), 445–447
parent window handles, getting, 960
parent/child table relationships, 108–110
partition pruning, 1190
partitioning databases, 1190
passing values
ByVal versus ByRef, 948
with local variables, 561
passwords
hiding, 911
removing, 931–933
Paste Append command
Datasheet ribbon, 220
description, 233
Form ribbon, 292
Paste command
Datasheet ribbon, 220
description, 233
Form ribbon, 292
Paste Special command
Datasheet ribbon, 220
description, 233
Form ribbon, 292
Paste Table As dialog box, 86–87
pasting. See cutting/copying/pasting.
pattern searches, 181, 197–198recreating, 874–875
uncompiled databases, detecting, 877–878
option buttons, 231. See also controls.
option groups, 298–299. See also controls; radio buttons.
options, help for, 396–397
Options dialog box
Auto Data Tips option, 412, 529, 543–544
Auto Indent option, 411
Auto List Members option, 411, 528
Auto Quick Info option, 528
Auto Syntax Check option, 411, 525–527
Break on all Errors option, 411
Compile on Demand option, 411, 530
Editor tab, 410–412, 525–530
General tab, 530
Modules tab, 539, 543–544
Require Variable Declaration option,
411, 527–528
Step Into button, 543
Step Out button, 543
Step Over button, 543
Option Explicit directive, 394
Or operations
maximum number of, 203
QBE (Query by Example) grid, 202–203
Or operator
across fields in a query, 208–212
Boolean logic, 180, 188
with And operator, 211–212
in queries, 188, 201–203
results of, 183
ORDER BY clause, 475, 484
Order By On Load property, 309, 653
Order By property, 309, 652
orientation of reports, specifying, 348–349
Orientation property, 308, 652
orphaned records, 114, 166
Other properties, 283
outer joins, 122–125, 166–167. See also equi-joins.
Outlook, Automation example
collecting data, 811–818
creating e-mail, 811–815
managing e-mail replies, 815–818
Output All Fields option, 650
Output All Fields property, 651
overall database design, 13–14
overlapping windows, specifying, 1086–1087
Overlapping Windows interface, 915
overtyping versus insert mode, 69052_475348-bindex.indd 131752_475348-bindex.indd 1317 4/1/10 2:02 PM4/1/10 2:02 PM