T

tab XML element adding to Ribbon, 517

built-in Access Ribbon names, 519

defined, 522

removing from Ribbon, 518-519 Table object, Word, 139 TableDef object, 130, 482 TableDefs collection, 106-109

tables, Access adding attachment fields, 391 converting to SQL Server tables, 649-657 creating programmatically, 107, 109 denormalized, 352-359 exporting as Word RTF file, 136-137 hidden, making visible, 630 linked, denormalizing, 352-359 linking to Outlook data, 221-229 ListTableFields function, 497-499 ListTableFields procedure, 542-545 loading manually, 545-547 loading programmatically, 553 refreshing contact data, 361-374 tables, SQL Server, linking to data, 662-671 tables, Word, creating by importing from Access,

136-137 Tables collection, 139 table-type recordsets, 100-101, 130 Tag property, 467, 468 Task List form, 230-231 Task Scheduler, Windows Vista creating tasks, 622-625 Daily Database Backup.vbs script, 619-620 opening, 620-621 overview, 619 tasks, Outlook

CreateProjectTasks function, 253-254 exporting Access table data to, 247-249 exporting to Access tables, 250-251 ExportTasksToOutlook function, 247-249 importing from Access, 72-78 ImportTasksFromOutlook function, 250-251 linking folder to Access tables, 223-224 Tasks1.accdb sample database, 229 TCP/IP, 637 templates, Access categories of, 228 COM add-in, 436-440 CopyAllTemplates.vbs script, 610-611 CopyTemplateUser.vbs script, 603, 607-608 CopyTemplateWorkgroup.vbs script, 603, 608-610

creating databases from, 225-229 New Document from Template.vbs script,

614-616 new in Access 2007, 230-233 User Templates folder, 603, 604-605 Workgroup Templates folder, 603, 604-605 templates, Excel for charts, 423

creating new worksheets from, 62-63 using to create formatted worksheets filled with data, 52-62 templates, Outlook

CreateItemFromTemplate object, 236 saved, opening, 237-238 templates, Word

Contact Letter with Envelope (Bookmarks)

template, 165 creating by placing bookmarks where Access data should appear, 31-39 creating by placing DocProperty fields where

Access data should appear, 39-45 default folder, 36, 37, 43-44 .dot template format, 31, 146 .dotx template format, 31, 146 file formats, 31, 146 inserting content controls into, 45-48 NewDocFromTemplate function, 142-143 using for creating formatted documents, 30-45 Test Ribbon.accdb sample database defined, 521 form Ribbons, 547-549 ListTableFields procedure, 542-545 TestFileExists function, 59 TestForwardReadOnly procedure, 116-117, 128-129

TestKeysetOptimistic procedure, 110, 122-125

TestMethodSupported procedure, 118-121 TestStaticReadOnly procedure, 125-127 text files

ADO method, 291

comma-delimited, 282

exporting data in VBA code, 320-324

FileSystemObject method, 292, 296 fixed-width, 282, 315 free-form, 282

importing data in VBA code, 312-320 methods for working with VBA code, 290,

291-292,296 reading data from, 292-297 sending as email attachments, 348-350 types, 282

using TransferText method, 306-323 writing data to, 282-292 TextStream object, 282, 292 timesheets cmdClearTimesheet_Click procedure, 207 cmdSaveTimesheet_Click procedure, 207-208

CreateExcelTimesheets function, 211, 212-218 engineering firm example, 202-218 filling in Access forms, 202, 203-211 frmWeeklyTimesheet form, 202, 203-211 overview, 202

qryNeedTimesheets query, 202 qryThisWeeksTimesheets query, 202 transferring Access data to Excel, 211-218 txtEmployeeID_DblClick procedure, 209-211 titles. See also renaming for add-ins, 502 assigning to PivotCharts, 421 save names for worksheets, 195 TodayDate document property, 157 TransferDatabase method,327, 330 TransferSpreadsheet method and comma-delimited text files, 282 defined, 184, 305

in ExportAccountSummary procedure, 195, 196, 201

exporting Access data to Excel, 62, 184, 186 importing Lotus 1-2-3 data to Access, 328 TransferText method, 282, 306-311, 316,

317, 342 TransferToExcel function, 186

troubleshooting

Access add-ins, 503-507 add-ins, 506-507 COM add-ins, 466-467 Trust Center, 508-509 trusted locations, 508-509

txtEmployeeID_DblClick procedure, 209-211 TypeText method advantages and disadvantages, 146 defined, 28

FillWithTypeText procedure, 28-30 MergeTypeText procedure, 170-175 as method for filling Word documents with

Access data, 27-30 as method for merging Access data to Word, 146,170-175

0 0

Post a comment