Invoke reminder

D

dk

Hello everybody !
Your help is allways usefull, so I asking You to help me again.
I have table Services with field NextContactDateTime. User shall put into
date and time when the client should be contacted.
Id like to open form "Reminder" in specified time, something like reminder
from Outlook Calendar.

Thank You in advance

DK
 
G

Guest

Use the form load event on the form which the users puts the date time in.
Everytime it opens have it check the difference between NOW and the date in
that field. Once it reaches a predetermined time before the appointment (say
two weeks / one week ?) then you can invoke a msgbox reminder.
 
D

dk

Thanks to Your replay.
Logic is OK, but that is not a point.
Reminder shall be started not depending of form user has oppened. something
like
If now()=ReminderDateTime then docmd.openForm "reminder"
This code must run in background of application, not in the background of
particular form.

Thanks
Damir
 
G

Guest

Can't you run your macro at database startup time using an AutoExec macro ?
You'd only want to check once a day wouldn't you ?
 
D

dk

No, code should be active all the time user running database. When current
time reach first time noted in field ReminderDateTime then form shall be
oppened.

DK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

msgbox reminder every 25th 16
Generate a Calendar Reminder 1
Outlook-like Calendar 6
Reminder (Off / On) Link With Reminder Data/Time 3
Reminder Form Pop Up How to Turn Off if No Reminders. Need Code. 5
Creating A Reminder Date 3
Please help: Send object when argument satisfies 1
MS Access setting outlook reminders from a DAO recordset 0

Top