Results 1 to 3 of 3
  1. #1
    twjones is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2018
    Posts
    2

    Creating Set Lists for Band

    Hi,

    Newbie here with limited Access knowledge. I have gotten by so far by watching different tutorials on the internet. I am trying to put together a database where I can manage my bands contacts, venues, gigs, etc. I am stuck when it comes to creating set lists which can also be printed. I have a table where I can add songs and information pertaining to the song (Key, Duration, Artist, etc). I use a form to enter that information.

    I would like to have a form where I can create set lists pulling just the Song Title from the Song table. I would like to do the following:

    1. Have a drop down list that will list upcoming or previous gigs. If it's an upcoming gig I can create a set list or chose the standard set list.
    2. If the gig was in the past I would like it to show the set list that was played.
    3. I would need a listbox that would show all of the active songs (I make the songs active in the song table/form)
    4. I would choose from the song listbox and move the song from the "all songs" listbox to the appropriate set (which I am assuming would be another listbox).
    5. I would have to be able to move the songs in the set listbox so that they would be in the appropriate order.
    6. After all of the songs are in their appropriate set I would like to print the set list for band mates.



    Hoping someone can help me out. Thanks in advance.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    a combo box for gigs, cboGigs
    a combo box for Sets, cboSets
    a listbox with all songs
    a combo box for Artists, as a filter for the songs list
    tGig table:
    gigID (auto)
    gigDate
    SongSetID

    tSongSet table:
    SongSetID (auto)
    SetName

    tSongSetList table1 to many subtable with tSongSet)
    SongSetID (long)
    SongOrder
    SongName

    tSongs table
    SongID
    SongName
    Artist

    -----------
    the listbox for songs would have a query: qsSongsAll
    if the user picks an item from an combo: cboGigs, cboSets, cboArtist, etc, this would filter the list.

    in each combo (from a table) you can have 2 columns, 1 for the item to pick, the 2nd col for the query.
    if user picks from the cboArtist, the 1st col= Beatles, the 2nd Col = qsSongsByArtist.

    this would set the listbox (of songs), lstSongs , to that query:qsSongsByArtist.
    lstSongs.Rowsource = me.cboBox.column(1) 'in vb, columns start with zero

    the query uses the tSongs Table filtered on item in the combo:
    select SongName from tSongs where [artist]=forms!myForm!cboArtist

    same with the other combos. Each would assign a query to the listbox.

  3. #3
    twjones is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2018
    Posts
    2
    OK thank you. I will give this a shot and report back.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating Lists in microsoft access
    By mndauber in forum Access
    Replies: 4
    Last Post: 05-18-2018, 02:59 PM
  2. Database for Band Management
    By Raiderduck in forum Database Design
    Replies: 5
    Last Post: 08-17-2015, 02:17 PM
  3. Replies: 1
    Last Post: 11-30-2013, 03:43 AM
  4. Creating Client Lists in Access
    By Charalampos in forum Access
    Replies: 2
    Last Post: 03-11-2011, 10:22 AM
  5. Creating single lined lists from reports
    By trikosuave in forum Reports
    Replies: 4
    Last Post: 02-14-2011, 08:10 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums