Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Play MP3 files from Access 2

Status
Not open for further replies.

innmedia

Programmer
Mar 24, 2000
108
US
Hi,

Anyone know how to play MP3's from Access, or what ActiveX control to use, or how to shell to the media player?


Thanks!

KB
 
You can create a play list from access, and write a report for the play list, export the playlist with a true for launch, which will laungh the playlist with your default player, example below.

DoCmd.OutputTo acOutputTable, "MyPlayList", acFormatRTF, "Play.M3u", True

ChaZ


Ascii dumb question, get a dumb Ansi
 
BLorf,

Thanks! But two items...

How should the MyPlayList table be structured? What does it contain -- paths to .mp3 files? Please give an example.

Also, is "Play.M3u" a required way of naming the playlist?

KB
 
an .M3u file is an extremely simple play list file, because it is just text. It can contain a great deal of information, but all that is required really is the path and file name, each on a seperate line, like this:

C:\MyMP3Files\File1.mp3
C:\MyMP3Files\File2.mp3

The actual file name of the playlist is not a problem, just so that it ends with .m3u (There are other formats, but this is the simplest)

Hope that explains.

Chaz







Ascii dumb question, get a dumb Ansi
 
Welcome.

If you don't mind me asking, what is your intention with this?

My father had me build something that would let him search through albums, titles, and artists. He converted about 1000 old LP's into MP3's, so this was useful to him. He does not share or anything like that, but he owns thousands of old records.

ChaZ

Ascii dumb question, get a dumb Ansi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top