Search results

  1. I

    Use one multi-select listbox to insert data using a second listbox

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

    Query about MultiSelectAppend

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

    Problem running VBA Insert Into

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

    Question on normalisation and best practice

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

    Multiple data entry for Junction Table

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

    Notinlist to create default on form for combo box

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

    Hello (and thanks!)

    Hi all. A complete novice to Access that has learned a lot in recent weeks from these excellent and helpful forums. Decided to register so I can ask questions!
Top Bottom