Automated Notification

[Agent Smith]

place alarm

i have a clients data base were i want to place this event:

whenever a client aniversary date come say within a week's time plays an alarm, or pops up awindow, where displays name or names of clients and aniversary dates.

please shed light on this subject.

many thanks to every one on this forum

Smith. from Portugal.

 

[neileg]

Write a query that calculates the difference between today's date and the anniversary date and use a criterion of 1 to 7 days. Build a form based on this query and set this to open when you open the database (or on any other event you want to trigger the form).

 

[Agent Smith]

If you would help me

I very much would appreciate:

if you could give an hint on how to build the code and where to place it.

i'm very newbie on code, to make the query calculate a sum i know how, but operations whith date are diferent...

thanks alot on the hint to build the query

Smith Portugal

 

[neileg]

Sorry for the dealy - been busy.

You don't need any code. Just create the form based on the query. Then in the startup options for the database, set this form to open when the database opens.

The query should pull the relevant dates and whatever other info you need. Then in the criteria part of the grid enter:
Between Date() And Date()+7
This will retrieve the dates that are today or up to seven days ahead.

The only code you might want is to open another form, like your switchboard, when you close the anniversary form. You need to build an event procedure in the On Close event. If you don't know how to do this, you could use a macro to open your form and link this macro to the On Close event.