Use a multiselect List Box to create a playlist and then use media player to q them up.

[westfallbp]

I done this with some help like 15yrs ago in Access but lost the database. However, I recall I had a table with a list of music titles, I then created a multiselect listbox based on the table or querry, (doesn't matter), I would then select all the music files I wanted to hear. Had a command button to add and a temporary table would be created with my selections with the file locations. I would then have another listbox based on my selections that I would view. (all on an ubound form I recall) I would then have a command button under that which I would select and it would then Q all the songs up in media player and play them. If memory serves me right I then had another command button I could wipe the table If I wanted a new playlist. I believe I needed a Module, A action Querry I think also to make this happen. If any of you old timers recall how this was done I would greatly appreciate it. Thanks

[June7]

You have the app outlined, why not start building? The only real challenge I see is manipulating media player. Suggest you web search on that specific topic.

[westfallbp]

I done this with some help like 15yrs ago in Access but lost the database. However, I recall I had a table with a list of music titles, I then created a multiselect listbox based on the table or querry, (doesn't matter), I would then select all the music files I wanted to hear. Had a command button to add and a temporary table would be created with my selections with the file locations. I would then have another listbox based on my selections that I would view. (all on an ubound form I recall) I would then have a command button under that which I would select and it would then Q all the songs up in media player and play them. If memory serves me right I then had another command button I could wipe the table If I wanted a new playlist. I believe I needed a Module, A action Querry I think also to make this happen. If any of you old timers recall how this was done I would greatly appreciate it. Thanks

I believe that was what the module did

[June7]

It sounds like a reasonable design.

Alternatives to multi-select listbox:

1. if this is a single-user db, just have a yes/no field in table to select records (no temp table) - could use a toggle button bound to yes/no field on continuous view form), an UPDATE sql could reset all records to no

2. form bound to "temp" table and combobox to select title in each record, a DELETE sql could purge table

Something else to consider: "temp" table is not temporary but used to build multiple playlists that could be saved then retrieved via PlaylistName (MyFavorites, Christmas, etc)

[Welshgasman]

I seem to recall another member here was playing music via Access, so perhaps search here.

Then again, there is always Google?
https://www.google.com/search?q=play...hrome&ie=UTF-8

[westfallbp]

I believe that was what the module did

Now that I have been thinking about it I believe the module was for using the "Send Keys" which media player has a combo key for q uing up the tracks. My problem is that Im more of a script kitty then writing my own modules.

[davegri]

Have a look at this:

User Friendly Access Media Player for Audio

I'm working on a much more enhanced (and I've learned a lot more about wmp.dll) version that I will post in the next month or so.

[westfallbp]

Now that I have been thinking about it I believe the module was for using the "Send Keys" which media player has a combo key for q uing up the tracks. My problem is that Im more of a script kitty then writing my own modules.

I know what I used back then. It was called winamp, Also I got help in the MS Access forums. To bad I cant view posts that I did over 10yrs ago so I could adapt it for MS Access version I am using now. After viewing your post it kick started my memory that I used winamp...Thanks for the memory