Play sound OLE

[luceze]

I have a table with an embedded picture in one field and an embedded .wav file in another. In a form I am trying to make the .wav file play when someone clicks a button. I know that you can activate the OLE object by double clicking on it but it won't work in my case. If anyone knows about this I would appreciate any help.

Eric

 

[smeadows]

Hi

I have the code for this , drop me your e-mail address and I will send it to you over the week end

meadowsstephen@hotmail.com

 

[luceze]

I figured out how to do this. The code is as follows.
Private Sub PlaySound_Click()
With Soundx
.Verb = acOLEVerbPrimary
.Action = acOLEActivate
End With
End Sub