Reminder

  • Thread starter Thread starter landor
  • Start date Start date
L

landor

Hi,

I have designed a database for a friend who has to take meds at specific
times. I have a form so they can record what meds they have taken and at what
time.

Is there any way i can get a message box to open at 9,12,4 and 10 o'clock to
remind her to take her meds. She has the pc running constantly between these
times and usually has the DB running in the background.

I amm using Access 2007.

many thanks :)
 
Landor,

There are 2 approaches you could take here.

One is to use the Timer event of a form which is open (could be minimised or
hidden) at the time. Set the Timer Interval to (say) 300000 (i.e. 5
minutes). And use a macro that checks for the time in its Condition, and
uses a MsgBox action which will only open if the time condition is met.

An example of the Condition expression would be:
Time() Between #8:58# And #9:03#

The other approach is to use a Scheduled Task in Windows, or a third party
scheduling utility, so that the task is triggered at the required times.
The Command Line of the scheduled task would look something like this:
"C:\Program Files\... Path To Access ...\msaccess.exe"
"C:\YourFolder\YourDatabase.mdb" /x NameOfYourMacro
.... and then the macro simply shows the MsgBox
 
Many thanks Steve for a very precise reply. I went for option one and it
works a treat.

Very much appreciated

Landor
 
Back
Top