Here's the Introduction and Table of Contents for Access Archon: Working with Word ...

Here's the opening pages of Access Archon: Working with Word. 

" Access is great for storing data, and of course you can display the data in reports, which is quite satisfactory for many purposes.  But if you want to create elaborately formatted documents filled with Access data, possibly with the option of user entry of more data on-the-fly, and especially if you want to produce separate documents to save in folders on your computer, the best method is to create Word documents from templates in VBA code, and fill them with data from Access.

There are four methods you can use to create Word documents filled with Access data, and each one has its advantages and disadvantages, as described in the next chapter.

 

This ebook is greatly expanded and updated from material in past Access Archon articles.  The material has been substantially updated by Helen Feddema herself for current versions of Access and Word including Word 2007 and Access 2007. 

Additionally, Helen has added some brand-new content.  Separate chapters describe how to create Word documents filled with Access data using Word document properties, bookmarks, the TypeText method, or mail merge. 

There is also a discussion of using Word form fields (or, for Word 2007, content controls) to allow users to entry additional data into documents produced from Access. 

Finally, Helen gives tips on debugging your VBA code.

About the Author

Helen Feddema has been the Editor of the popular Access Watch (www.office-watch.com) free email newsletter since it started in 2002, and before that she wrote the Access Archon column for Office Watch, since 1998.

Helen has written or co-authored a number of books on Access, as well as contributing articles to various print journals, such as Smart Access and Office Developer. 

 

Sample Databases and Code

The examples in this ebook are from one of the two sample databases that are included as attachments. 

Working with Word.mdb which is in Access 2002-2003 format,

Working with Word.accdb is the Access 2007 version of this database.

The VBA code is the same in both Office versions and is included in each database.

Sample Documents

For most of the document types, the same .dot templates are used for both versions of Office. 

However, since form fields were replaced by content controls in Word 2007, I have provided both a .dot (for Word 2003) and a dotx (for Word 2007) version of the Contact Response Letter template.

All the example files are included in this PDF file; see Examples and Code for more information in how to get the files.

Copying Code

If you want to use some of the sample code in your own database, don't attempt to copy it from this ebook (you can’t).  Instead, open the appropriate database (either the Access 2003 or Access 2007 version), and copy the code from the form module or standard module.  While you are in the module, check its references – you may need to set some of the non-standard ones in your database.

After copying the code, compile it to check whether any variables or references are missing.  See the References Window section in the Access Debugging chapter later in this book for more details on references.

Here's the Table of Contents for Access Archon: Working with Word:

"

• INTRODUCTION
  • Sample Documents
  • Copying Code
• FOUR WAYS TO MERGE ACCESS DATA TO WORD
  • Bookmarks
  • Document Properties
  • TypeText
  • Mail Merge
• CREATING A WORD INVOICE FROM LINKED TABLES
  • Word Custom Doc Properties
  • Code Techniques
  • Setting a Variable to Use the Current Word Instance
  • Using the FileDialog Object to Select a Folder
  • Using Database Custom Properties to Store Information
  • Testing for the Existence of a File in a Folder
• CREATING WORD DOCUMENTS USING DOCUMENT PROPERTIES
  • Creating a Letter to a Single Contact
  • Finding the UserName and UserAddress properties
  • Creating Documents for Multiple Contacts
  • Using the ItemsSelected Property of an Access Listbox
  • Getting Information from Columns of a Listbox
• CREATING WORD DOCUMENTS USING BOOKMARKS
  • Missing Addresses
  • Write to Bookmarks
• CREATING WORD LABELS USING TYPETEXT
• CREATING A WORD CATALOG MERGE DOCUMENT
• CREATING FORM LETTERS AND MAILING LABELS USING MAIL MERGE
• CREATING WORD DOCUMENTS WITH FORM FIELDS
  • Avoiding Error 4605
  • Content Controls vs. Form Fields
• ACCESS DEBUGGING TECHNIQUES
  • Using Variables
  • Declaring Objects
  • The References Window
  • The Object Browser
  • The Watch Window
  • The Immediate Window
  • Using Debug.Print Statements
  • Dealing with the Phantom Breakpoint Bug
• HELEN FEDDEMA’S BOOKS
  • Access™ 2007 VBA Bible for Data-Centric Microsoft Applications
  • Expert One-on-One Microsoft Access Application Development
  • Access 2002 Inside-Out
  • DAO Object Model: The Definitive Reference
• ENDNOTES
  • Ebook power
  • Examples and Code
  • Attachment Summary
    • Acrobat Reader v7, 8 or 9
    • Acrobat Reader v6
  • How to use the examples
  • Printing
  • How to get your Office Watch e-books
  • Merging accounts
  • Feedback
  • How we made this e-book
  • Revision History
  • Credits
  • Copyright Notice
• OFFICE WATCH EBOOKS
• APPENDIX
  • Click Event for Document Properties
  • Click Event for Bookmarks

.