adding wav file to a msg box

[k983111]

Can someone please tell me if it is possible to get a wav file to play when my msg box pops up?. My code is

If DCount("[Spec]", "Stolen", "[BoxNo] = '" & Me.BoxNo & "' And [SpecCode] = '" & Me.SpecCode & "'") = 1 Then
MsgBox "STOLEN BOX!. This box is on the Stolen List"
Cancel = True
Me.Undo
Exit Sub
'Do nothing
End If

Many Thanks in advance

 

[ghudson]

First you have to enable your db to play sound files. Check out this link for it works great.

API: Play MIDI/Avi/Wav files

HTH

 

[Oldsoftboss]

maybe an easier tact.

If you make your msgbox with a vbcritical or vbinformation etc as follows

MsgBox "Your Message Here", vbCritical, "Sound Test"

then access will play the windows default for these sounds.

Just a matter of selecting your prefered sound in the windows control panel

HTH

Dave

 

[Rich]

You could of course also just add the standard Beep

 

[Fizzio]

Rich, where's your creativity gone, have you lost your Va Va Voom??

 

[Rich]

I'd love to able to cite having to listen to the 1812 ' as an excuse for not doing any work, truth is of course "music" from a computer is nothing of the sort, and it becomes tedious after a while.
Call me old fashioned if you like, just don't call me OLD

 

[k983111]

Went for the easier option, the function option was a bit too advanced for me. Works great, thanks guys.