Alarms

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
Back
Top