handles, control, 580–581
hard drive space requirements, 1341
hardware requirements for Access, 1341
HasModule property, 944
HAVING clause, 464, A45
headers
Add New button in, 545
form
example of, 518–519
multiple-page, 520
report
about, 739–740, 741
building report with or without, 767
displaying page numbers in, 832–833
repeating on subreports, 851–854
height of form, 565
hexadecimal code for color names, A93–A99
Hidden check box (Properties dialog box), 70, 75
hidden columns in SharePoint lists, 1206, 1219
Hide Details button, 476, 477
Hide Duplicates property, 840–841
hiding
document tabs, 85–86
existing Ribbon elements, 1271–1272
Navigation Pane
on application startup, 1311
contextual tabs hidden when collapsed, 739
custom groups and object shortcuts, 67–71
options on Microsoft Office Button, 1300–1301
redundant report values, 840–841, 842
status bar, 1311
Unassigned Objects group, 67, 68, 74
Home tab, 24, 42
horizontally
moving one or more controls, 621
selecting all controls in horizontal area, 588, 600
hourglass mouse pointer, 897
Housing.accdb database
displaying list of tables for, 105–106
function of reports for, 120–121
macros in, 128–130
modules of, 130–132
role of forms in, 114
.htm file type, 1237, 1243–1245
HTML (Hypertext Markup Language), 1128–1135.
See also HTML forms
acceptance of XML and, 1235
editing, 1134–1135
exporting datasheet with formatting to, 1146–1148
generating HTML page from Access report, 1151–1154
members for HTML objects, 1132
missing graphic or background on Web page, 1150
static documents in, 1140–1158
customizing appearance of Datasheet view, 1143–1148
designing and using output templates, 1148–1151
tag members, 1131–1134
tags
applying to complex Web page, 1133–1134
browsers’ rendering of, 1131
common coding, 1129–1131
commonly used members of, 1133
viewing behind Web page, 1128
writing from Visual Basic, 1154–1158
HTML editors, 1128
HTML files
opening in browser after export complete, 1147
output options for exported, 1147–1148
HTML forms, 305–322
choosing recipients for, 320–321
collecting data with, 307–308
customizing message, 318–319
data types unavailable for, 311
date to stop processing replies, 315
defining collection fields as lookup values, 324
e-mail addresses for, 315–317
filling out, 322–325
finding addresses in table, 317–318
formatting Rich Text fields in, 324
getting started with, 306–307
Hyperlink data types in, 321
including lookup values in, 324–325
InfoPath forms vs., 327
instructing recipient to click Reply, 319
new or updated data collection for, 308–309
previewing message in Outlook, 321–322
processing live data on Web pages with, 1160
reply processing for, 312–313
selecting data to collect in, 309–310
wizard’s summary of process, 320
HTML Output Options dialog box, 1147–1148, 1150
HTML template tokens, 1149
HTTP (Hypertext Transport Protocol), 1138
Hyperlink data type, 158, 160
about, 397
collecting data via e-mail with, 321
converting, 227
example of converting, 229–230
hyperlinks
activating, 398
adding or editing in forms, 547–548
bug fixed for mailto:
protocol prefix, 1062
editing, 400–401
fixing e-mail, 1061–1062
inserting, 398–400
viewing, 397–398
Hypertext Markup Language. See HTML (Hypertext Markup Language)
Hypertext Transport Protocol (HTTP), 1138