Can Anyone Help?

[connordrew]

Hi there,

I want to index my music in a database and I have created three fields database as follows:

ID (AutoNumber) Primary Key
Log (Yes/No)
Play (Hyperlink)

I would like when I click the Log button on a form, the play field automatically names the field like this: c:\music\1.mp3, c:\music\2.mp3, c:\music\3.mp3
I would like the .mp3 to be automatically numbered from the ID field?
I hope I have explained this good enough!!!!

Thanx In Advance

 

[Oldsoftboss]

Do you wish to rename the files in the folder, or stroe the path in your Db ?

.....Not the answer you are looking for, but may help:
http://www.access-programmers.co.uk/forums/showthread.php?t=28702&highlight=winamp

 

[charlesandrews]

Hi Oldsoftboss,

Thanx for your reply mate and sorry for the long awaited reply back

I had a look at the hyperlink you sent me and it doesn't really help with what I need. I have created a field called hyperlink in my table and that's where I link the title to the song.

Since my original question, I have managed to create a cheat for automatically incrementing text: i.e.

c:\music\tracks\01.mp3
c:\music\tracks\02.mp3
c:\music\tracks\03.mp3
c:\music\tracks\04.mp3
c:\music\tracks\05.mp3

The problem I have is this, when I click on c:\music\tracks\01.mp3 it plays track 1 in that folder because I have set that as the soundfile hyperlink. I might have 4000 plus songs to index and rather than just having "TeXt To Display as c:\music\tracks\01.mp3" and having to insert the address part of the hyperlink, I would like the hyperlink to be set as the same name as "Text To Display" when u press ctrl + K.

Thanx

 

[Oldsoftboss]

Back to my original response...

Are all your tracks called 01.mp3, 02.mp3, 03.mp3 etc ? If so, how on earth will you know what song the track is ?

I will whip a demo of the way i would go about it.

Dave

 

[Oldsoftboss]

Try this, may need to check references. This doesn't include your auto log code,

Opens music and video files.

Dave

 

[connordrew]

hi Dave

And thanx for your reply.

Excellent Dave, I am sure I can incorporate that into the database.

Thanx again

 

[Oldsoftboss]

Glad to help

One other thing I should have done is to make a better filter string for the different types of music file extensions.

Oh well,

Dave

 

[connordrew]

now that would be very interesting!!!!

All my music files will be .MP3 and .WMA. I will be indexing them all soon and I like the way you have created the field so that as soon as u select an artist, the song plays.
I had my original field as a hyperlink, but I notice yours isn't.

Is there a way that you can add an add to playlist button so that it plays the current track and adds your next choice ?

Thanx David

 

[Oldsoftboss]

Will have a look and try to come up with something. I'm not sure how to display the Windows Media Player playlist in the form but will have a go.

Dave

 

[charlesandrews]

Thanx Dave,

I look forward to seeing tha m8. Dave, I notice when I scroll through the form you created, Media Player increases in size. Is there any way to stop this, because the play button becomes invisible?

cheers