Index_M

M

m tag (module-level variable), 291

macros

compilation errors, 256

mcrCreateFlatFileTable, 358

mcrTestOutlookAutomationCode, 253

mcrTestWordAutomationCode, 253

recording, 372–373, 504

tags, 291

mail merge documents, Word

Access Merge subfolder, 384

bookmarks, 386

Catalog merge, 381–382, 393–395

cboMergeType variable, 385

cmdCreateDocuments_Click event procedure, 383

datasheet forms, 399–403

doc properties, 389

Documents path, 382

exporting to text files, 392

invoice creation dialog, 407–411

ItemsSelected property, 387

merge done message, 388

overview, 373–374

records, checking missing, 391

Subject property, 392–393

TypeText method, 395–396

Mail messages option (Import Exchange/Outlook Wizard), 434

mailing labels

discussed, 187–188

TypeText method, 375

Mailing List template (Table Wizard), 23–24

mailing lists

tblMailingList variable, 23–24

tblMailingListCompanies variable, 137

txlsMailingList variable, 137

MailItem property, 432

main menu

date range code, 226–227

merge example, 375–379

make-table queries, 145

many-to-many relationships

discussed, 32, 37

forms, 76–77

master fields, LinkMasterFields property, 62, 71

MaterialID variable, 76

MaterialName variable, 76

Max function, 128, 131–132

mcr tag (macr), 291

mcrTestOutlookAutomationCode macro, 253

mcrTestWordAutomationCode macro, 253

mem tag (memo), 292

Members list

Excel object model, 500

Outlook object model, 428

Word object model, 367

memo data type, 16

memo tag (mem), 292

Menu Manager add-in

basUtilities module, 226

installing, 205–206

menus, creating, 302

references, 206–208

running, 208–212

Menu Sidebar Picture Picker dialog box, 208–209

menus, creating, 302

merge done message, mail merge documents, 388

merging documents, 224

methods. See also functions; properties

arguments and, 368

CCur, 458

CreateFolders, 377

CreateItem, 433

GetDefaultFolder, 431

OpenWinFax, 539–540

OutputTo, 473–474, 513

PrintOut, 500

RecordsetClone, 54

SetFocus, 289

SetWidth, 368

TransferSpreadsheet, 495, 527–528

TransferText, 480, 512

TypeText, 375, 395–396

Microsoft Outlook dialog box, 439

Mid function, 215

Min function, 128, 131

mismatched data type errors, 130

missing reference errors, 256

Module Pane (VBA), 215–216

module-level variable (m tag), 291

modules

basUtilities, 226

Call statement, 218

Do Until...Loop statement, 219

Do While...Loop statement, 218–219

ElseIf statement, 220–221

For Each...Next statement, 220

For...Next statement, 219–220

GoTo statement, 220

If...Then...Else statement, 220–221

Project Explorer, 213

Select Case...End Select statement, 221–223

tags, 291

tblInfo fields, 224–225

VBA types, 217

With...End With statement, 224, 373

MonthView control, ActiveX, 118

More Controls tool (Toolbox), 80, 112

More Tools button (Toolbox), 113

moving

forms, 62

between table fields, 19

mrcCreateFlatFileTable macro, 358

Multiple Items tab (Import Outlook dialog box), 483, 488

Multiple Plots button (PivotChart toolbar), 172

Multiple Plots Unified Field button (PivotChart toolbar), 172

Multiple Tables tab (Import from Word dialog box), 413–414

multiselect listboxes, 381–385

MultiSelect property, 93–94