I've been playing around with making a music library cataloguing CDs and MP3s I have a tables Albums: AlbumID,AlbumArtist,AlbumTitle,CatNo,Missing AlbumTracks:TrackID,AlbumID,TrackArtist,TrackTitle,TrackNo and now I have made a table for my MP3s Songs:SongID,SongArtist,SongTitle
I have a search form showing my CDs SELECT [TTrack].TrackArtist, [TTrack].TrackTitle, TAlbum.CatNo, [TTrack].TrackNo, TAlbum.[Missing], [TTrack].TrackID FROM TAlbum INNER JOIN TTrack ON TAlbum.AlbumID=[TTrack].AlbumID WHERE ((([TTrack].TrackArtist) Like "*" & [SearchBox] & "*")) Or ((([TTrack].TrackTitle) Like "*" & [SearchBox] & "*"));
Can I get round putting my album tracks and mp3s in one table I tried but I had to give all my mp3s a albumID and didn't want to do that.
I hope this makes some sense I'm not great at access and a lot of what I have picked up to do this is from the brilliant Richard.
Kevin Yip
@Reply 3 years ago
MP3 tracks should include the album's info also if they are part of an album. Every MP3 file contains "tags" that store all the info about it: artist names, album names, album cover images, and sometimes even lyrics. If the MP3 tags contain album names, then your Access table should have them too. When you buy MP3 tracks from Amazon or whatever, they should have tags already in them. There are tools, such as MP3Tag, that let you view and edit those tags. Those tools can also export those tags to Access to save time, if that is your concern.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
