Automatic notification of expiry date

[hdgirl]

I have a form that holds records of peoples training certificate with a field stating when the cert expires. At present every month i create a query asking the field for expiry date + 30 days so that i know who's cert will expire within the next 30 days. How can i

a)Get these record to appear in a new form

or

b) Have automatic notification that expiry is due within the next 30 days

CJB

 

[loony22]

I have the same problem With a little change :

In my DB there is Expiration date of a cretin product. Whenever the date has expired I would like that a MsgBox will appear:
"Product has expired. Would u like to update his Information? "
If the user clicked yes it will go to the form and allow the user to change the Product details. If the user pressed no, the MsgBox will be closed.

The very importent thing is that the MsgBox will appear WHENEVER the program is running. No matter where the user is, no matter in which form/Report is running.

 

[KenReay]

Hi

This is similar response to probelm posted above

This an idea I have not tried it!

Have a form which opens at start up, but has visible property false.

In the start up form an ontimer event in this form which fires (say) every 2 minutes.

When the OnTime Event fires, run a query based on Expirydate and the date now (Date()).

If any records are returned, display message box etc

Regards Ken Reay
Freelance Developer
kenneth.reay@talk21.com