Access play sound file

Access lets you play a sound for any form event. For example, to have a sound play when a form is opened, follow these steps:. Check out the Microsoft Access archive and catch up on other Access tips. Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

For example, to have a sound play when a form is opened, follow these steps: Open the Form in Design View. Go to View Project Explorer. Insert New Module. On the form's Property sheet, click in the OnOpen event box on the Event tab. Click the Build button and then enter the code below at the prompt. Be sure to use the full pathname to your sound file. Playsound "C:IChimes. Editor's Picks. Carefully follow the steps below which are listed in sequence. Expand Select Wrap Line Numbers. Declare Function sndPlaySound Lib "winmm.

Code after the Sound function 'will immediately be executed. Follow Post Reply. I'm interesterd in the enhancements - please share!!! The 2 enhancements that I had previously referred to are: See if the User's System is capable of playing. WAV files. If it returns 0, then no capability exists to play. The Declaration is listed below and its usage will be in the complete code listing.

Cool - the training database in my office now plays the theme tune from Team America when anyone presses a button I thought it'd be funny, no one else does! I share your sense of humor also.

Databases can be a little cut-N-dry - I'll try anything, including a little sound, to liven them up! They're all trying to figure out whats going on it's hilarious! I'm on holiday next week - will fix it when I get back haha. I'm on holiday next week - will fix it when I get back haha I know exactly what you mean. I once created an Inventory System for a Department and once they realized that they could incorporate Sound functionality into the Database, they wanted to use it.

Everytime an incorrect entry was made in a Field, an audible rejection Sound was heard by everyone in the Department.

In this case, the use of Sound was not a good thing. It did, however, cut done on Invalid Entries but did nothing for employee morale and didn't make me the most popular person in the area.

Just follow the guidelines in Post 1 for the basic approach. Nice topic you got. Where will i encoded the commands in Post 1? In a Standard Code Module. Post Reply. Similar topics Javascript. WindowsXP and Javascript to play a sound on a page. Start play of Object sound in MZ. I use an Access table to house sounds. I need just a wee bit more help Access is using something to play audio files. How can I find out what it is?

How can I play "standard system sounds" in C? Visual Basic. Play wavs in VB Play the next track when the current one finishes. How to play a sound from an embedded resource file?