Playing Music From Access

mustardcharlie

My first question on this site, so hi to all.

I have recently constructed a database for my daughter's (12) mp3 files so that she can easily move them to and from her mp3 player. This works fine and saves me hours searching for a particular track.
However, so that I can check that a file is not duplicated, I would like to be able to listen to it, preferably in WinAmp but WMP would do in this case. In short, what I am trying to do, is simulate double clicking the track in Windows Explorer. Is this possible?

Ali Rizwah - "Run AVI files inside a picture box" on 25/02/08 in the VB/VBA "How To" section is close to what I am looking for, so if anybody can tell me how to modify this for audio files, I would be most grateful.

ADezii

Quote:

Originally Posted by mustardcharlie

My first question on this site, so hi to all.

I have recently constructed a database for my daughter's (12) mp3 files so that she can easily move them to and from her mp3 player. This works fine and saves me hours searching for a particular track.
However, so that I can check that a file is not duplicated, I would like to be able to listen to it, preferably in WinAmp but WMP would do in this case. In short, what I am trying to do, is simulate double clicking the track in Windows Explorer. Is this possible?

Ali Rizwah - "Run AVI files inside a picture box" on 25/02/08 in the VB/VBA "How To" section is close to what I am looking for, so if anybody can tell me how to modify this for audio files, I would be most grateful.

I have a Merthod to play *.mp3 files involving an API call, but I'll wait and see if anyone else has a better solution.

NeoPa

I guess they don't then ADezii. When you get back from holiday perhaps you can share your method.

ADezii

Quote:

Originally Posted by NeoPa

I guess they don't then ADezii. When you get back from holiday perhaps you can share your method.

I was going to suggest using the ShellExecute() API Function which will Open any File based solely on its File Extension Association. In the case of *.mp3 Files, it will Open the Server Application that is registered on the System for opening *.mp3s. If the OP is still interested, then I'll Post it. In my opinion, it is one of the neatest tricks around, since you don't even have to know which App is assigned for a give File Type.

Playing Music From Access

re: Playing Music From Access

re: Playing Music From Access

re: Playing Music From Access

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about