jeroen van vliet

Hello all,

I have an ado control with an access dbase and i want to make a button that
when its clicked a specified wav or mp3 file will be played in accordance
with each record on the access database. Does anyone know how do do this?

Jeroen

paul_james_hayward

Hi Jeroen,

to play wav files you can use the Multimedia Control (MMControl).
Whenever you want to play a sound just change the properties of the control.

e.g.
' Set general properties needed by MM Control.
MMControl1.Notify = False
MMControl1.Wait = True
MMControl1.Shareable = False
MMControl1.DeviceType = "WaveAudio"

' Each time button is clicked load the relevant wav file
'Either i) a fixed path to a file
MMControl1.FileName = "C:\WINNT\Media\chimes.wav"
'Or ii) a database field containing the path
MMControl1.FileName = MyRecordset!StrSoundPath

' Open the sound file and play
MMControl1.Command = "Open"
MMControl1.Command = "Play"

I don't know if this control works with mp3 files though.

Hope this helps