Alarm sound & pop up

[Moss100]

Hello,

I have a field on a continuous form called STARTDATE. This contains a date and time.

When the date and time matches present time I would like it to pop up a message and sound an alarm. Anyone any ideas how this could be achieved??

Many thanks, mark.

 

[PHV]

I'd use the OnCurrent event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Moss100]

If I have a list of records on a continuous form, I think the on current event would only fire for the first record. Thanks though.

 

[dhookom]

If you don't want this to trigger when a record is the current record, then tell us exactly when it should trigger? Also, do you realize the time format can be about 1/10 or 1/100 of a second? Does the date and time have to be exact?

Can you give us a business reason for this?

Duane
Hook'D on Access
MS Access MVP

 

[Moss100]

The program I am writing is a diary / scheduler.

Typically there may be 15 appointments in a day.

I have a continuous form with say 15 appointments on at different times in the day.

I would like to set an alarm to go off at the time of each appointment.

Many thanks, mark

 

[dhookom]

This is what Outlook or other scheduling programs can do for you. If you want to do this in Access, you could open a hidden form with a timer event running. The code would need to look at all of the appointments to determine if any are happening within a specific time range based on the current time. You can use Now() as the current datetime. You might need to be able to "dismiss" an appointment by storing something in a field in the appointments table.

Duane
Hook'D on Access
MS Access MVP