Play A Sound Clip when Record Appears

[Shane Grunewald]

Hi;

I have created a database that requeries an underlying
query on a form every five seconds. On this form, there
are two subforms. I would like the database to play a
sound clip when there is a record displayed in one of the
subforms. This would get the attention of the user that
there is something that needs to be done in the database.
The only reason I want it to play the sound is that the
user can multitask such as doing e-mail, etc. Does anyone
have a method of creating a macro or explain how to enter
VB code to have it play a sound?

Any help would be greatly appreciated.

Thank you,
Shane

 

[Graham R Seach]

Shane,

You can play a sound using this
http://www.pacificdb.com.au/MVP/Code/Sound.htm.

AFAIK there's no way to determine when a bound query finishes executing, but
you could use the main form's Timer event to periodically check how many
records are in the subform(s).

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia