Index_C


C

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




Expert One-on-One(c) Microsoft Access Application Development
Expert One-on-One Microsoft Access Application Development
ISBN: 0764559044
EAN: 2147483647
Year: 2006
Pages: 124
Authors: Helen Feddema

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