Set Clock Time Alarm in a Form

[rkalapura]

I have a Network Access 2010 database, which has many forms and many people use these forms at a time. Many of the users requested me to put time alarms at different time like 10:00 AM, 1:00PM and 3:00 PM etc. in the form. These are the company break time which normally people un-notice due to the heavy and busy work schedule. I do have analog and digital clocks running on every forms in the database, but it won't help them out. If they get a beeping alarm on the form, they can utilize their break in time.

Is there any built in facility / function available in Access 2010 to set a beep alarm? I really appreciate if any body help me and guide me to do this.

Thank you

[June7]

There is the form Timer event. Warning: Timer event is supposed to be resource hog.

Review
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://vbcity.com/forums/t/108886.aspx

Form needs to remain open.

[rkalapura]

Thanks for assistance. How do we set the sound file to hear alarm?

There is the form Timer event. Warning: Timer event is supposed to be resource hog.

Review
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://vbcity.com/forums/t/108886.aspx

Form needs to remain open.

[June7]

You can either:

1. DoCmd.Beep

2. Review http://www.cpearson.com/excel/PlaySound.aspx