How do I use a form field to open a file on my PC ?

[alunkane]

I am trying to write a little database to view my MP3 collection (as you do when youre bored...)

I have a field that shows the full path to my MP3's

e.g "D:\My MP3's\iTunes Music\Bob Dylan\Desire\03 Mozambique.mp3"

I want to be able to click on the file link to launch the file in my MP3 player - I have tried changing the field type to "hyperlink", but that still doesn't work...

Any help greatly appreciated.

 

[ghudson]

Did you try searching?

Search for the keyword ShellExecute. You can add my user name to see the posts I have responed to.

 

[alunkane]

Thanks... tried searching

Thanks...

I did do a search first - but wasn't too sure exactly what to search for ?

I thought it would be as simple as using Hyperlinks & clicking on them -but perhaps not...