Article ID: 95647 - View products that this article applies to.
This article was previously published under Q95647
Advanced: Requires expert coding, interoperability, and multiuser skills.
Microsoft Access does not have a built-in function to play sound files on events, such as when a form is opened or closed. However, you can use the Microsoft Windows 3.1 application program interface (API) through Access Basic code to create a user-defined function to play sound files.
This article assumes you are familiar with Access Basic and Windows APIs. In this article, the use of error trapping has been omitted to keep the information as clear and concise as possible.
For additional information about how to record and play sounds in Access 95, Access 97, or Access 2000, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/149119/EN-US/ )How to Record and Play Sounds from MS Access (95/97)
(http://support.microsoft.com/kb/210067/EN-US/ )ACC2000: How to Record and Play Sounds from Microsoft Access
Follow these steps to create a user-defined function to play sound files:
When the form is open in Form view, you can play the sound by clicking the command button. You can assign this function to the form's OnOpen property if you want chimes to play when you open a form.
NOTE: This example does not have error trapping. Unexpected results may occur if the sound file is not in the location specified or does not exist.
If the sound (.WAV file) is in the table as an OLE field, the sound can be added to the form out of the field list. You can then use a macro that does a GoToControl [olefield], DoMenuItem form-edit-object- <verb>. You can run this from a button on the form. It will go to the OLE field and edit the object (the default edit is play for a sound).
Microsoft Access "Introduction to Programming," Chapters 1-5
"Microsoft Windows Software Development Kit," Microsoft Press, 1992
"Programming Windows: the Microsoft Guide to Writing Applications for Windows 3", Charles Petzold. Microsoft Press, 1990
"Programmer's Reference Library: Microsoft Windows 3.1 Guide to Programming Reference," Volumes 1 - 6, Microsoft Press, 1992
Article ID: 95647 - Last Review: May 9, 2003 - Revision: 2.0