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