validating data.
See also validation rules
check constraints for SQL Server, 1478–1480
with macros, 928–934
steps executed when, 929
types of invalid data, 928–929
using macro group, 929–934
using preset values, 935–938
in Visual Basic, 1071–1080
checking for overlapping data, 1078–1080
checking for possible duplicate names, 1071–1073
maintaining special unique value constraint, 1077–1080
testing for related records when deleting record, 1074–1075
verifying prerequisite before saving record, 1075–1077
Validation Rule property, 168, 670
validation rules
about, 7
action query violations of, 512
checking new field, 381–382
comparison symbols in, 169
control, 670
defining table, 175–178
sample table, 176
specifying for fields, 165, 168–170
testing new table, 382–384
unsupported in SharePoint Services, 1219
using Between, In, and Like comparison operators, 360–361
Validation Text box (Properties dialog box), 1472, 1474–1475
Validation Text property, 670
values
macro actions setting, A109
viewing list of valid property, 575
Var function, 437
variables
assigning object, 991–993
CurrentDb function to set database, 989
declaring for text stored procedures, 1531–1532
examining in Watch window for errors, 956–959
global, 961
temporary, 907–910
about, 907
compatibility of .mdb databases with, 910
creating, 908–909
macro example using, 933–934
passing information between linked forms with, 934–935
removing and deleting, 909–910
syntax for, 909
Visual Basic, 961–978
adding data-type prefix to name, 966
data types supported, 961–963
defining data type with data-typing characters, 962
defining scope of, 963–964
implicit/explicit data type definitions, 962–963
VBE. See Visual Basic Editor (VBE)
VBScript, 1128, 1158
versions
Access compatibility with earlier, 1358–1359
checking database, 1327
keeping installations of multiple Access, 1348–1349
required SQL Server software for projects, 1448
SQL modifications by earlier Access, A61
upgrading previous Microsoft Office, 1347–1349
vertical I-bar, 802–803
vertically
moving one or more controls, 621
selecting all controls, 588, 600
View By submenu (Navigation Pane), 76
View tab (Properties window), 1512–1513
viewing
complete list of macro actions, 892
data in forms, 539
filter icon in ScreenTip, 408
HTML behind Web page, 1128
hyperlinks, 397–398
list of valid property values, 575
module objects in database, 942–943
project table relationships in Diagram window, 1486
query data in various ways, 10–11
relationships defined for tables or queries, 187
reports in Print Preview, 736, 737–739
SQL Server table indexes, 1472
static Web pages, 1139–1140
trusted publishers, 37
views.
See also Datasheet view;
Design view;
Form view;
Layout view
creating Windows SharePoint Services, 1172–1175, 1191
displaying properties for query, 1510–1513
formatting form properties to restrict user’s, 670–671
options for overlapping or tabbed document, 109
project
creating in query designer, 1495
reason for using, 1507–1508
working with as query, 1493
working with, 1507–1513
project file, 135
sorting and selecting Navigation Pane, 76–77
Views button, 110
Visual Basic (VB), 941–1124.
See also Visual Basic Editor (VBE)
assisting data entry, 1053–1071
filling in related data, 1053–1057
fixing e-mail hyperlink, 1061–1062
handling NotInList event, 1058–1061
providing graphical calendar, 1063–1068
working with linked photos, 1069–1071
automating complex tasks, 1105–1114
calculating stored value, 1114
linking to related task, 1098–1099, 1109–1114
triggering data task from related form, 1105–1109
automating data selection, 1082–1097
filtering one list with another, 1095–1097
multiple-selection list boxes, 1082–1086
providing custom query by form, 1086–1093
selecting from summary list, 1094–1095
automating reports, 1114–1124
drawing border on report, 1118–1121
dynamically filtering report on opening, 1121–1124
using up partial page of mailing labels, 1115–1118
automating XML import and export in, 1256–1260
class modules, 1009–1016
Property Get procedure, 1010–1012
Property Let procedure, 1012–1014
Property Set procedure, 1014–1016
understanding, 1009–1010
code disabled when downloaded to untrusted locations, 1225
coding routines in modules, 130
collections, objects, properties, and methods
assigning object variable, 991–993
object methods, 993–1005
object model hierarchies organizing, 978–987
referencing collections, objects, and properties, 987–989
referencing in variables created by macros, 991
setting database variable with CurrentDb function, 989
using exclamation points and periods in names, 989–990
controlling flow of statements, 1016–1026
Call statement, 1017
Do…Loop statement, 1017–1018
For…Next statement, 1018–1019
For Each…Next statement, 1019–1020
GoTo statement, 1020–1021
If…Then…Else statement, 1021–1022
RaiseEvent statement, 1022–1023
Select Case statement, 1023–1024
Stop statement, 1024
While…Wend statement, 1025
With…End statement, 1025–1026
controlling tabbing on multiple-page form, 1080–1082
debugging, 951–960
call stack, 959–960
preventing, 1312, 1328
setting breakpoints, 951–952, 957
using Immediate window, 952–956
working with Watch window, 956–959, 960
examples of complex code, 1030–1050
examining all error codes, 1044–1050
randomly loading data, 1030–1044
executing Access commands, 1027–1028
functions and subroutines, 1005–1000
about, 1005
Function statement, 1006–1007
list of functions on companion CD, 371
Sub statement, 1007–1009
linking to data in other form or report, 1098–1094
linking forms with filter, 1098–1099
linking to report with filter, 1099–1101
synchronizing two forms with class event, 1101–1104
macros
converting to VB, 938–940
equivalents for macro actions, 1028
executing macro actions, 1026–1027
using procedures instead of, 1052–1053
using with VB, 890, 1052
modules, 942–944
form and report, 944
module objects, 942–943
relationship between Access and, 942, 950
resetting Page property value with, 833
trapping errors in, 1028–1030
validating complex data, 1071–1080
checking for duplicate names, 1071–1073
maintaining special unique value constraint, 1077–1080
overlapping data checks, 1078–1080
testing for related records when deleting record, 1074–1075
verifying prerequisite before saving record, 1075–1077
variables and constants, 961–978
data types supported, 961–963
declaring, 965–978
naming conventions for variables, 966
scope of, 963–964
writing HTML from, 1154–1158
Visual Basic 2005 Express Edition, 1261
Visual Basic Editor (VBE)
about, 942
customizing in Options dialog box, 948
illustrated, 945
indenting VB coding, 948–949
opening
with Build button in event property, 906
and displaying modules in, 131–132
setting database options in, 198,199
user interface for, 945–950, 1161
Visual Basic Scripting Edition (VBScript), 1128, 1158
Visual FoxPro
importing data from, 266–270
ODBC drivers required to import, 269
specifying source for tables with IN clause, A46, A47
working with tables in Access, 268
Visual FoxPro-to-Access data type conversions, 270
Visual Studio, 664,1161
Visual Studio .NET, 1131, 1160–1161