Music database

[junhize]

Hi, I'm a Access noob and would like to noe, if for example i'm trying to develop a simple music management database, is it possible to use Access 2007 to link the query result to a mp3 so that when the result come out, i can use it to play the song?

Thanks in advance becoz i realy need help on this.

 

[speakers_86]

Yes. On the form you could create a button with an on click event that opens the mp3. Of course access wont play it, your default mp3 player would open to play the file.

 

[junhize]

Thanks for the reply but how do u create such button? Is it possible to create this in the report form so that when someone search my database, they can get the report and play a file from the result... Thanks again

 

[speakers_86]

You didnt expect this to be easy did you?

The more automated you want it the more work this will take. The easiest way would be (in access 07) to to have an attachment field for the mp3. On your form, the button should be able to open the file when clicked.

Here is what Microsoft has to say about buttons.
http://office.microsoft.com/en-us/access/HP051877521033.aspx

If that doesn't help, try Google.

 

[junhize]

Thanks a lot for the help! Reallly appreciate it...

I've tried the attachment method and it kinda of work but when i double click on the mp3 icon, it opens another window and i'll have to click 'view' to run the mp3...

So if I were to use the command button, I'll have to build a macro that runs the windows media player? Where can i find such code as I'm not really a programmer? I tried googling w/o much success..

Do you know of any answer to this?? Thanks again...

 

[AxGryndr]

A music database like you are talking about would require the user to have the songs on their computer in the same location as where you would program it to be. So unless you are providing the database and the mp3 files they won't have them. The only other thing I could think of would be to prompt the user for their mp3 folder or search for all their mp3 files.

As for the macro I have never used a Macro to open say Window Media Player or WinAmp.

 

[junhize]

Thanks alot for the help, i guess i'll juz use the attachment method.. Thanks again...

 

[Vassago]

There is also a sample database that shows you how to use music controls within Access. Check them out.