M

Machine Data Source tab (Select Data Source dialog box), 268

macro actions, 916–918, A101-A118

AskEdit macro, 933

avoiding SendKeys, A110

built-in Visual Basic constants for, 1028

categories of

building custom menu and executing menu commands, A112

controlling display and focus, AH3-AH4

executing queries, A106-A107

handling errors, A118

informing user of macro actions, A115

modifying objects, A115–A117

opening/closing Access objects, A102-A104

overview, A101

printing data, A105–A106

running another application, A118

searching for data, A111

setting values, A109

testing conditions and controlling action flow, A107–A108

Trusted column, A101

using temporary variables, A117

Clear MacroError, 916

defining multiple, 895–897

executing, 1026–1027

OpenForm, 922–923

opening list of, 891–892

searching for data, A111

SyncWeddingAndCity macro, 926

trusted and not trusted, 916–918

viewing

complete list of, 892

in Macro window, 929–930

Visual Basic equivalents for, 1028

Macro Builder, 904–905

macro design window. See Macro window

macro groups

about, 897–898, 928

understanding and using, 929–934

Macro Name column (Macro window), 891, 921, 922

macro objects

creating group of named macro procedures in, 898

creating set of named actions within, 899

name of, 900

SampleMacro, 129

Macro Single Step dialog box, 894

Macro window, 890–893

argument boxes in, 892–893

automatically displaying Macro Name and Condition columns in, 891, 922

entering macro arguments in, 890–891

illustrated, 891

layout of, 890–891

moving between upper and lower parts of, 893

not trusted macro actions in, 918

opening Actions list in, 891–892

viewing macros in macro groups, 929

MacroError object, 916, A118

macros, 887–940.

See also events;

macro objects;

Macro window

actions

avoiding SendKeys, A110

building and executing menus and commands, A112

categories of, A101–A118

Clear MacroError, 916

controlling display and focus, AH3–AH4

displaying messages or beeping, A115

handling errors, A118

not trusted, 916–918

running another application, A118

setting values, A109

using temporary variables, A117

working with objects, A115-A117

adding to Quick Access Toolbar, 30–31

advantages of, 128

AutoExec

about, 890

starting applications with, 1310, 1312

using, 896

AutoKeys, 1052, 1315–1316

calling MsgBox function, 911

conditional expressions in, 900–901

content security and, 34–35

converting to Visual Basic, 938–940

defined, 100

defining multiple actions in, 129–130, 895–897

embedded, 901–907

creating, 904–906

deleting, 906–907

editing, 902–904

saved with form or report control, 904

error trapping, 910–915

clearing MacroError object, 916, A118

process using, 913–915

unactivated, 912–913

grouping, 897–900

Hourglass automatically restored after running, 897

location in Unrelated Objects category, 51–52

malicious, 916

modifying, 212

name of, 900

opening secondary forms with, 921–924

passing status information between linked forms, 934–935

presetting values for validation, 935–938

recommended for applications, 890

referencing

controls and properties for forms and reports, 920

form and report objects, 919

form and report properties, 919–920

subforms and subreports, 920–921

temporary variables in, 991

relationship to other Access objects, 101

resetting Page property value with, 833

revising order on Quick Access Toolbar, 32

saving, 893–894

single stepping through, 894, 951

synchronizing related forms, 924–928

temporary variables in, 907–910

testing, 894–895

triggering with form events, 560

untrusted locations

disabling in, 1225

enabling for, 38

uses of, 887, 888–889

validating data, 928–934

Visual Basic

equivalents for macro actions, 1028

executing macro actions in, 1026–1027

using macros with, 890, 1052

using VB procedures instead of, 1052–1053

Macros object type, 48

Mail, 1341

mail merge documents, A81-A82

mailing labels

Avery label formats, 754, 1117

printing

company and contact, 754

with data from multiple tables, 463–468

setting up multiple-column reports as, 753–754

using partial page of, 1115–1118

mailto:

protocol prefix, 1062

main forms, 706–710.

See also subforms

Make-Table dialog box, 500

make-table queries

append vs., 502

assigning alias to field lists in, 496, 497

command on Design contextual tab for, 488

converting from select query, 500

creating, 496–500

defined, 485

icon for, 490

limitations of, 501

running, 500–502

SELECT…INTO statements as, A75–A76

verifying data in, 496

malicious macros, 916

manually processing e-mail replies, 321–322, 341–343

many-to-many relationships

about, 5,

defining linking table to create, 1077–1078

embedding subforms to reflect, 693

order-entry examples demonstrating, A8

many-to-one forms

about, 686

designing all query fields in, 688–691

how related information displays in, 691

many-to-one query as record source for, 687–688

margins, 736

Max function, 437

Max Records property, 462, 1550, 1555

