OLE Sounds on a form

luceze_99 used Ask the Experts™
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 is hidden on the form. For example the first field is a jpeg of a cow and the second field is a .wav file that says moo. When the user goes to that record in the form I would like it to say moo when the user clicks the button. I am not worried about file size since there won't be many records.  If anyone knows about this I would appreciate any help.

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can use the following code

Private Sub OLEPicture_DblClick(Cancel As Integer)
    Me.OLESound.Action = acOLEActivate
End Sub

Cheers, Andrew

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial