Idh

Val function, 50, 51, 56, 66, 134 Validation programming patterns, 51 Value, arguments passed by, 152, 177, 178 Value List, 105

Value property, 50, 51, 83, 156 VALUES clause, INSERT INTO statement and, 231 Variable naming conventions, 56-57 Variables, 52-56, 66

declaring, 53, 165-166 increment/decrement expressions and, 99 Variable scope, VBA support for, 57-58 Variable value, 210 Variant data type, 130, 131 Variant variable, 311

VBA (Visual Basic for Applications), 25, 35, 147, 239 arithmetic and order of operations, 59-60 breaking out of infinite loop in, 98 command bars in, 313 common data types in, 53 looping structures supported by, 97 option statements, 58-59 setting object references in, 303-304, 323 variable naming conventions in, 57 variable scope, 57-58 VBA code, accessing, 25

VBA IDE. See VBE

VBA statements, categories of, 40-41 VBA Toolbox, combo and list boxes from, 103, 104 VBE (Visual Basic Editor), 37, 65 accessing, 37

components within, 38-39 debugging facilities, 181, 182 VBE code window keyboard shortcuts for, 351-352 object and events accessed from, 40 Visible property, 37, 112 Visual Basic, 35, 85, 147, 239 Visual Basic Editor. See VBE Visual Basic for Applications. See VBA Visual C++, 239 Void function, 149 Volatile memory, 55

0 0

Post a comment