Add sound to command button

[JMal]

I have a sound clip which I want to add to a command buttom.

I have use the "Docmd.Beep" on the unclick event but not very effective.

Is the other built in sounds in Access or can I add my own clip to a button.

 

[ProgramError]

I used the following in a vb program - not tested in vba tho

first the declaration

Private Declare Function sndPlaySound Lib "WINMM.DLL" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long
   Const SND_SYNC = &H0 ' stops playing and plays from start if called
   Const SND_ASYNC = &H1  ' plays sound from beginning to the end
   Const SND_NODEFAULT = &H2
   Const SND_LOOP = &H8  ' plays sound in a loop
   Const SND_NOSTOP = &H10

now the call to play the sound

Private Sub nameOfSub()
   Dim x%
   x% = sndPlaySound("c:\testsnd.wav", SND_SYNC Or SND_NODEFAULT Or SND_LOOP)
End Sub

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.