Playing a WAV Sound

[SMiller]

I have the site on how to play a wav sound from grahm R
seach as followsrivate Declare Function Beep Lib "kernel32" (ByVal
dwFreq As Long, ByVal
dwDuration As Long) As Long

Public Sub PlayBeep()
Dim iCtr As Long

For iCtr = 0 To 5000 Step 10
'Play a tone of iCtr hertz, for 50 milliseconds
Call Beep(iCtr, 50)
DoEvents
Next iCtr
End SubWHERE DO I PUT It to play when a form opens?:

Thanks

 

[Graham R Seach]

Another person who simply abandons their original thread to start a new one!

Put the code into a standard module, making sure to change "Private" to
"Public". Then add the following code to the form's Open event:
PlayBeep

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Graham R Seach]

Actually, you don't need to change "Private" to "Public".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html