Maximize button

disabling, 675

not in window, 109

using, 108

MDAC (Microsoft Data Access Components), 981

.mdb files

about, 6,

Access architecture and compatibility with, 979

compatibility with temporary variables, 910

creating compiled version of, 272

embedded macros incompatible with, 907

user-level security support for, 12

.mdf files, 1455–1456

MDI. See multiple-document interface (MDI)

Me object and keyword, 990

members

commonly used tag, 1133

HTML object, 1132

Memo data type, 226–227

memory requirements, 1341

menus

macro actions building and executing commands on, A112

shortcut

accessing table’s commands from, 106–107

displaying single Navigation Pane categories with, 81

Subdatasheet, 388

submenus

Bitmap Image Object, 534

view by, 76

viewing categories of, 72

Message Bar

enabling or disabling, 38

security alerts on, 35

message boxes

confirming deleting or pasting, 396

macro actions displaying, A115

MsgBox function for, 911, 932, 933

messages.

See also data collection messages;

error messages;

warning messages

action query error, 513–514

e-mail data collection, 318–319, 334–335

form information displayed in, 518

methods

ActiveX, 7–8

defined, 560

defining subroutines as, 1005

Find, 1104

FindFirst, 1104

IRibbonUI, 1298

LoadCustomUI, 1285

object, 993–1005

executing commands with DoCmd object, 1005

using ADO recordsets, 1001–1005

Visual Basic, 993

working with DAO recordsets, 994–997

OpenRecordset, 994–995

Quit, 1328

referencing in variables created by macros, 991

RunCommand, 1027

Microsoft Access Database Engine (DBEngine)

about, 978

DBEngine object created by, 979, 982–984

Microsoft Data Access Components (MDAC), 981

Microsoft Exchange, 1341

Microsoft Exchange Server 2000, 1342

Microsoft Expression Web, 1128, 1135, 1139, 1159

Microsoft FoxPro. See FoxPro; Visual FoxPro

Microsoft InfoPath. See InfoPath forms

Microsoft Internet Information Services (IIS), 1159

Microsoft Mail, 1341

Microsoft MVPs (Most Valuable Professionals), 17

Microsoft .NET Framework, 1159

Microsoft Office Access 2007. See Access

Microsoft Office Access dialog box, 546, 547

Microsoft Office Access Security Notice dialog box, 1338–1339

Microsoft Office Button

commands available from, 25–27

hiding options on, 1300–1301

using, 24, 25–27

Microsoft Office Excel. See Excel

Microsoft Office Genuine Advantage confirmation dialog box, 145, 146

Microsoft Office Live Web site, 1161–1162, 1166

Microsoft Office Outlook. See Outlook

Microsoft Office Security Options dialog box, 36

Microsoft Office system

Document Lists of Control IDs, 1270–1271

installing, 1342–1349

entering information on User Information tab, 1345–1346

first-time installation options, 1342–1347, 1348

hardware requirements for, 1341

setting default location on File Location tab, 1345

starting setup program, 1342

integrating with SharePoint Services, 1162–1163

product key for, 1342

upgrading previous version, 1347–1349

XML capabilities of, 1136–1137

Microsoft Office Trusted Location dialog box, 40

Microsoft Office Word mail merge documents, A81–A82

Microsoft Paint, 535

Microsoft SQL Server 2005. See SQL Server 2005

Microsoft SQL Server 2005 Express Edition. See SQL Server 2005 Express Edition

Microsoft SQL Server 2005 Express Edition Setup dialog box, 1352–1357

Microsoft SQL Server 2005 Setup dialog box, 1350, 1351–1352, 1357

Microsoft SQL Server Database Wizard, 1450–1451

Microsoft SQL Server Desktop Engine (MSDE), 132, 1494

Microsoft SQL Server Installation Wizard

Authentication Mode page, 1353–1354

Completing Microsoft SQL Server 2005 Setup page, 1357–1358

Configuration Options page, 1354, 1355

Error And Usage Report Settings page, 1354, 1355

Feature Selection page, 1352, 1353

Ready To Install page, 1355–1356

Registration Information page, 1352–1353

Setup Progress page, 1356–1357

System Configuration Check page, 1351–1352

Microsoft Visual Basic Scripting Edition (VBScript), 1128, 1158

Microsoft Visual FoxPro. See Visual FoxPro

Microsoft Visual Studio, 664, 1161

Microsoft Visual Studio .NET, 1131, 1160–1161

Microsoft Windows Installer setup file (.msi), 1340

Microsoft Windows Internet Explorer. See Internet Explorer

Microsoft Windows Vista. See Windows Vista

migrating database to SharePoint site, 1207–1233.

See also publishing database to SharePoint site

about, 1207–1208

opening database from SharePoint, 1223–1226

