calculated fields, errors in, 264
Calculated Totals and Fields button (PivotTable toolbar), 165
calendar controls, 113–114, 117
Call statement, 218
captions
forms, 49, 58
labels, 59
reports, 195
carriage returns, 337
cascading deletes, 33
cascading updates, 33
Catalog merge, mail merge documents, 381–382, 393–395
categories, tblCategories variable, 14, 43
CBF (code behind forms), 213
cbo tag (combobox), 293–294
cboCategoryID variable, 92–93
cboExportType variable, 521
cboFilterField variable, 455–456
cboFilterValue variable, 87–89
cboMergeType variable, 385
cboRecipients variable, 280
cboSelectDataSource variable, 505
cboSelectOutlookItem variable, 452
cboShipAddressID variable, 85
cbr tag (commandbar), 293
CCur method, 458
Change Menu Picture option (Add-In Manager dialog box), 206
changes, client-requested
application-specific changes, 261–265
name fields, adding additional, 274–277
characters, lowercase/uppercase, 13
Chart Type button (PivotChart toolbar), 172
charts
PivotCharts
column graphs, 169
creating, 167–168
embedded, 173
formatting options, 168
legends, 168
line graphs, 170
pie charts, 170
3D graphs, 170
toolbar buttons, 171–173
tags, 294
Checkbox button (Toolbox), 80
checkboxes
tags, 294
uses for, 84
CheckDocsDir function, 424
child elements, LinkChildFields property, 62, 71
chk tag (check box), 294
Choose Builder dialog box, 51, 301
Choose Database Object dialog box, 296
cht tag (chart), 294
circular reference errors, 50
class modules
cls tag, 291
Project Explorer, 213
Class property, 484
Classes list
Excel object model, 500–501
Outlook object model, 428
Word object model, 367–368
Click event procedure, 278–280
clients
client relations, 260–261
client-requested changes
application-specific changes, 261–265
name fields, adding additional, 274–277
Close button procedure, forms, 54
Close Form button (Export to Word dialog box), 94
cls tag (class module), 291
cmd tag (command button), 294
cmdClose variable, 232
cmdCreateDocuments_Click event procedure, 383
cmdEmailReport variable, 472
cmdImportDatafromOutlookItem variable, 483
cmdSave variable, 232–233
code
ActiveInspector property, 484
ALTER TABLE statement, 150
appointments, adding contacts to, 447–449
Automation code
Excel, 498
Outlook, 425–426
Word documents, 364
basOutlookAutomation variable, 473
blnSomeSkipped variable, 445
cboCategoryID variable, 92–93
cboFilterField variable, 455–456
cboFilterValue variable, 87–89
CCur method, 458
Click event procedure, 278–280
cmdClose variable, 232–233
cmdEMailReport variable, 472
cmdImportDatafromOutlookItem variable, 483
cmdSave variable, 233
CREATE TABLE statement, 150
DblClick event procedure, 241–242
Do Until...Loop statement, 219
Do While...Loop statement, 218–219
documents, creating, 377–380
DROP statement, 151
For Each...Next statement, 220
EndTime property, 466
faxes, sending
attachments, 532–536
automatic reception, 548
cover pages, 542
dialog forms, 538
GetWinFaxDir function, 540
OpenWinFax method, 539–540
variables, declaring, 540
FileSystemObject object, 473–474
Fill function, 316
forms
add-to comboboxes, 90–93
AfterUpdate event procedure, 72
Close button procedure, 54
command buttons, 109
Current event procedure, 55
event procedures, 53
filter forms, 237–239
image control, 110–111
listboxes, 95–99
Not in List event procedure, 90–91
option groups, 83–84
For...Next statement, 219–220
fraShippingMethodID, 83
gappExcel variable, 503
GoTo statement, 220
If...Then...Else statement, 221
listbox records, creating letters for, 95–99
macros, recording, 504
mail merge documents
Access Merge subfolder, 384
bookmarks, 386
Catalog merge, 381–382, 393–395
cboMergeType variable, 385
cmdCreateDocuments_Click event, 383
datasheet forms, 399–403
doc properties, 389
exporting to text files, 392
invoice creation dialog, 407–411
ItemsSelect property, 387
merge done message, 388
records, checking missing, 391
Subject property, 392–393
TypeText method, 395–396
MailItem property, 432
Node_Click event procedure, 318–319
Not in List event procedure, 320–321
OpenWord function, 372
Outlook, importing Access data into, 435–436
pstrFilterField variable, 456
pstrQuery variable, 456–457
qryConcatenateAddressComponents variable, 124
qryConcatenateNameComponents variable, 124
qrySplitAddressComponents variable, 124
qrySplitNameComponents variable, 126
ReadStat property, 322
records
filtered, 454
skipped, 445–446, 463
reports
conditional formatting, 200–201
one-line event procedure, 186
single order, 196
Select Case...End Select statement, 222–223
StartTime property, 465
strQuery variable, 403
subTable variable, 485–486
TaskItem object, 450–451
tasks, adding contacts to, 450–451
tblIno fields, 224
TransferSpreadsheet method, 527
TransferText method, 480
txtLetterText query, 402–403
txtMessageText variable, 441
txtPageTotal variable, 186
union queries, 303
With...End With statement, 224
Word data, importing into Access, 414–415, 417
workbooks, 504
worksheets, 503
code behind forms (CBF), 213
Code button (Form Design toolbar), 215
Collapse button
PivotChart toolbar, 172
PivotTable toolbar, 165
colons, removing from labels, 58
color schemes
continuous forms, 74
forms, 46–47
columnar reports, 189–192
columns
Column object, SetWidth function, 368
datasheet columns, resizing, 64
forms, 58
graphs, PivotCharts, 169
headings, PivotTables, 158–159
not dependent on keys, eliminating, 32
sorting, 235
zero-based, 438
Columns Width property, 94
Combo Box button (Toolbox), 80
comboboxes
add-to, 90–93
field list row source, 86–90
forms, 54, 56
lookup fields as, 18
table/query row source, 85–86
tags, 293–294
value list row source, 86
comma-delimited text file, linked tables, 10, 471
Command Button button (Toolbox), 80
command buttons
forms, 47, 53, 109
tags, 294
commandbar tag (cbr), 293
commands
acCmdSizeToFitForm, 55
automation
Excel, 503
Outlook, 430
Word, 371
Compile Project (Standard toolbar), 365
File menu, Get External Data, 529
Insert menu
ActiveX Control, 112
Picture, 202
Tools menu
Addins, 44, 205
Options, 24
Startup, 208
TRANSMIT, sending faxes, 541
View menu, Subform in New Window, 64
compilation errors, 256
Compile Project command (Standard toolbar), 365
concatenating name data and address data, 335
conditional formatting, reports, 198–201
connections, faxes, 542–543
constants
named, 199, 370
reports, 199
ContactItem object, 430, 447
contacts
adding
to appointments, 447–449
to tasks, 450–451
fsubContactsAll variable, 454
Contacts option (Import Exchange/Outlook Wizard), 434
ContactTitle object, 128
continuous forms
color schemes, 74
overview, 40–41
control resources, expressions, 300
Control Source property, 86, 113
control tag (ctl), 293
Control Wizards button (Toolbox), 80
adding to forms, 48–49
calendar, 113–114, 117
email, 59–60
form, 59–60, 299–300
image, 110–111
line, 111
MonthView control, ActiveX, 118
page break, 112, 294
rectangle, 111
Rename Form Controls add-in, 295–296
Rename Report Controls add-in, 295–296
report visibility, 327
special, 112–116
standard, 79–80
subform, 111
subreport, 111
tab, 60–61, 112–113
treeview, 114–116
converting blanks to spaces, 13
Copy button (PivotTable toolbar), 165
copying objects, 340
Count function, 128, 130
CountOfFieldName object, 130
cover pages, faxes, 542
Create button (Edit Relations dialog box), 35–36
Create Contact(s) button (Export Contacts to Outlook dialog box), 557
Create Document(s) button (Export to Word dialog box), 382
CREATE INDEX statement, 151
Create Main Menu option (Add-In Manager dialog box), 206
CREATE TABLE statement, 150
CreateAndTestQuery function, 237
CreateFolders method, 377
CreateItem method, 433
CreateObject function, 371
creating
documents, 377–380
forms
standard forms, 46–47
using Design Schemes Add-in, 44–45
letters, for listboxes, 377–380
menus, 302
PivotCharts, 167–168
tables
Datasheet View, 8–9
Design View, 9
discussed, 5–7
ImportTable, 9
LinkTable option, 9–10
Products table, 11–15
Table Wizard, 9
crosstab queries, 132–135
CStr function, 342
ctl tag (control), 293
cur tag (currency), 292–293
currency data type, 16
Current Database option (Append dialog box), 333
Current event procedure, forms, 55
curSales object, LNC naming element, 295
custom control tag (ocx), 294
Custom Form Wizard, 45–46
Custom Paper Size dialog box, 190
Customers template (Table Wizard), 20–23
customization, PivotTables, 160
Customize dialog box, 365