Search results

Plugging away on this still (amid too many interruptions). I do understand the point made about junction tables; however in most cases a song will only be on one album, so this is more suited for a one-to-many relationship (one album has many songs). I have looked through all the threads (on...

Understood on the junction table. Are junction tables used primarily for many-to-many relationships? In my case, a song will typically only be on one album (although bands like the Rolling Stones are wonderful marketers and have tons of compilation albums, so a song CAN be on lots of albums)...

Access 2003, neophyte Access app creator. :banghead: After entering data into my db tables straightaway for sometime, I've finally gotten some time and want to create a better means to enter my data. My music DB contains info about the artist, album (year released and genre), and the songs on...

Thank you for the assist! I was a sys admin for many years and knew enough SQL just to get by, I'll read up on the Left Join and become more adept at it!

Bob, Many thanks for your insight. As a reward, (along with passing thanks on here), I will take 10 min to read up on the Unmatched Query Wizard and become proficient at it!

Hi all, I have a Access 2003 app that I am creating to catalog my music collection and have come across a situation I was hoping someone might be able to shed some light on for me. On occasion I will enter an album or group of albums into the database without also adding the associated songs...

I'm trying to create a app (access 2003) for tracking my music collection. I've pondered over normalization and think I've got that resolved, however when creating joins between the songs and albums tables (using album_title) I get an error stating I haven't created a unique index for the...

Gemma, I know that check boxes are not the preferred way and may very well change those two fields to one utilizing an option group in the future. This works ok for the time being as I'm only going to have my tunes store in one or the other. Great input though :)

I have a form that I use to enter information, and now and then it changes just a tad (this is my personal music collection, and occasionally I'll diversify and add a new musical genre). I have a GENRE field in my ALBUMS table that includes a lookup (combo box). (I also am using a combo box in...

A bit tardy on posting here, but thought I'd stick my head in the door regardless! I'm a sys admin (USA, Oregon) by trade w/ few programming skills, mostly shell scripting and a tad bit of per. I'm not new to databases and am familiar w/ Access, but this is the first I've actually utilized it...

Hmmm. I took a few minutes to read up on the VBA window and its components, and since I wasn't having any luck w/ previous attempts I went ahead and cleared my previous work and went with your suggestions via coding straight into the editor. And it worked, first time. No idea where I was...

See attached.

Followup: on a record I have with the itunes check box selected, when I click the cold storage check box it doesn't "check" it OR deselect the itunes check box. When I click the itunes check box it doesn't uncheck that one. Hope that makes sense.

Hmm. I think it seems like either after update or on click ought to work. But... after entering the code, it doesn't respond! (????) I have saved the code after entering it. Private Sub Cold_Storage_AfterUpdate() Me.Cold_Storage = Not Me.iTunes End Sub Private Sub iTunes_AfterUpdate()...

Followup: is Me the table name, or the form name? I'm seeing now that the spaces in the form name aren't the best idea.

I like your idea about the option group, but since I'm semi-committed I'll update the check boxes. If I am reading your reply correctly I'd do it like this? (check boxes are also named iTunes and cold_storage) I'd change the After Update property for the iTunes check box to: Me.Cold_Storage =...

I've considered having a 2nd table for the cold storage albums, but since I may likely move the songs back in time, it's easier to leave it all in one table.

I have a small db Access 2003 db that I've created for tracking my home music collection. At present, I use 2 yes/no fields to track the location of the music: iTunes (yes/no) and Cold_Storage (yes/no). Due to disk space consideration, I periodically move some of the music to an external disk...

OK I figured it out, problem was that I needed to set the REPEAT SECTION property for both the header areas (for Genre and Group_Name) to yes. Now if the records go to multiple pages it shows both the Genre and Group_Name on each page.

Let me put some other info here. The report includes data from the following fields: Group_Name Album_Name Year_Released Genre The records in the report are grouped by Genre. They are then sorted by a) Group_Name, b) Year_Released, and c) Album_Name. So there are headers for both Genre...