C

calculated fields, in queries, 370-371 calendar, Outlook importing appointments from Access, 72-78 linking folder to Access tables, 224 working with appointment data, 241-247 calendar pop-up, 52, 53, 320 Callback function, 263, 264 certificates, digital creating for signing VBA code, 398-402 why not to create for Access add-ins, 511 Chart templates, 423

charts. See PivotCharts, Access; PivotCharts, Excel circular references, 11 Class property, 240 client/server applications, 657-662 Clipboard, 3

cmdAttachmentsFolderPath_Click procedure, 358-359

cmdCancel_Click event procedure, 483-484 cmdClearData_Click procedure, 315, 322, 329-330

cmdClearTimesheet_Click procedure, 207 cmdClick procedure, 154-157 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 role in exporting database and spreadsheet files, 336-338

role in exporting HTML and XML data, 343-344

role in exporting text data, 323-324 cmdInputDocsPath_Click procedure, 265-266 cmdInspectJobs_Click procedure role in exporting text data, 330-332 role in importing text data, 316-317 cmdInspectNewJobs_Click procedure, 324 cmdLoadData_Click procedure, 294-296 cmdMergetoEmailMulti_Click procedure, 348-350

cmdOutputDocsPath_Click procedure, 266-267 cmdReorderInventory_Click event procedure, 431-432

cmdSaveJobs_Click procedure, 317, 332-333 cmdSaveTimesheet_Click procedure, 207-208 cmdSourceFile_Click procedure, 333-334 cmdSourceTextFile_Click procedure, 318-319 cmdSQL (SQL commands), 113 cmdWord_Click procedure, 154-157 code. See Automation; Visual Basic for Applications (VBA)

CodeDB syntax, 481, 482 Collect Data group, 220-221 columns, report adjusting width, 17 default alignment, 17 COM add-in template, 436-440 COM Add-ins dialog, 465-466, 587 COM (Component Object Model)

comparing add-ins with Access add-ins, 469 creating add-ins using Visual Basic 6.0, 436-467

creating LNC Control Renaming add-in, 440-463 customizing add-ins, 438-440 installing add-ins, 463-466 selecting add-in template, 436-440 troubleshooting add-ins, 466-467 using add-ins, 467-468 comboBox XML element, 522 comma-delimited text files in cmdExportJobs_Click procedure, 323 creating import specifications by using

TransferText method, 306, 316 versus fixed-width text files, 315 importing, 312-320

and TransferSpreadsheet method, 282 and TransferText method, 282 Command object, 113-116, 130 command-bar buttons adding in code, 447-448 AddToCommandBar function, 440 CreateFormCommandBarButton function, 443

CreateReportCommandBarButton function, 443

DeleteFromCommandBar function, 440 deleting, 450

RemoveAddInCommandBarButton function, 443

returning references to, 448-449 role of OnConnection event procedure, 443 comments, VBA versus VBScript, 601, 603 CommonDialog control, 263, 264 Company and Contact Information form, 355-357 ComplexType object, 97 Component Object Model (COM)

comparing add-ins with Access add-ins, 469 creating add-ins using Visual Basic 6.0, 436-467 creating LNC Control Renaming add-in,

440-463 customizing add-ins, 438-440 installing add-ins, 463-466 selecting add-in template, 436-440 troubleshooting add-ins, 466-467 using add-ins, 467-468

concatenation, for exporting Access data, 143-144 Connect class module, modifying, 573-575 Connection object, 110-113, 130 Contact Documents folder, 141, 142 contact IDs, code for updating in Access, 388-390 contact information comparing Outlook and Access contacts,

359-390 synchronizing, 353-354 Contact Information form, 353-355 Contact Letter with Envelope (Bookmarks)

template, 165 Contact Letters (Mail Merge) document, 176 Contact List form, 231-232 Contact List (Mail Merge) document, 176 contacts, Access code for updating, 382-391 copying data to Outlook, 374-391 ExportContactsToExcel procedure, 191-195

multiple, sending Word letters to, 158-165 qryContacts query, 191 removing completely, 376 single, sending Word letters to, 150-158 contacts, Outlook code for updating, 376-382 CopyAccessContactsToOutlook procedure, 390

CopyAllOutlookContactsToAccess procedure, 390 copying data to Access, 374-391 ExportFlatFileContactsToOutlook function, 255-258 exporting Access table data to, 255-258 exporting to Access tables, 259-262 ImportContactsFromOutlook function, 259-262

ImportOutlookContacts function, 361-365, 390

linking to Access tables, 224-225 removing completely, 376 Container object, DAO, 98

content controls, inserting into Word templates, 45-48

ControlCA function, 456-457 ControlCS function, 454-456 ControlNA function, 459-461 controls adding to Ribbon, 517 bound, 11, 16, 52, 320, 453-454, 468, 472, 482

built-in Access Ribbon names, 521-531 finding names for use in XML code, 518 grouping, 17

LNC Control Renaming COM add-in, 440-463 LNCRenameFormControls function, 443, 450-453

LNCRenameFormControls_Click event procedure, 443 LNCRenameReportControls function, 443, 453

LNCRenameReportControls_Click event procedure, 443 naming convention, 11, 16 renaming, 440-463, 467 saving old names, 467-468 ControlSO function, 457-459 CopyAccessAttsToAccess procedure, 394-395 CopyAccessAttsToOutlook procedure, 391-392 CopyAccessContactsToOutlook procedure, 390

CopyAllOutlookContactsToAccess procedure, 390

CopyAllTemplates.vbs script, 610-611 CopyFile method, 282 CopyObject method, 109, 482 CopyOutlookAttsToAccess procedure, 392-393 CopyTemplateUser.vbs script, 603, 607-608 CopyTemplateWorkgroup.vbs script, 603, 608-610 Create Chart dialog, 424-425 Create New Data Source dialog, 665 Create ObjectsSetup Setup Wizard, 584-587 Create PivotTable with PivotChart dialog, 417-418 CREATE TABLE statement, 109

CreateAndTestQuery function, 58-59, 104-106 CreateCTT function, 461-463 CreateDenormalizedContactsTable function,

366-374,382,390 CreateExcelTimesheets function, 211, 212-218 CreateField method, 109 CreateFormCommandBarButton function, 443 CreateItem method, 236 CreateItemFromTemplate object, 236 CreateNewForm procedure, 579-580 CreateNewReport procedure, 580-581 CreateNewTable procedure, 578-579 CreateNewWorkbook function, 187-188 CreateObject function in Excel object model, 187, 188 in Outlook object model, 234, 236 when to use, 28, 39, 74, 602 in Word object model, 138, 139 CreateProjectApps function, 245-247 CreateProjectTasks function, 253-254 CreateReportCommandBarButton function, 443 CreateTable statement, 482 CreateTableDef method,107, 109 CreateTextFile method,292 CurrentDb method,99, 481 CurrentWeekEnding function, 203, 204 cursors, ADO recordset, 117, 118, 119-120 customUI XML element, 522

0 0

Post a comment