Automatic reminders in Access?

[JDRoss]

Dear Tek Tips

I have three tables with Contributions. I would like to run a query for Year to Date on each one when the database is open and if the total from the three exceeds $250 then to remind the user that these people have to be contacted?

I am thinking of a pop-up-window.

Any ideas before I go reinventing the wheel?

Much appreciated

John

 

[checkOut]

a little Idea: it's the way I handle a same kind of problem:
I think ContactID, Contribution, Date are the three fields in the three query's It shouldn't be hard to make a union select query and sum these on Contribution (when it is, u can come back)

U can automate the action to run the query before u close the database.
strSQL = "SELECT ContactID, Contribution FROM qryAutomationContribution"
rst.open strSQL, cnn, ....

if .bof then
exit sub
else
while not .eof
SendEmailFaxLetterContact(.field("ContactID&quot,.fields("Contribution&quot)
.movenext
wend
Public Sub SendEmailFaxLetterContact(lngContact as long, CurrContribution as Currency)
'code for searching emailadres consist, or faxnumber consist or adress consist
'so make an email with fctnOutlook (search the archive of tek tips on this phrase
'or set a template for fax or letter
end sub

When u have all emailadresses u can completely automate it, also when u have WinFax Pro, but else u can print the faxes or letters and send them by hand to the contacts
or even u can choose to print a list of contacts with their phonenumbers.

Possibilitys enough, it's a little work to make this working. When u can't understand this u can send ur database and I implement above statement for u.

Greetz
gerard
gerard@westplant.nl

 

[JDRoss]

Thanks Checkout for the ideas on select union. These tables do not have email addresses, so what I would be interested more in is how to automate Word, for example, or a report withing Access to print out a letter to them.

Regards

John