V


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




Microsoft Office Access 2007 Inside Out
MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
ISBN: 0735623252
EAN: 2147483647
Year: 2007
Pages: 234

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net