Alarm function

Joe8915

Registered User.
Local time
Today, 14:53
Joined
Sep 9, 2002
Messages
820
Running MS 20007
Split DB, SQL in BE
Secured (user must sign in DB)
The following is what I am trying to accomplish:
Alarm type function for a form to pop up when the user is log into the database, when a particular date is due for a report.
I would like for the user be able to use the check Box, if done or snooze. I have added to another date field, if the user would like to extend to another date.
My thoughts for this would be 1 table, 1 query, and 2 forms. One form to run from the query and one form for the pop up.
I just can’t seem to make it work. I don’t know how to trap a particular user when they sign on, since the database is split.
I have the query completed I think.
I have attach a the sample DB
 

Attachments

Users who are viewing this thread

Back
Top Bottom