How to Link a Sound Wav File to a Button

[neelsfer]

I would like to link a wav sound file to a button in my Access 2007 application. Has anybody got code to do it?
Its for a race timing application and i want to have a "gunshot" sound when the athletes take off at start of race.
pls help

[ADezii]

Copy both the Demo Database and the Gunshot.wav File in the Attachment to the same Folder. It doesn't matter where the Folder is, as long as the *.mdb and *.wav reside in the same Folder. Open the Database, then Click on the Command Button. Let me know how you make out.

[neelsfer]

can i use it with the Access 2007 format -noticed you used .mdb file in message about it?

[ADezii]

I can't see why not.

[neelsfer]

i have this problem. See attached screenpic. Changed the button to your button name. I changed the soundfile and that works in your example in my directory that i use.It just refuses to make any noise in my application. any suggestions?

[ADezii]

Do you have the following Declarations in a Standard Code Module?

Declare Function sndPlaySound Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long
 
Public Const SND_ASYNC = &H1
Public Const SND_SYNC = &H0
Public Const SND_LOOP = &H8

[neelsfer]

working 100% thx you are STAR!!

[ADezii]

You are quite welcome.