Playing mp3 files from a form

I'm new to Access but have made a database of my music collection. Is it possible to get the selected mp3 file to play on the click of a button directly from a form? My music collection is store in several sub directories on my hard drive.

Yes you can;

Have a look at the attached sample, just change the data to suit your situation.

The sample is not very fancy, however it will give you something to improve on.

RElay mp3

I have had a look at the attached db but cant seem to get it to work

When the form frmWindowMediaPlayer is about open it fails with object does not support this propert or method

On the form load it doesn,t like the following code
Me.WindowsMediaPlayer0.URL = AudioPath

I have tried looking at vb references but to no avail

Smart,

from my first post:

just change the data to suit your situation.

Click to expand...

Have to done this?

Also open the form frmWindowMediaPlayer in design view and you will see 4 vertical marks to the left of the black screen, these are the control for the form.
Move the second on down to the bottom of the form(Make sure that you make the for bigger), expand it, make it visible, now display he form in form view. What do you see? You should see the path to your first audio file.

The same when you open the form frmAudioList you should see your audio files not mine - I only left mine in as an example.

Thanks very much! Everything works fine though with such a large amount of records, the system is very demanding on memory/resources. Also liked your advice on the Windows Media Player Form. Didn't know such things existed!