H


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




Microsoft Office Access 2007 Inside Out
MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
ISBN: 0735623252
EAN: 2147483647
Year: 2007
Pages: 234

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net