Access VBA Macro Programming

local variables, 15–16
module-level variables, 16
name conflicts, 17
overview, 13–14
scope and lifetime of, 15
shadowing, 17
strict variables, 17
user-defined types, 24–25
See alsoconstants; data types
variants, 18–19
Date/Time values stored in, 19
empty value, 19
Null value, 19–20
VarType, 18
VBA
as an object-oriented language, 7
using in ribbons, 138–140
using on forms, 111
using on reports, 120

VBE.SeeVisual Basic Editor

Version, 201

Visible property, 205

Visual Basic Editor, 4–6

W

WAV files, 263

Weekday function, 62

While..Wend loops, 42–43

X

Xor operator, 78–79

Y

Year function, 61

Index 373