Random songs on a form

[rikklaney1]

Ok, back to the well of knowledge. I have a form with windows media player embedded in it. What I want it to do is play a random song when I open it. So I put a field called Randomizer in the form and added this code.

Me.randomizer.Value = Int((60 - 1 + 1) * Rnd + 1)

Now How do I put the URL for the song into vba format? I tried just using the URL property field for the player (D:\[randomizer].mp3) but no luck. Any suggestions?

 

[EdFred]

I did this exact same thing a few years back. I will have to see if I can find that database. I used it as an alarm clock.

 

[rikklaney1]

So...any ideas? Anyone?

 

[JHB]

Use the Dir function, a loop and a counter, then load the file when counter = Me.randomizer.Value.
More or less as shown in the link below:
http://www.word.mvps.org/FAQs/MacrosVBA/ReadFilesIntoArray.htm