Microsoft Access 2010 Bible

1311

Index

for forms, 457

for objects, 455

MouseDown event, 455, 460

MouseMove event, 455, 460

MouseUp event, 455, 460

MouseWheel event, 455

Moveable property, 308

MoveNext method, 497–498

MovePrevious method, 497–498

moving

Access tables to SharePoint, 1127–1131

controls, 271–272, 274–275

fields, 57

forms, enabling, 308

macro items, 572–573

text boxes on reports, 354–355

MsgBox function. See also error messages.

confirming deletions, 470–471

constants, 916

debugging technique, 534–535

informational messages, 915–918

parameters, 915–916

return values, 918

multi-action macros, 1054–1057

Multiple Items button, 260–261

Multiple Items command, 253

multiple-item forms, 260–261

MultiRow property, 702

multi-tiered architecture, 1192–1194

multi-value fields, data macros, 575

N

n:, formatting minutes, 64

Name Autocorrect options, 1084, 1091–1092

Name property, 285, 407

named arguments, 447–448, 808

named macros, 556

naming conventions

class modules, 974–975

collections, 407

compound object names, 40

controls, 285–286

databases, 8, 29–30

descriptive names, 40

duplicate names, 39

fields, 45, 47–48

fields and tables, automatic correction, 1091–1092

form controls, 285–286

highlighting alternate records, 239–241

protected fields, 231

rearranging fields, 235–236

record display width, modifying, 238

replacing existing values, 230, 233–234

resizing field width, 237

resizing record height, 238

saving changes, 242

undoing changes, 231

modules

absolute speed, 862–866

database objects, 10

forms, 390

report, 390

SQL Server conversions, 1234

standard, 389–390

versus VBA procedures, 380

modules, class. See also events; OOP (object-oriented

programming); Product class.

adding to databases, 974–975

bulletproofing property procedures, 980–981

defining objects, 972–973, 978–980

for forms, displaying, 311

methods, 976–978

naming, 974–975

overview, 973–974

properties, 975–976

modules, VBA

creating, 391–392

definition, 380

editing, 393

form, 390

Option Explicit directive, 394

versus procedures, 380

report, 390

sections, 394

standard, 389–390

types of, 389–391

variable declarations section, 394, 427

Modules tab, 539, 543–544

monetary data type. See Currency data type.

Month property, 362

More Forms command, 252

morphing

controls, 695–696

forms or reports, 868

mouse events

for controls, 460

definition, 452

52_475348-bindex.indd 131152_475348-bindex.indd 1311 4/1/10 2:02 PM4/1/10 2:02 PM