Opening Linked Word Template From Access Form

[Sparrow_ce]

My form contains a listing of linked Word templates for the user to choose from (based on a table with hyperlink fields). The Word templates have automation built in, with fillin’ fields and some have merge fields based on access table data. When the user opens the linked template from the access form, it opens the template as if you were opening from the file/open menu in Word instead of opening as file/new. This causes the automation in the form to not activate. I'm not finding on the Access side how to accomplish opening the Word document by the file/new method and do not know visual basic on the Word side. I am barely making my way through learning Access code by trial and error, and need help. Also, for the linked documents that contain merge fields that feed from the Access side - is there a way to automatically pass that access field data into the Word document when you open it so I can streamline some of the data gathering process. Thank you.

 

[Van T. Dinh]

Don't open the Template. Instead, create / open a new document based on the
Template. You probably used the New Event in the Template and opening the
Template won't activate the New Event.

--
HTH
Van T. Dinh
MVP (Access)

My form contains a listing of linked Word templates for the user to choose

from (based on a table with hyperlink fields). The Word templates have
automation built in, with fillin' fields and some have merge fields based on
access table data. When the user opens the linked template from the access
form, it opens the template as if you were opening from the file/open menu
in Word instead of opening as file/new. This causes the automation in the
form to not activate. I'm not finding on the Access side how to accomplish
opening the Word document by the file/new method and do not know visual
basic on the Word side. I am barely making my way through learning Access
code by trial and error, and need help. Also, for the linked documents that
contain merge fields that feed from the Access side - is there a way to
automatically pass that access field data into the Word document when you
open it so I can streamline some of the data gathering process. Thank you.

 

[Sparrow_ce]

Thanks, unfortunately I'm still not 'getting it'. Am looking for the code to create / open a new document based on a template, but not finding in Access. Since I don't know visual basic to write something into my Word templates, and am limping through any code writing in Access, I'm resigning myself to finding a plan "B" and taking the documents out of my form, as the automation in the documents is more important than the user having easy access to the file directory. Thank you so much for taking the time to help, I appreciate it.

 

[Albert D. Kallal]

Try download my sample mail merge code.

It does as you ask, and it even makes a "list" of documents for you. And,
even better is that you can make my code instantly active any access form
with one line of code, and the rest is done for you.

You can find this food on a silver platter solution free at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[Sparrow_ce]

Thank you so much! I have downloaded it and am working out the particulars for my project needs. Your sample merge code will allow me to bridge the gap with all the missing holes there were in combining all the processes/software tools to make one efficient program that will meet all the user needs in one place. Yesterday I was ready to concede in defeat after much searching & trial and error . . . today, got alot of details to work out, but the path is definately forward . . . thank you!

 

[Sparrow_ce]

Albert, I have been testing and working with your great database, however I'm finding 2 things I'm not able to overcome. Not because of the database, but because I want to change the work process. The sample worked great, but when I loaded my forms into the Word directory of my access directory, they showed up on the choose template screen, but when I chose to merge the file, Word opened, but no file opened with it. I can get it to open if I create a new template, copy my original template and paste it onto the new, but I have too many templates already created. In addition, I'm not seeing how to tell the fields I've got on my form where to go in the Word document. I'd like to pass the data on the form along to the Word document, but I'm missing something somewhere in my modifications. Any idea where I've gone wrong? Thank you.