Search results

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...

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...

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...

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...

First off, thanks for your time. I'm somewhat savvy to technology - not so much in making db's - but I haven't been able to identify how to get around this issue. I'll do my best to explain it succinctly: I have a personal db that I use for managing a rather large music database, including the...

I've done a scan through existing threads to see if I couldn't find an earlier solution, but was unable to locate anything that seems similar to what I am attempting. I know a bare minimum of programming in VBA. What I am doing is creating an application I will utilize as a "switchboard" to...