publishing vs., 1207

republishing after changing database, 1207, 1219–1222

steps to move database, 1212–1219

synchronizing changes after working offline, 1230–1233

ways SharePoint handles migrated data, 1218–1219

working offline, 1226–1229

Min function, 437

Min Max Button property, 675

Minimize button

disabling, 675

not in window, 109

using, 108

minus sign (-)

arithmetic operator, 365

as character in format string, 653, 655

operator precedence for, 367

missing background images in Form Wizard, 595, 690

missing characters in input masks, 174

Mod operator

function of, 365

integer as result of operations with, 373

operator precedence for, 367

modal forms

about, 524–525

formatting and using, 673

Modal property, 672

Modify Button dialog box, 31

Modify This View command (SharePoint), 1176, 1177

modifying list design (SharePoint Services), 1196

modifying table design.

See also Table Analyzer Wizard

before starting, 204–205

changing

data attributes, 225–233

fieldnames, 212–217

field properties, 232–233

maximum length of data, 230–231

primary key, 248–250

checking object dependencies, 207–209

compacting database, 250–251

converting data types, 226–230

copying fields, 222–224

dealing with conversion errors, 231–232

deleting

fields, 225

tables, 209–210

eliminating duplicate lookup values, 238

inserting fields, 220–222

Lookup properties, 240–245

making database backups before, 205–207

modifying imported tables, 292

moving fields, 217–220

Multi-Value Lookup Fields, 245–248

reasons for, 203–204

reducing redundant data, 234

renaming tables, 211–212

reversing changes, 234

Table Analyzer Wizard recommendations for, 236

Module button, 1330

module objects (Visual Basic)

creating module with, 942–943

form and report modules vs., 944

modules, 130–132, 942–944

about, 100

class, 1009–1016

defined, 943, 1009

form and report, 944

Private statement in, 972–973

Property Get procedure in, 1010–1012

Property Let procedure, 1012–1014

Property Set procedure, 1014–1016

Public statement in, 973–974

signaling declared events in, 1022–1023

understanding, 1009–1010

using Event statement in, 971–972

coding routines in, 130

creating, 131

customizing work with, 948

declaring public variables and constants, 963–964

filtering, 130–131

form and report, 944

including Option Explicit statements in Declarations sections of, 963

modifying, 212

module objects in Visual Basic, 942–943, 944

procedures in, 947

relationship to other Access objects, 101

setting debugging breakpoints in, 951–952, 957

standard

defined, 943

Private statement in, 972–973

Public statement in, 973–974

unable to edit .accde, 1330

Modules object type (Navigation Pane), 48

monitor requirements, 1341

More Pages button, 124

Most Valuable Professionals (MVPs), 17

mouse.

See also mouse pointer

moving

fields with keyboard and, 219

rows with, 218

opening objects with single- or double-click, 106

options for control selection, 612

selecting all label controls in column with, 630, 631

trapping events for, 876–878

mouse pointer

icons

crosshairs shape of, 581, 643

double arrow, 580, 581

hourglass, 897

rectangular, 352, 353

restoring after macros or procedures, 897

reverting to Select button after control placed on form, 573

Move To SharePoint button, 1212

Move To SharePoint Site Wizard

about, 1207

displaying location where migrated site is saved, 1215

log in to SharePoint site, 1213–1214

opening and entering address of SharePoint site and, 1213

showing details on migration, 1216

moving.

See also migrating database to SharePoint site

columns, 150

controls

grouped, 642–643

horizontally or vertically, 621

and sizing, 580–581

within control layout, 626–630

cut objects to Clipboard, 210

fields, 217–220

HTTP-based messages to Outlook Inbox, 325

spreadsheet data to temporary table first, 275

within Macro window, 893

MSDE (Microsoft SQL Server Desktop Engine), 132, 1494

MsgBox action, 932

MsgBox function

calling in macro, 911

options settings for, 932

return values for, 933

.msi files, 1340

MSys system tables, 1267

Multi Select property, 1084–1085, 1086

multiple constraint expressions, 1481

Multiple Items command, 592

multiple-column reports

customizing width and height for, 753–754

uses for, 754

multiple-document interface (MDI)

about, 83–86

displaying or hiding document tabs, 85–86

working in, 85

multiple-field indexes, 190–191

multiple-page forms, 723–726

controlling tabbing on, 1080–1082

example of, 520

illustrated, 725, 726

inserting page break control, 724, 725

planning, 724

setting Cycle property for, 726, 1080

multiple-selection list boxes, 1082–1086

multiple-table queries, 686–691

multiplying integer with currency fields, 373

Multi-Value Lookup Fields

Contact Type field as, 245, 529

following normalization rules for, 248

working with, 245–248

MVPs (Most Valuable Professionals), 17