GetScreentipMso method, 140
GetSupertipMso method, 140
GetUserName function, 290
GetVisibleMso method, 140
global variables, 15, 17
See alsovariables
got focus event, 89
H
HasDataLabels property, 236
“Hello World” code, 9–11
Hour function, 60
Hourglass method, 214
Hwnd property, 203
I
icons, for message boxes, 66–67
If..Then..Else statements, 36
images
in forms, 109
on ribbons, 138
implicit declaration, 14
indexes, creating, 315–316
instant watch mode, 82–84
Instr function, 48–49
InstrRev function, 49
Int function, 49–50
interactive controls, 349–353
Is operator, 79
IsDate function, 19
IsEmpty function, 19
IsNull function, 20
IsNumeric function, 19
K
key combinations, 259–262
key down event, 88
keys
special keys not normally displayed, 65
See alsoSendKeys command
L
large text files, 307–311
LCase, 47–48
Left function, 47
Len function, 49
Like operator, 79–80
Linked Table Manager, 245–246
list boxes, in forms, 109
local variables, 15–16
See alsovariables
locking databases, 284–287
locking projects, 283
logic errors, 82
logical operators, 75–79
login IDs, 279–280
See alsoauthorized users
looping
Do Until loops, 42
For Each loops, 41–42
early exit of loops, 43
For..Next loops, 40–41
overview, 40
While..Wend loops, 42–43
lost focus event, 89M
macro applications, 5
Macro Editor, 3–4
macros, vs. modules, 3–4
Make Table query, 158–159
See alsoSQL queries
Maximize method, 214–215
Me object, 201
ActiveControl, 201
AllowAdditions property, 202
AllowDeletions property, 202
AllowEdits property, 202
AllowFilters property, 202
Caption property, 202
Dirty property, 202
Filter property, 203
Hwnd property, 203
Picture property, 203
Printer property, 203
RecordSource property, 203
Refresh method, 203
Repaint method, 203–204
Requery method, 204
RibbonName property, 204
ScrollBars property, 204
SetFocus method, 204
Undo method, 204–205
Visible property, 205
menu structures, creating with the ribbon,
345–348Index 369