Search and Play recording

ipuff

New member
Local time
Yesterday, 16:34
Joined
Mar 1, 2007
Messages
8
Hello,
I wanna put a button in an access form. I want the button to search a file (a recording file. the recording file refers to the telephone number of the client. Recording name is in this format : 5551211214.mp3) in a particular folder. Once the file is found, it open up media player and plays the recording. I have been searching for this, but havent been able to find anything about it. Can anyone please help me with this.

thanks.
 
What part in particular are you having trouble with? Searching for the file or playing the file?

I'm not sure how you want to search for the file and what to do with multiple results (if using a wildcard) but there's a simple way of playing the file:

Code:
Application.FollowHyperLink "C:\MyFolder\MyRecording.mp3"

Or

Code:
Dim MyFile, MyFolder as String

MyFile = "A_recording.mp3"
MyFolder = "C:\MyFolder\"

Application.FollowHyperLink MyFolder & MyFile

There are better ways to open files of certain types, but this is nice and simple.

Regards,
Pete
 
hi,
thanks for the reply. I'll explain in more detail. it is a client database. every client has a unique phone number and there is a recording associated with it, in a particular folder. so im trying to create a button on the form, that opens the mp3 file and play it with the default media player on the computer.

please, if you could help me with this

thanks
 

Users who are viewing this thread

Back
Top Bottom