Access.2007.VBA.Bibl..

Visual Basic for Applications (VBA) (continued)

ImportApptsFromOutlookfunction, 243–245

ImportContactsFromOutlookfunction,

259–262

ImportOutlookContactsfunction, 361–365,

390

ImportTasksFromOutlookfunction, 250–251

IsLoadedfunction, 631

ListCompanyprocedure, 102

ListTableFieldsprocedure, 542–545

ListValuesprocedure, 103

LoadAttachmentsfunction, 299–302

LoadCustomUIfunction, 553

LoadRibbonsfunction, 553–554

MailMergeTextFileprocedure, 177,

178–182

MergeBookmarksprocedure, 165–169

MergeDocPropsprocedure, 160, 161–164

MergeTypeTextprocedure, 170–175

naming projects, 463, 503–504

NewDocfunction, 140–141

NewDocFromTemplatefunction, 142–143

NewTableprocedure, 106–109

Nzfunction, 601

OpenRecordsetCommandprocedure, 113–116

OpenRecordsetSQLprocedure, 111–113

OpenSpecificWorkbookfunction, 189–190

SaveAttachmentsfunction, 302–304

SaveNofunction, 501

SetPropertyfunction, 499–500

SplitFileNamefunction, 395

TestFileExistsfunction, 59

TestForwardReadOnlyprocedure, 116–117,

128–129

TestKeysetOptimisticprocedure, 110,

122–125

TestMethodSupportedprocedure, 118–121

TestStaticReadOnlyprocedure, 125–127

TransferToExcelfunction, 186

txtEmployeeID_DblClickprocedure,

209–211

UpdateAllAccessContactsprocedure,

382–391, 390

UpdateAllOutlookContactsprocedure,

376–382, 390

versus VBScript code, 599–603

Visual Basic Script (VBS)

CopyAllTemplates.vbs script, 610–611

CopyTemplateUser.vbs script, 603, 607–608

CopyTemplateWorkgroup.vbs script, 603,

608–610

DailyDatabaseBackup.vbs script, 619–625

Delete Audible Files.vbs script, 616–619

Help file, 597–599

and Microsoft Script Editor, 592–596

New Document from Template.vbs script,

614–616

PrintInvoice.vbs script, 612–614

PrintReport.vbs script, 611–612

Rename Files.vbs script, 618

scheduling backup script, 619–625

versus Visual Basic for Applications, 599–603

Visual Studio

customizing Access Ribbon with shared add-in,

559–589

running in Windows Vista, 565–567

Shared Add-in template, 563

viewing references in Solution Explorer,

570–572

XML Editor, 525, 526

Visual Studio Tools for Office 2005 (VSTO),

563–565

W

Windows Firewall Settings dialog, 643–644, 647

Windows operating system

accessing SQL Server 2005 through firewall,

640–647

history of data transfer techniques, 3–4

version issues, 627–628

Windows Script Host (WSH)

Microsoft Script Editor, 592–606

office scripts, 611–616

overview, 591

setup scripts, 603–611

V Index

25_047026 bindex.qxp 4/2/07 9:58 PM Page 698