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
ListTableFieldsfunction, 497–499
ListTableFieldsprocedure, 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
CreateProjectTasksfunction, 253–254
exporting Access table data to, 247–249
exporting to Access tables, 250–251
ExportTasksToOutlookfunction, 247–249
importing from Access, 72–78
ImportTasksFromOutlookfunction, 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–610creating 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
CreateItemFromTemplateobject, 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
NewDocFromTemplatefunction, 142–143
using for creating formatted documents, 30–45
Test Ribbon.accdb sample database
defined, 521
form Ribbons, 547–549
ListTableFieldsprocedure, 542–545
TestFileExistsfunction, 59
TestForwardReadOnlyprocedure, 116–117,
128–129
TestKeysetOptimisticprocedure, 110,
122–125
TestMethodSupportedprocedure, 118–121
TestStaticReadOnlyprocedure, 125–127
text files
ADO method, 291
comma-delimited, 282
exporting data in VBA code, 320–324T Index
25_047026 bindex.qxp 4/2/07 9:58 PM Page 694