1310
Index
Merge it With Microsoft Word option, 636
message bar, displaying, 937
MessageBox action, 1055, 1074
messages. See also error messages; MsgBox function.
error information, displaying, 1074
informational, 915–918
informational, displaying with actions, 1055
printing, 537–538
system, enabling/disabling, 1054–1055, 1056
methods. See also specific methods.
creating, 976–978
definition, 396
Product class, 974, 995–996
micro-adjusting report controls, 736–737
Microsoft Office button. See File button.
Microsoft Word Mail Merge option, 636
migrating Access applications to the Web, 1135, 1138–1140
Min Max Buttons property, 307
Min option, 657
Min/Max buttons, displaying on forms, 307
minus sign. See hyphen.
Minute property, 362
mm:, formatting month of the year, 63
mmm:, formatting month of the year, 63
mmmm:, formatting month of the year, 63
Mod, modulo division operator, 175–176
Modal Dialog command, 253
Modal property, 704
Modified Date option, 35
modifying. See also editing.
control appearance, 277–278
control type, 270, 280–281
datasheets, 10
linked tables, 599–600
VBA event procedures, 391
modifying, data in datasheets
adding records, 234
aligning data, 241
background color, modifying, 239–241
coloring alternate records, 239–241
copying and pasting, 231–233
deleting records, 234–235
display fonts, modifying, 239
editing techniques, 231
field display width, modifying, 237
freezing records, 242
gridlines, hiding/showing, 239
gridlines, modifying appearance of, 240
hiding/showing fields, 241macros, error handling (continued)
name of failed macro, 1073
Number property, 1073
OnError action, 1071–1073
overview, 1069–1070
mailing-label reports, 322–323
Make Table Query action queries, 671, 673
managed applications, 1136
manual filing systems versus computerized databases, 4–5
many-to-many table relationships, 110–111
margins of reports, specifying, 348–349
marking records with bookmarks, 866
mathematical operators. See operators, mathematical.
Max option, 657
Max Records property, 652
mcrBackupContactsAndProducts macro, 1054–1057
mcrDivisionErrorHandling macro, 1071–1073
mcrHelloWorldEnhanced macro, 1065
mcrMainMenu macro, 1058
mcrReportMenu macro, 1062–1063
mcrReportMenuEnhanced macro, 1067–1068
.mdb files, security, 752
Medium Date format, 63
Medium Time format, 63
Memo criteria, 193–195
Memo data, entering, 226–227
Memo data type
converting to Text, 58
indexing, 50
overview, 52
purpose, 48
sorting, 50
storage size, 49
Memo fields
data entry, 297
formatting, 64
indexing, 73
line breaks, inserting, 231
sorting, 147
memory, absolute speed, 856
memory errors, troubleshooting, 920
memory leaks, 874
menu bar for forms, specifying an alternative, 311
Menu Bar property, 311
MenuBar property, 683
menus. See also the ribbon.
removing, 913–914
shortcut menu defaults, specifying, 1090–1091
shortcut menu display, specifying, 109152_475348-bindex.indd 131052_475348-bindex.indd 1310 4/1/10 2:02 PM4/1/10 2:02 PM