tools for scripts, 591–599
useful scripts, 603–619
VBScript Help File, 597–599
Windows Vista
Access add-in installation issues, 471–472, 508,
549, 550, 551–552
accessing SQL Server through firewall, 643–647
adjusting security settings, 471–472, 549–550
Explorer, 146, 149
running Visual Studio 2005 in, 565–567
Task Scheduler, 619–625
Windows XP, accessing SQL Server 2005 through
firewall, 640–642
WithEventsstatement, 443
wizards
Access add-ins as, 472–473, 479
construction tips, 482–483
Create ObjectsSetup Setup Wizard, 584–587
DSN Wizard, 665–669
Form Wizard add-ins, 479
Import Text Wizard, 307–310
Link Exchange/Outlook Wizard, 223
ODBC SQL Server Setup Wizard, 666–669
Report Wizard, 11–15
Shared Add-in Wizard, 564–565, 568–570
Task Scheduler, 622–625
Upgrade Wizard, 562
Wo rd
creating blank documents by using Automation
code, 27–28
creating fancy shipping labels, 397–415
creating new, blank documents based on default
template, 140–141
creating new, blank documents based on
selected template, 141–143
creating new, blank documents by using
NewDocfunction, 140–141
creating new, blank documents by using
NewDocFromTemplatefunction,
142–143
creating new documents based on WSH scripts,
614–615
Document Information Panel, 148file format differences, 31, 146
filling documents with Access data by using
TypeTextmethod, 27–30
importing Access data, 135–138
importing Access data using Automation code,
138–182
methods for merging Access data to, 145–182
Object Browser, 94, 139
opening by using CreateObjectfunction, 39,
44–45
sending letters to multiple Access contacts,
158–165
sending letters to single Access contacts,
150–158
setting User Templates folder path, 604–605
setting Workgroup Templates folder path,
604–605
user information fields, 31–33
using templates for creating formatted
documents, 30–45
version issues, 146
Word Catalog-type merge, 176
Word Export.accdb sample database, 138, 264
Word Mail Merge feature, Access, 136, 138
Word object model, 139–144
Word Options dialog, 604–605
Word properties sheet
Custom tab, 149
General tab, 148
Summary tab, 149, 150
Word (RTF) feature, Access, 136, 137
Word.accdb sample database, 27
workbooks versus worksheets, 183
Workgroup Templates folder
copying templates to, 603
setting path, 604–605
viewing path, 604–605
worksheets, Excel
code for creating from template, 54–55
code for saving and closing, 56–57
code for writing data, 55–56
creating from template in VBA code, 62–69
creating PivotCharts from, 417–418Index W
25_047026 bindex.qxp 4/2/07 9:58 PM Page 699