how can i play a 'wav' file in access 2007

[markgascoigne]

does anyone know how to play a 'wav' file in access 2007. All i want to do
is play a 'wav' file when two conditions are met?

 

[Damon Heron]

Try this:
Function PlaySound(Soundfile As Variant)
PlaySound = Shell("sndrec32.exe /play /close " & Soundfile)
End Function

Then call the function:
PlaySound "C:\lebowski.wav"
using your path to the wav file.

Damon

 

[ruralguy via AccessMonster.com]

This should work in ac07 too: http://allenbrowne.com/func-04.html

 

[Arvin Meyer [MVP]]

Use the api to play any type of file like that:

http://www.mvps.org/access/api/api0011.htm