Reminder

[Linda]

Does anyone know if I put in a date that I need to be
reminded of something to do, can the record which contains
that date send some kind of reminder, or show that record
on that date without showing all the dates. I have a
machines that need maintenance throughout the year on
specific dates, (too many to remember) and I want to have
access tell me if there is anything on a date, but I don't
want to have to do a query on a date each day. Just
knowing this is a possibilty would be great, I could then
try to figure out how. Thanks

 

[Guest]

Yes Linda You can do this by doing and event procedure on open of your main
form. Say that if the date is like the date that you want your mantainance to
be done on then display a message box.

 

[John Vinson]

Does anyone know if I put in a date that I need to be
reminded of something to do, can the record which contains
that date send some kind of reminder, or show that record
on that date without showing all the dates. I have a
machines that need maintenance throughout the year on
specific dates, (too many to remember) and I want to have
access tell me if there is anything on a date, but I don't
want to have to do a query on a date each day. Just
knowing this is a possibilty would be great, I could then
try to figure out how. Thanks

Using a query with a criterion such as

=Date()

will show those records with today's date. Maybe safer would be

BETWEEN Date() AND Date()+3

to show the next three days (weekend) as well.

This Query could be displayed in a form which opens automatically
using the Tools... Startup options.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps