Chapter Creating Standalone Scripts with Windows Script Host

Tools for Working with Windows Script Host Scripts 591

The Microsoft Script Editor 592

The VBScript Help File 597

Differences between VBA and VBScript Code 599

Useful Scripts 603

Setup Scripts 603

Office Scripts 611

Miscellaneous Scripts 616

Scheduling a Backup Script with the Windows Vista Task Scheduler 619

Summary 626

Chapter 18: Working with SQL Server Data 627

Getting SQL Server 2005 628

Preparing an Access Database for Upsizing to SQL Server 629

Configuring SQL Server 2005 for Data Access 631

Getting through the Firewall 640

Windows XP 640

Windows Vista 643

Other Security Roadblocks 647

Using the Upsizing Wizard 648

Converting Access Tables to SQL Server Tables 649

Creating a Client/Server Application 657

Linking to Data in SQL Server Tables 662

The SQL Server Migration Assistant for Access 671

Summary 672

Index 673

Many thanks to my technical editor, Mary Hardy, for catching errors and making many valuable suggestions that improved the quality of the book (and sample databases), and to editors Kelly Talbot and Brian Hermann for their suggestions and support.

Welcome to the Access 2007 VBA Bible. Like all books in the Bible series, you can expect to find both hands-on tutorials and real-world practical application information, as well as reference and background information that provides a context for what you are learning. This book is a fairly comprehensive resource on writing VBA code to exchange data among the main Office applications (Access, Word, Excel, and Outlook), using Access as the central application for storing data, and using the other applications for producing attractively formatted documents of various types. By the time you have completed the Access 2007 VBA Bible, you will be well-prepared to write VBA Automation code that uses your Access data to produce Word letters, mailing labels and other documents (without the overhead of mail merge), to create Excel worksheets and PivotCharts, and to create Outlook appointments, mail messages, contacts, and journal items, with or without attachments. Additionally, you will be able to synchronize contact data (both ways) between Access and Outlook.

0 0

Post a comment