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.