Index_V

V

validation rule errors, 338

value list row source, comboboxes, 86

values, arguments, 370

Var function, 128

var tag (variant), 293

variable type tags

discussed, 291

strSearch, 54

variables. See also objects

appOutlook, 256

basOutlookAutomation, 473

blnSomeSkipped, 445

cboCategoryID, 92–93

cboExportType, 521

cboFilterField, 455–456

cboFilterValue, 87–89

cboMergeType, 385

cboRecipients, 280

cboSelectDataSource, 505

cboSelectOutlookItem, 452

cboShipAddressID, 85

cmdClose, 232

cmdEmailReport, 472

cmdImportDatafromOutlookItem, 483

cmdSave, 232–233

data types and, 288

declaring, 443

FirstNameFirst, 67

fmnuMain, 55

fraRecord, 454

fraShippingMethodID, 83

frmEmployees, 232

frmEmployeesActiveXControls, 117

frmEmployeesCalendar, 113

frmImageControls, 110

frmImportFromExcel, 146

frmNewEmployee, 232

frmOrders, 81

fsubContactsAll, 454

fsubSearchResults, 241

fsubShippingAddresses, 60

gappExcel, 503

gappWord, 371

intResponse, 93

lblSubstitute, 181

lblTitle, 181

MaterialID, 76

MaterialName, 76

pstrFilterField, 456

pstrQuery, 456–457

qmakContactsConcatenated, 145

qryContactsAlpha, 86

qryFilteredContacts, 237

qryOrders, 134

ShippingMethodID, 65

strFilter, 240

strQuery, 403

strSearch, 265

strTitlePlus, 319

subTable, 485–486

tblCategories, 14, 43

tblContactsSeparate, 123

tblContactsWhole, 122

tblCustomerEMails, 43

tblCustomerPhones, 43

tblMailingList, 23–24

tblMailingListCompanies, 137

tblMaterials, 26

tblOrders, 28

tblRepairs, 27

tblRepairsMaterial, 43

tblShippingMethods, 28

tblTargetSeparate, 124

tblVendors, 14

tlkpForms, 210

tlkpLetters, 278

tlkpOutlookItemTypes, 440

tlkpReports, 210

tmakMatchingRecords, 459

txlsMailingList, 137

txtCaptionRH, 180

txtContactName, 276

txtDateRange, 181

txtEmail, 59

txtMessageText, 441

txtPageTotal, 186

varItem, 95

Variant data type, 404

variant tag (var), 293

varItem variable, 95

VBA. See Visual Basic for Applications

VBS (Visual Basic Script), 428

V-Comm Web site, 251

vendors

tblVendors variable, 14

VendorID fields, 20

VendorProductID (Tables wizard), 13

View menu commands, Subform in New Window, 64

viewing object model

Excel, 499–502

Outlook, 426–430

Word, 366

viruses, security features, 492

visibility controls

borders, 72

reports, 327

Visible property, 197

Visual Basic Editor button, adding to Access toolbar, 365

Visual Basic for Applications (VBA)

discussed, 3

Help topic, 216

Immediate Window, 214

Module Pane, 215–216

module types, 217

Project Explorer, 213

properties sheet, 214

Visual Basic Script (VBS), 428