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.

--
Wayne Morgan
MS Access MVP


"Kelli McCann" <(E-Mail Removed)> wrote in message
news:35657772-2F03-4D12-A89D-(E-Mail Removed)...
>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?

If it's not too difficult would you be able to go into a little more detail
on the steps that I need to take to create this hidden for...I have never
done that before.

"Wayne Morgan" wrote:

> 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.
>
> --
> Wayne Morgan
> MS Access MVP
>
>
> "Kelli McCann" <(E-Mail Removed)> wrote in message
> news:35657772-2F03-4D12-A89D-(E-Mail Removed)...
> >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?
>
>
>

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

--
Wayne Morgan
MS Access MVP


"Kelli McCann" <(E-Mail Removed)> wrote in message
news:AB8C7A57-FB82-49DC-8C48-(E-Mail Removed)...
> If it's not too difficult would you be able to go into a little more
> detail
> on the steps that I need to take to create this hidden for...I have never
> done that before.