Index_F

F

faxes, sending

attachments, 532–536

automatic reception, 548

connections, 542–543

cover pages, 542

dialog forms, 538

discussed, 531

Edit and Send Fax dialog box, 539

Fax Access Report (DDE) dialog box, 543, 545

GetWinFaxDir function, 540

multiple attempts, 542

to multiple recipients, 550–554

OpenWinFax method, 539–540

progress bar, 547

snapshots, 544–546

TRANSMIT command, 541

variables, declaring, 540

fdlg tag (form, dialog), 291

Field Chooser dialog box, 429

Field List button

PivotChart toolbar, 172

PivotTable toolbar, 166

field list row source, comboboxes, 86–90

fields, tables

adding, 150

calculated, errors in, 264

deleting, 150

FieldSize property, 19

Long Integer (Datasheet View), 9

lookup, 18

moving between, 19

naming, in Datasheet view, 8

primary data types, 16–18

renaming, 12, 150

tblInfo, 224–225

VendorID, 20

FieldSize property, 16, 19

fifth normal form, normalization, 33

file formats, PDF, 481–482

File Locations tab (Options dialog box), 421

File menu commands, Get External Data, 529

files, text files, writing data to, 555–556

FileSystemObject object, 473–474

Fill function, 114–116, 316

Filter by Selection button (Form toolbar), 122

filter forms, 235–239

Filter property, 155

filter values, PivotTables, 161

filtered records, 454, 525

filtering reports, 195–196

FilterString option (Dynamic Contact Search dialog box), 237

FilterType option (Dynamic Contact Search dialog box), 237

FilterValue option (Dynamic Contact Search dialog box), 237

Find and Replace feature, 295

Find Unmatched Query Wizard option (New Query dialog box), 338–339

first normal form, normalization, 31

First Row Contains Column Headings option (Import Spreadsheet Wizard), 330–331

flat-file databases, 31

fmnu tab (form, menu), 291

fmnuMain variable, 55

fmsg tag (form, message), 291

folders

Access Merge subfolder, 384

CreateFolders method, 377

GetDefaultFolder method, 431

Select Outlook, 460

fonts

forms, 47

PivotTables, 162

reports, 180

footers

acFooter constant, 199

acGroupLevel1Footer constant, 199

acGroupLevel2Footer constant, 199

acPageFooter constant, 199

reports, 176, 184

For Each...Next statement, 220

Force New Page property, 184

foreign keys, 20, 33

Form Design toolbar, 215

Form toolbar, 122

Format function, 410

Format property, 24

Format WordArt dialog box, 203

formatting

PivotCharts, 168

reports, 198–201

Form_Current event procedure, 231

forms

AfterUpdate event procedure, 72

alignment, 47–48

borders, 62

bound object frame, 111

calendar controls, 113–114

captions, 49, 58

checkboxes, 84

Close button procedure, 54

color schemes, 46–47

column size, adjusting, 58

comboboxes

add-to, 90–93

discussed, 54, 56

field list row source, 86–90

table/query row source, 85–86

value list row source, 86

command buttons, 47, 53, 109

continuous

color schemes, 74

overview, 40–41

controls

adding, 48–49

renaming, 299–300

creating

using Design Schemes Add-in, 44–45

standard forms, 46–47

Current event procedure, 55

Custom Form Wizard, 45–46

data entry, 40

datasheet

columns, resizing, 64

mail merge documents, 399–403

overview, 40

DateTimePicker control, ActiveX, 117

dialog, 41

displays, 43–44

email controls, 59–60

embedded, 62–63

event procedures, 53, 90–91

filter, 235–239

Filter by Selection button, 122

fonts, 47

hiding, 212

image control, 110–111

IsLoaded property, 54

labels, 47, 62, 80

line control, 111

listboxes

code, 95–109

ItemsSelected property, 95

MultiSelect property, 93–94

Load event procedure, 55

many-to-many relationships, 76–77

MonthView control, ActiveX, 118

moving, 62

naming conventions, 50–52

New Form dialog box, 45

New Thing, 231–235

option buttons, 84–85

option groups, 81–84

page break control, 112

Picture property, 110

query grids, 65

Query Properties property, 58

read-only, 18, 72

records

locating, 54

sources, displaying, 81

rectangle control, 111

renaming, 298

reports and, 176, 193

Row Source property, 55, 58

selection considerations, 42

single, 40

standard controls, 40, 79–80

subforms, 41, 111

subreport control, 111

tab controls, 60–61, 112–113

tags, 291, 293

text boxes, 47, 81

tlkpForms variable, 210

toggle buttons, 112

treeview controls, 114–116

types, 39–40

unbound object frame, 111, 232

Unique Values property, 58

Forms to Rename dialog box, 299

For...Next statement, 219–220

fourth normal form, normalization, 32

fra tag (frame), 294

frames, tags, 294

fraRecord variable, 454

fraShippingMethodID variable, 83

frb tag (bound object frame), 294

freestyle text, 375, 381

Frequently-used fields option (Field Chooser dialog box), 429

frm tag (forms), 291, 293

frmCustomers variable, 121

frmEmployees variable, 232

frmEmployeesActiveXControls variable, 117

frmEmployeesCalendar variable, 113

frmExportToWordDatasheet query, 399

frmExportToWordListBox query, 381

frmImageControls variable, 110

frmImportFromExcel variable, 146

frmNewEmployee variable, 232

frmOrders variable, 81

FromDate function, 227

fru tag (unbound object frame), 294

fsub tag (form, subform), 291

fsubContactsAll variable, 454

fsubDayMax object, LNC naming element, 294

fsubSearchResults variable, 241

fsubShippingAddresses variable, 60

functions. See also methods; properties

aggregate, totals queries, 127–128

Avg, 127

CheckDocsDir, 424

Count, 128, 130

CreateAndTestQuery, 237

CreateObject, 371

CStr, 342

DateAdd, 226

DocsDir, 424

Fill, 114–116, 316

Format, 410

FromDate, 227

GetDocsDir, 224–225, 376, 424

GetObject, 371, 376

GetWinFaxDir, 540

Group By, 132

Iif, 311

Max, 128, 131–132

Mid, 215

Min, 128, 131

Nz, 95, 376, 409, 438

OpenWord, 371–372

qmax, 130

qmin, 130

qsum, 130

rstNew, 342

rstOld, 342

StDev, 128

Sum, 127, 129

Switch, 83–84

TemplateDir, 280, 376

ToDate, 227

Trim, 311

Var, 128