1305
Index
Hyperlink data type, 49, 54
hyphen (-)
input mask separator, 67
range indicator, 181
in select queries, 188
subtraction operator, 173–174, 188I
icons, application, 1085
identifiers, color coding, 419–420
identity fields, 1189
#If compiler directive, 413–414
#If directive, 535–537
If...Then...Else...Endif statements, 401–403
If...Then...Endif statements, 401–403
IIF function versus If...Then...Else, 864
imageMso, specifying, 1035–1037
IMEMode property, 60
IMESentence Mode property, 60
Immediate window, 399–401, 538–539, 541. See also
debug window.
implicit variables. See also explicit variables; VBA, variables.
declaring, 423
effects on performance, 430
versus explicit, 430
Import group, 610
Import Specification dialog box, 624–625
importing external data. See also external tables, linking to.
Access objects, 628–630
canceling, 633
dBase tables, 631–632
definition, 581
error handling, 633
from Excel spreadsheets, 614–618
HTML documents, 627–628
versus linking and exporting, 582
from other Access databases, 611–613
Outlook folders, 630–631
with a scheduled Outlook task, 614
from SharePoint lists, 618
troubleshooting, 633–634
uses for, 583–584
XML documents, 625–627
importing external data, from text files
CSV (comma-separated values), 618–623
duplicate primary keys, 621
field separators, 620
fixed-width files, 621–623control tips, on forms, 697
Intellisense, 395–397
for options, 396–397
for the ribbon, 1015
SuperTips, 1015
for syntax, 528–529
for variables, 543–544
help, VBA
Auto List Members, 396
Auto Quick Info, 396–397
Intellisense, 395–397
Help Context ID property, 311
Help file, specifying, 311
Help File property, 311
hh:, formatting hours, 64
Hide Duplicates property, 718
HideHeader function, 719
hiding
fields in queries, 145–147
system objects, 1090
hiding/showing
controls, 463, 682, 684
datasheet values, 231
fields, 241
form values, 231
forms in reports, 741
macro results, 1055, 1056
page headers, 719
records, 237
repeating report information, 716–718
report controls, 725–727
result fields, 647
highest/lowest field values, finding, 657
highlighting alternate records, 220, 239–241
Home tab
Access 2010 ribbon, 36
Datasheet ribbon, 219–221
Form ribbon, 291–293
Form view, 291–293
Hopper, Grace, 524
horizontal lines, in reports, 368–369, 730
Hour property, 362
hourglass, changing cursor to, 1054–1055
Hourglass action, 1054–1055
hourglass cursor, 868
HTML data, linking to, 583, 587, 594–595
HTML documents, exporting, 627–628
hwnd parameter, 95052_475348-bindex.indd 130552_475348-bindex.indd 1305 4/1/10 2:02 PM4/1/10 2:02 PM