Automating Word from Access

[Jerry Anderson]

I have a form with several check boxes that constructs a connection string
and executes the string, thereby opening the appropriate Word document. I
want to prevent users from making and saving changes to this original
document; rather, I want it to be automatically saved to another location
upon opening and before allowing modifications. Any ideas?

 

[Albert D. Kallal]

My merge code will do this for you....

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the following page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try.

The merge commands also allow you to specify the output document..and thus
the users will not be editing the original...