Access form field data to custom Word template?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dmc - 28 Jun 2005 20:36 GMT

I have developed 4 sequential Access forms to collect and calculate
information for a monthly report. Alot of the information is calculated
right in the form, since most of it is not neccessary to keep in this
database. I just want the offices to be able to produce this form and pull a
few bits of info needed from a database here. I need to push all this form
data to a Word Custom Template I have residing in the same place on the
network. I have tried Mail Merge their is no way to merge the form data with
the frm! fields(Is there??)I have looked for VBScript and tried to write a
module. I need some help.

Reply to this Message

Doug Robbins - 28 Jun 2005 22:22 GMT

Take a look at the information on fellow MVP Albert Kallal's website at

http://www.members.shaw.ca/AlbertKallal/wordmerge/index.html

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have developed 4 sequential Access forms to collect and calculate
> information for a monthly report. Alot of the information is calculated
[quoted text clipped - 8 lines]
> the frm! fields(Is there??)I have looked for VBScript and tried to write a
> module. I need some help.

Reply to this Message

dmc - 29 Jun 2005 00:46 GMT

> I have developed 4 sequential Access forms to collect and calculate
> information for a monthly report. Alot of the information is calculated
[quoted text clipped - 5 lines]
> the frm! fields(Is there??)I have looked for VBScript and tried to write a
> module. I need some help.

>Doug,
>Many thanks for your time and help, I have been asking for some help with this for awhile. My knowledge is limited but continues to grow, through quality people like you who are willing to take the time. I am sure I will be back, thank you again.

dmc

Reply to this Message