Need to print document based on database - HELP!

[Debased]

I have a database with data entry forms for doing audits on physician offices. Once the audit is completed and scored I need to issue a corrective action plan based on deficient items identified in the audit. Currently, this is done by using a hard copy 53 page MSWord document. Only the pages that contain the deficient items are removed from the document and given to the office. What I would like to do, is based on the deficient items, print out the selected sheets of this document. I have thought about having the document entered into a table and then create a report based on the deficient items selected. However, as I stated above, this is a large document and because it contains a lot of graphics and tables it would probably need to be entered (though only once) manually into a table.

Any suggestions about how to go about this would be appreciated. I was wondering if code could be written which would open and print selected pages from the Word document. I do not know how to begin to do this so any help is much appreciated.
Hopefully I have given enough information here for you to make sense of this project!
Thanks again in advance!

 

[The_Doc_Man]

Access has three ways to create documents with Word.

1. Create a report containing what you want and export it to an .RTF format, which tends to be primitive. But you can define label boxes in headers to hold your narrative lumps, or whatever.

2. MailMerge to a Word Template (which, for a single patient, might be what Word calls a 'catalog' merge). The more fields you have to deal with, the worse this gets.

3. Write VBA code to open a Word application.

The problem with #1 is you lose most of the formatting capabilities, and that might not be what you wanted.

The problem with #2 is how much data we are talking about. The more you have, the harder it is to create the Word merge template.

The problem with #3 is that, though it is the most flexible, it is also the most difficult to write.

As to importing data from a Word document, only option 3 above makes sense if we are talking 'direct import' operations. Before anyone takes you down that garden path, the question is whether you feel confident enough in your VBA to tackle this project.

 

[Debased]

Thanks for your reply Doc.

I did a search on this site and came up with this link which looks like what I can use.

http://www.access-programmers.co.uk...light=open+word