Alarms

[Guest]

I would like to create something in access so when certain dates expire that
I have in a table or query I get some kind of notice. Is this possible?

Thanks,
Kelli

 

[Wayne Morgan]

Create a form that you open hidden when you open your database. Set the
timer on this form to 60000 (once per minute). In the Timer event, run code
to check the table and pop-up a message box (or other action of your choice)
to inform the user if action is needed.

 

[Guest]

If it's not too difficult would you be able to go into a little more detail

 

[Wayne Morgan]

To open the form as a hidden form, place code in the Load event of your
startup form similar to:

DoCmd.OpenForm "MyTimerForm",,,,,acHidden

As far as creating the form goes, any form that remain open all the time
will work. It doesn't have to be a hidden form. The advantage of a hidden
form is that your user isn't likely to try and close it. The form wouldn't
need any controls on it, just the code in the Timer event.

Sample Code:
If DCount("[DateField]", "[MyTable]", "[DateField]<=" & Date) > 0 Then
MsgBox "There are records that need tending too!", vbOkOnly +
vbInformation, "Overdue Items"
End If