1309
Index
named, 556
naming, 1052
new features, 1256, 1263–1264
purpose of, 10
on ribbons, 1256
settings, 937
specifications, 1249
SQL Server conversions, 1234
temporary variables, 1065–1069
tracking, 552
versus VBA, 382
versus VBA statements, 1077–1078
macros, actions
cursor, changing to hourglass, 1054–1055
Echo, 1055, 1056
hiding/showing macro results, 1055, 1056
Hourglass, 1054–1055
incompatibilities, 1177–1178
macro error handling, getting, 1073
for mcrBackupContactsAndProducts macro,
1054–1057
MessageBox, 1055
messages, displaying, 1055
opening a query, 1055, 1056
OpenQuery, 1055, 1056
SetWarnings, 1054–1055, 1056
system messages, enabling/disabling, 1054–1055, 1056
macros, debugging
debug window, 1074
error information, displaying, 1074
MessageBox action, 1074
Single Step dialog box, 1074
stepping through code, 1074
StopMacro action, 1074
stopping macro execution, 1074
macros, error handling
ActionName property, 1073
arguments, getting, 1073
Arguments property, 1073
condition, getting, 1073
Condition property, 1073
Description property, 1073
error message, getting, 1073
error number, getting, 1073
macro action, getting, 1073
MacroError object, 1073–1074
MacroName property, 1073
mcrDivisionErrorHandling macro, 1071–1073latency, 768–769
overview, 768–769
LockType parameter, 769
LogEvent action, 560–561
logging errors, 560–561
logical errors, 820
logical operators. See operators, Boolean.
logical values. See Yes/No data type.
login forms, 910–911
logos, adding to forms, 695
Long data type, VBA, 428
Long Date format, 63
Long Integer size numeric fields, 52
Long Time format, 63
look and feel, consistency, 1094–1095
lookup errors, 1174–1175
lookup field issues, 1175, 1178
Lookup Wizard data type, 49, 54
LookupRecord action, 560
looping through recordsets, 560. See also branching.
losing compiled state, 850–851
LostFocus event, 457, 460
lowest/highest field values, finding, 657M
m:, formatting month of the year, 63
Macro Designer, 553–562
macro editor, new features, 1264
macro recorder, 808–810
MacroError object, 1073–1074
MacroName property, 1073
macros. See also data macros; submacros; VBA; specific
macros.
arguments, 1050
assigning to events, 1052–1054
bulletproofing, 934–938
code compatibility, 552
conditions for execution, 1061–1064
converting to VBA, 382–384, 1078–1080
creating, 1050–1052
definition, 10, 1049
embedded, 552, 1075–1077
error handling, 552
errors, 1177–1178
groups, 557
Hello World example, 1050–1052, 1065–1069
limitations of, 378, 552
multi-action, 1054–105752_475348-bindex.indd 130952_475348-bindex.indd 1309 4/1/10 2:02 PM4/1/10 2:02 PM