Creating thank you letter & receipt in Access database

[Digital Carnage]

Hi Folks,
I'm starting to create a new access database for my church here in town
and it's focus is to track donations made by individuals, companies, other
churches or non profs. I've got my design layed out pretty nicely and I'm
confident in most of how I'll finish the forms and reports. But... I've
never done a database that after you record a transaction, you can have the
ability to print a thank you letter with the correct person's name on it or
even an invoice. Any preliminary suggestions anyone? Thanks

 

[Paul Overway]

Before you get too far down the road, you might want to look on my web site.
;o)

Nevertheless, what you are trying to do is create a mail merge document.
There are a variety of ways to go about this, but one way is to create a
query and use the OfficeLinks|Merge it with Word option from the database
toolbar.

 

[Digital Carnage]

Thanks Paul,
I'll check out your website for more details. I appreciate your
response. Rich

 

[Albert D. Kallal]

The invoice part should be a report. You can place a buttion on your form
witht he follwing code to print only the current reocrd:


me.refresh
docmd.OpenReport "your report",acViewPreview,,"id = " & me.id

For the letter, grab my sample word merge at:

 

[Albert D. Kallal]

Opps, hit the send key..sorry...lets try again:

The invoice part should be a report. You can place a button on your form
with the he following code to print only the current record:


me.refresh
docmd.OpenReport "your report",acViewPreview,,"id = " & me.id

For the letter, grab my sample word merge code at:

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


The above code allows you to send only the CURRENT reocrd to a word merge
doc. I have a working sample, and you should give it a try.