How do I auto transfer one record of a form in access to word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GR - 30 Jun 2006 02:42 GMT

I am looking to transfer one record at a time out of access in to a word
template (fax template). I would like to be able to do this by pressing only
one button on the form - how do I do this?

Reply to this Message

John Nurick - 30 Jun 2006 06:20 GMT

One way is with the "Super Easy Word Merge" at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

>I am looking to transfer one record at a time out of access in to a word
>template (fax template). I would like to be able to do this by pressing only
>one button on the form - how do I do this?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

GR - 30 Jun 2006 07:54 GMT

Dear John,

This is a great little program and it is "nearly" working but for some
reason it cannot find the template I have created. You do mean to create a
.dot template don't you? I am putting it in the same location as the
database is filed, is there maybe a way to browse for the template so that
access can find it?

Thank you,

Gwen

> One way is with the "Super Easy Word Merge" at
> http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
[quoted text clipped - 7 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message

GR - 30 Jun 2006 08:06 GMT

Sorry, I think I should have given you more information. The error I get
when I try to create a template is as folows:

Run-time error '5174'
This file could not be found
Try one or more of the following:
Check spelling of the name of the document
Try a different file name

I have already checked that Microsoft DAO 3.6 Object library is set in the
references window.

Argh.....so close yet so far!

Cheers,

Gwen

> One way is with the "Super Easy Word Merge" at
> http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
[quoted text clipped - 7 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message

GR - 30 Jun 2006 08:21 GMT

Apologies John, I was having a blonde moment and since I am blonde, I have a
fair few. I have now got this to work - it really is cool!

Is there any way I can add a calculated field in to this merge document too?

Kind Regards,

Gwen

> One way is with the "Super Easy Word Merge" at
> http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
[quoted text clipped - 7 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message

John Nurick - 30 Jun 2006 10:52 GMT

Hi Gwen,

Probably the thing to do is to create a query containing the calculated
field.

> Apologies John, I was having a blonde moment and since I am blonde, I
> have a
[quoted text clipped - 19 lines]
>>
>> Please respond in the newgroup and not by email.

Reply to this Message