M

Macro Builder, 84

macros

embedded in Access 2007, 2

examples of, 46–48, 49

instead of procedures, 46

naming, 47, 49

versus procedures, 46–48, 49

responding to events, 84

saving, 47

“the Macros in this project are disabled” error message, 34

mcr (Macro) prefix, 56

MDB file format, 2

Me keyword, 94, 125, 126

Memo field data type, 51

memo fields, 2

menu add-ins, 312

menus, importing or linking data, 200

methods

adding to a class module, 111

adding to a form, 126

calling from within Property Let, 106

in a Class Diagram, 103

creating, 111–113

defined, 79

described, 82–83

example using, 86–91

implementing with interface inheritance, 123

Microsoft Access. See Access 2007

Microsoft Content Management Server 2002, 221

Microsoft Excel. See Excel

Microsoft IntelliSense, 112

Microsoft Office 12.0 Object Library, 288–291

Microsoft Office 2003 Web Services Toolkit, 214

Microsoft Outlook. See Outlook

Microsoft SharePoint Portal Server 2003, 221

Microsoft SQL Server. See SQL Server

Microsoft SQL Server Database Wizard, 262–263, 466

Microsoft Visio. See Visio

Microsoft Visual Basic, 1

Microsoft Word. See Word

middle (business) layer in three-tier architecture, 15, 16

mod (Module) prefix, 56

modBusinessLogic module, 384–389, 400–404, 489–499

modDatabaseLogic module, 384, 389–399, 400, 404–408

modeling, 4

modError module, 308, 311

Modify Columns and Settings link, 227

modules

authorizing to run, 34

creating, 27–28, 29

defined, 27

inserting into databases, 242

types of, 29, 101

Modules tab, 29

MouseUp event, 92, 93

MouseWheel event, 92, 93

Move Data ribbon, 319

MoveToFirstRecord procedure, adding to modBusinessLogic, 490

MoveToLastRecord procedure, adding to modBusinessLogic, 490–491

MoveToNextRecord procedure, adding to modBusinessLogic, 491–492

MoveToPreviousRecord procedure, adding to modBusinessLogic, 491

msgbox command, 21, 23

msgbox function, 195–196, 293

Multiple lines of text data type, 221

multiuser architecture considerations, 318–322

multiuser considerations for applications, 315–322