1338
Index
nonexistent data, 71
required data, indicating, 70
Required property, 70
specifying, 49
unknown data, 71
Validation Rule property, 69
Validation Text property, 69
zero-length data, allowing, 70–71
validating user input, 928–929
Validation Rule property, 60, 69
Validation Text property, 60, 69
Value property, 702
values, definition, 8
values, inserting in
datasheets, 231
forms, 231
values, replacing in
datasheets, 231
forms, 231
Var option, 657
variable declaration, forcing
Option Explicit directive, 394
Require Variable Declaration option, 411, 431,
527–528
variable declarations section, VBA modules, 394, 427
variables. See also temporary variables; VBA, variables.
grouping by data type, 531–532
out of context, 528
in scope, displaying, 544–545
values, displaying, 529
variables, absolute speed
changing, 864
comparing, 864
control variables, 864–865
field variables, 865
unused, removing, 866
variables, debugging
displaying variables in scope, 544–545
forcing variable declaration, 527–528
help, 543–544
out of context, detecting, 528
values, displaying, 529
Variant data type, VBA, 428, 430
variant variables, 423–424, 428, 430
VBA (Visual Basic for Applications). See also data access with
VBA; data macros; macros; OOP (object-oriented
programming).
converting macros to, 1078–1080
event properties, 387Use Windows-Themed Controls check box, 1084, 1088
user considerations
application delivery, 905–907
ease of starting, 907–909
forms, displaying one at a time, 914
information flow, 912–915
installation tools, 906
login forms, 910–911
menus, removing, 913–914
messages, 915–918
Navigation Pane, hiding, 913–914
Overlapping Windows interface, 915
passwords, hiding, 911
progress meters, 918–919
ribbons, 912–913
splash screens, 911–912
start-up options, 909–912
switchboard forms, 912
Tabbed Documents interface, 914
understanding user needs, 904–905
user-interface style, choosing, 914–915
Windows shortcuts, 907–909
User DSN, 1204
user input, validating, 928–929
user interface
About box, 1097–1098
consistent look and feel, 1094–1095
design decisions, 1094–1095
legal notices, 1097
new features, 1253–1258
Office Compatible certification, 1095
pictures, 1097
plagiarism, 1095
revealing, 985
splash screens, 867–868, 911–912, 1095–1097
switchboards, 912, 1097
user name, getting, 956
user-defined functions, server database engines, 1188
user-interface style, choosing, 914–915
USysRibbons table, 1029–1032V
validating data
AllowZeroLength property, 70–71
business rules, enforcing, 69
date/time data, limiting to a range of dates, 70
error messages, 69
input, 69–7052_475348-bindex.indd 133852_475348-bindex.indd 1338 4/1/10 2:02 PM4/1/10 2:02 PM