1307
Index
LEFT JOIN...ON expression, 480–484
left outer joins, 166
Left property, 683
less-than, equal (<=), less-than-or-equal-to operator, 177
less-than sign (<)
convert to lowercase, 64, 67
Date comparison operator, 152
less-than operator, 177, 188
in select queries, 188
library databases, 851–853
library references, 851–853
LibraryName parameter, 947
lifetime, VBA variables, 434–435
Like operator
description, 179–180
in select queries, 188
similar string indicator, 188
with wildcards, 181, 195–198
line breaks, inserting in forms, 231
lines, graphic. See graphic rules.
Link Child Fields property, 652
Link Master Fields property, 652
LinkChildFields property, 686
linked pictures versus embedded, 307
Linked Table Manager Wizard, 599–600
linked tables. See also external tables, linking to.
data macros, 576
external, adding records to, 599
functions in query data, 598
limiting external records, 598
Linked Table Manager Wizard, 599–600
modifying information, 599–600
navigating datasheets, 599
optimizing, 598–599
relationships , setting, 598
renaming, 597
SQL Server conversions, 1235
view properties, setting, 598
viewing information, 599–600
linking
Access to SharePoint lists, 1119–1123
DAO tables, 600–606
dialog boxes to forms, 894
dynamic, 940. See also late binding.
static, 940. See also early binding.
subforms to parent forms, 686–687
linking tables. See also external tables, linking to; join tables.
AttachExcel function, 602–603
checking links, 606–607K
Kanji conversions, 60
Keep Together option, 363
key violations, action queries, 676
keyboard events, 452, 455, 457
KeyDown event, 455, 460
KeyPress event, 455, 460
keys. See foreign keys; primary keys.
KeyUp event, 455, 460
keywords
color coding, 419–420
VBA, 379L
L, required letter indicator, 67
Label control, on the ribbon, 1037–1038
label control properties, 359–360
label controls
moving, 356–358
pasting, 356
properties, 359–360
resizing, 354
labeling controls, 279–280
labels. See also controls.
aligning, 736
data-entry forms, 22
highlighting, 352
mailing, 322–323
reports, aligning, 736
on tabs, 702
Last option, 657
last/first field values, finding, 657
late binding, 794–795. See also dynamic linking.
latency, troubleshooting, 768–769
Layout for Print property, 308
layout for reports
adjusting, 330–331
multiple-page display, 336–337
Print Preview window, 335–337
selecting, 329
Layout view
enabling, 306
modifying controls, 312–315
purpose of, 292
layout view, enabling, 1088
Leading Zeros in Dates option, 625
leading zeros in numeric fields, 5052_475348-bindex.indd 130752_475348-bindex.indd 1307 4/1/10 2:02 PM4/1/10 2:02 PM