V

variables data typing, 601 naming convention, 11 Object type, 236 VBA versus VBScript, 601 VB 2005 Express, 562 VB 2005 XML Editor, 518-519, 525, 526 VBA. See Visual Basic for Applications .vbs file format, 592 VBS (Visual Basic Script)

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 Printlnvoice.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 visible XML element, 522

Visual Basic. See also Visual Basic for Applications (VBA)

AccessDesigner module, 444-463 AddInErr procedure, 441, 442 AddToCommandBar function, 440 command-bar buttons, 447-450

ControlCA function, 456-457 ControlCS function, 454-456 ControlNA function, 459-461 ControlSO function, 457-459 CreateCTT function, 461-463 CreateFormCommandBarButton function, 443

CreateReportCommandBarButton function, 443

creating COM add-ins by using VB 6.0, 436-467

DeleteFromCommandBar function, 440 LNCRenameFormControls function, 443, 450-453

LNCRenameFormControls_Click event procedure, 443 LNCRenameReportControls function, 443, 453

LNCRenameReportControls_Click event procedure, 443 naming projects, 463, 503-504 OnConnection event procedure, 443 OnDisconnection event procedure, 443 referencing projects to object libraries by using

VB 6.0, 438-439 RemoveAddInCommandBarButton function, 443

SharedCode module, 439, 440-442 StripCharm function, 441 using legacy code for working with text files, 292, 296 Visual Basic for Applications (VBA)

Access add-in code requirements, 481-482

AddInErr procedure, 581

ADO object model versus DAO object model,

89, 91-96, 110, 130 ArchiveData procedure, 53-58 argument styles, 102 BackupDB function, 279-281, 282 BackupFrontEnd function, 489-491 Callback function, 263, 264 callback procedures for Ribbon command buttons, 542-547

cmdAttachmentsFolderPath_Click procedure, 358-359 cmdCancel_Click event procedure, 483-484 cmdClearData_Click procedure, 315, 322,

329-330

cmdClearTimesheet_Click procedure, 207 cmdCreateDocuments_Click procedure, 159-160

cmdCreateEMails_Click procedure, 283-290

cmdCreateLabels_Click procedure, 405-413

cmdDeselectAll_Click procedure, 164-165 cmdDocProps_Click procedure, 43-45 cmdExportJobs_Click procedure, 323-324,

336-338, 343-344 cmdInputDocsPath_Click procedure,

265-266

cmdInspectJobs_Click procedure, 316-317,

330-332

cmdInspectNewJobs_Click procedure, 324 cmdLoadData_Click procedure, 294-296 cmdMergetoEmailMulti_Click procedure, 348-350

cmdOutputDocsPath_Click procedure,

266-267

cmdSaveJobs_Click procedure, 317, 332-333

cmdSaveTimesheet_Click procedure, 207-208

cmdSourceFile_Click procedure, 333-334 cmdSourceTextFile_Click procedure, 318-319

cmdWord_Click procedure, 154-157 CopyAccessAttsToAccess procedure, 394-395

CopyAccessAttsToOutlook procedure, 391-392

CopyAccessContactsToOutlook procedure, 390

CopyAllOutlookContactsToAccess procedure, 390

CopyOutlookAttsToAccess procedure, 392-393

CreateAndTestQuery function, 58-59, 104-106

CreateDenormalizedContactsTable function, 362-369, 382, 390 CreateExcelTimesheets function, 211, 212-218

CreateNewForm procedure, 579-580 CreateNewReport procedure, 580-581 CreateNewTable procedure, 578-579 CreateNewWorkbook function, 187-188 CreateObject function, 28, 39, 74, 138, 139,

187, 188, 234, 236, 602 CreateProjectApps function, 245-247 CreateProjectTasks function, 253-254 creating digital signature for signing code, 398-402

CurrentWeekEnding function, 203, 204 ExportAccountSummary function, 195-200 ExportAppointmentsToOutlook function, 241-243

ExportContactsToExcel function, 191-195 ExportFlatFileContactsToOutlook function, 255-258 ExportNorthwindData procedure, 62-69 ExportTasksToOutlook function, 247-249 ExportTransactions function, 79-81 Extras add-in code, 483-499 ExtrasOptions function, 486-488 FillDatecontrols procedure, 204, 205 FillWithTypeText procedure, 28-30 formatting Excel worksheets, 62-69 Form_Load procedure, 484-485 GetCustomUI function, 574 GetDocumentsPath function, 413-414 GetInputDocsPath function, 267-268 GetObject function, 28, 74, 138, 139, 187,

234, 236, 602 GetOutputDocsPath function, 268 GetProperty function, 500 history, 4

Visual Basic for Applications (VBA) (continued)

ImportApptsFromOutlook function, 243-245 ImportContactsFromOutlook function, 259-262

ImportOutlookContacts function, 361-365, 390

ImportTasksFromOutlook function, 250-251 IsLoaded function, 631 ListCompany procedure, 102 ListTableFields procedure, 542-545 ListValues procedure, 103 LoadAttachments function, 299-302 LoadCustomUI function, 553 LoadRibbons function, 553-554 MailMergeTextFile procedure, 177, 178-182

MergeBookmarks procedure, 165-169 MergeDocProps procedure, 160, 161-164 MergeTypeText procedure, 170-175 naming projects, 463, 503-504 NewDoc function, 140-141 NewDocFromTemplate function, 142-143 NewTable procedure, 106-109 Nz function, 601

OpenRecordsetCommand procedure, 113-116 OpenRecordsetSQL procedure, 111-113 OpenSpecificWorkbook function, 189-190 SaveAttachments function, 302-304 SaveNo function, 501 SetProperty function, 499-500 SplitFileName function, 395 TestFileExists function, 59 TestForwardReadOnly procedure, 116-117, 128-129

TestKeysetOptimistic procedure, 110, 122-125

TestMethodSupported procedure, 118-121 TestStaticReadOnly procedure, 125-127 TransferToExcel function, 186 txtEmployeeID_DblClick procedure, 209-211

UpdateAllAccessContacts procedure, 382-391,390

UpdateAllOutlookContacts procedure,

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 Printlnvoice.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

0 0

Post a comment