Search results

Thanks all for your replies and special thanks to MajP for the code (in fact, thanks again as you were helpful with my questions on performers before). The generosity on here is very much appreciated.

All, I've previously posted about my music database which is working well and proving very helpful (no doubt to the fantastic help on this forum). However, I want to see if it is possible to do something for data entry purposes. I have a junction table where Musicians (MusicianID) and Roles...

Paul (pbaldy), That worked a treat, thanks so much for replying and for your website. All the advice on these forums has been so helpful. Going out on a limb here: as noted, these are combo boxes (Musician/Role) using a multi-select Listbox for data entry. The form is set up for 10 dual combo...

All, I'm (still) messing about with my music database and using the MultiSelectAppend code as part of it: http://www.baldyweb.com/MultiselectAppend.htm My code is modified to the database and worked fine with two unbound combo boxes (one for MusicianID, one for RoleID) and the listbox as...

Thanks Gasman. I was just about to post that this was my error. In case of interest to other amateurs, posting the results of the debug from the Immediate window as a Query showed the errant space straightaway (and Gasman would have bailed me out anyway!)

Thanks for the reply. Adding the "AS TrackID" did not make a difference. I still get the Error 3134. It's odd as the debug statement looks like it is trying to do the right thing (copying RoleID and MusicianID but with a different TrackID), at least to my eyes.

All, I continue to find the information on this forum fantastic. Most of the time I can work out my issues but I am stumped again (with something no doubt very simple). In my music database I am trying to copy information over from one track (Track A) to another (roles of individual...

Thanks both for the replies. I have come up with a solution, prompted by the helpful suggestions. I can use the same solution as with the roles issues discussed above. 1. Enter all Tracks with their Songs (junction table on TrackID and SongID) and other information linked to an album by...

Thanks very much. This is really helpful and informative. I will be playing around with my database to improve it. Another question please when I think about data entry. Is there a way to save time and force a second linked subform to update when the first subform is updated (where the...

Thanks plog for your thoughts and acting as a sounding board. Much appreciated. I will stick with the current approach*. * until I break the database and come here in need of immediate help. :)

Hi again and thanks. I don't agree but let me see if we are coming from the same place: A Song is a one-off. Hey Jude was written by Lennon/McCartney. Ignoring the possibility of other songs with the same title (which we can deal with separately) it is unique. Certainly Hey Jude by...

Thinking about it further though since a Song is a separate entity from a Track (and one Song will be on multiple Tracks) should I not keep a junction table for Composer separate from that for Tracks and Musicians who play on them? A Song and its Composer is entered once; Tracks and Musicians...

Thanks Plog for the quick reply. A Track is a physical track on 1 CD in my collection. A Song is a composition which will be on multiple tracks in theory. A Track can also have multiple Songs (e.g. a medley!) The second point will be addressed if I remove the jtblComposers as you suggest.

All, As noted on other questions I am building a music database for my own purposes. Thanks to the myriad questions and answers on here it is coming along nicely and fits my needs well. However, I want to check one issue that is niggling at me. Consider the following: tblSongs SongID...

In case of interest to future novices this is what I figured out: 1. I enter data into an Album form including a subform for Track information. 2. One of the requirements is SongName which takes entries from a combobox. 3. If the SongName is Not In List then it asks me if I want to add it...

Belated thanks to the responses. In answer to the question about interface, I will be the only user as am building a database for my personal collection. The tables as described will work for my requirements (a musician can play any instrument on any track and multiple versions thereof). I have...

Thanks for the reply. What I can not see from that, though, is how to do that for multiple Tracks (and TrackID) at the same time as opposed to a single Track entry?

All, Again, many thanks for this website. It is really helpful. I managed to make my previous sticking point work (after some trial and error) but now I am REALLY stuck! :banghead: The database has been working as I intended but I keep wanting to add new features. This is a music collection...

Thanks for the reply. Yes, I have a junction table that has a foreign key for Songs and a foreign key for Composers, exactly as you describe. However, my main data entry form is Albums with sub-forms for Tracks. A Track has Song, Artist, Album Number etc. When a new Song is entered as a...

All, As I said in the intro forum, many thanks for such a helpful and informative website. It has helped me immensely in building my database. Now to the question. I am building myself a music database. As part of this it uses many to many tables (and junctions). For example, we have Songs...