Reminders

[jonamua1971]

i have searched on this forum but so far am not finding the answer.
i have a database and i would like to have a reminder to events .
i have a form in which we have to indicate the place a person goes to.
i need to set a reminder if the person does not the minimum visits in a month.
we need at least three visits or outings in a month per person. i would the reminder to pop up 10 days before the end of each month.
sorry, i am still learning how to do codes. please help me with codes if you can.
i thank all for your help , i have learnt a lot from this forum that i did not learn in class.

 

[The_Doc_Man]

This starts with a startup form that runs when you first open the database. Look at Access Help on startup forms.

The next step is to have a "sequence of events" table that lists things someone should do. The table should include WHO is supposed to do it and WHEN. The WHEN part can be single-shot with fixed date or repeating with a particular day of the month. The startup form needs to query this table, probably means some VBA code to get a list of what events are due for this person. The format of the WHO part depends on whether you are using Workgroup security to log in or have done something else. For workgroups, CurrentUser() is your current username. For other methods, there are some Environment calls that give you the network name of the user. Whatever you use, be consistent.

Now the next step is that to determine what is due, you need to look up the DateDiff function which you can use to decide whether each event is not yet due, due today, overdue, or hopeless.

Finally, you need to tie in this events table with the list of things that people HAVE done to see if you can remove the entry (if single-shot) or update the due date (if recurring) from the "due events" list.

This is broad-brush because I don't like to make too many assumptions about what you have in the database, formatting- or structure-wise. Look up anything in here that you didn't recognize by trying Access Help files first.

 

[jonamua1971]

thanks for yor quick reply.
i dont know how do this going by what you have said. my problem is that i have my database splitted and its been used. can i add a table like you said to the back end??.
how about the forms? do i have to add this individual to all the places i have the front ends? am abit confussed.
question.
can i add the sequence and all you have told me to the people's table?
thanks