How to create reminders?????

[ekta]

Hi All:

I am trying to create reminders for my database based on a field on one of my subform. Let me first explain what's goin on in my database.
As soon as the user open the database he has to enter his user ID and password to login. Once their password is authenticated, main menu opens which contains buttons for reports, forms, search engine.
Right now my database has just one form,Opportunities. Every user has records associated with them on this form. I have done some coding so that users can edit only their records by adding UserID field on this form.
This Opportunities form has a subform: Action_subform. Now every opportunity has actions associated with it that has to be completed by a specified date.
Action_subform has 3 fields:Action_Description, Action_Date, Closed. I want to see reminders based on this Action_Date.
Users should get reminders if an action is past due date and also reminders for actions due in next 7 days.

I was hoping just like users can edit just their records, they should be able to see reminders only for their records.
Right now they have to go to each and every record and then the subform to look for actions that need to be completed or which are past due.

Is it possible????

Thanx in advance
Ekta

 

[dcx693]

Sure you can do it all at once. Once the user enters his/her logon ID and password at startup, you can search for actions which are overdue, and if such, display them in a pop-up form.

You'll need to do some VBA coding, but it should be too bad. You don't mention the table structure in your database, so without going into specifics, the recordsource for the pop-up reminder form could be something like:
SELECT * FROM tblActions WHERE (UserID=the userID the person entered) AND (ActionDate<=Today).

You can make the pop-up box modal, so that the user cannot do anything in Access until they click OK to acknowledge it.

 

[ekta]

Thx for your reply dcx693 and Pat.

I get an idea but I will need more help. I would really apprecite it if you could tell me in more detail how to go about it.
When the user logs in my database I use append query to store his UserID in a table, tblUser.

The field, Action_Date, based on which reminders will pop-up is on a subform which is based on tblActionItem. My main form is based on tblOpportunities. The UserID field is on the main form not on the subform.

So first thing I need to do is to create a form. Then I need to figure out the SQL statement for the record source to display all the Action Items that r overdue or are due in 7 days. Right????

I think I will need some help with coding. Not really good at it.
Is there any sample database which uses reminders???

Thanx again
Ekta