MTU.Community - Songbooks

MTU.Community (http://forum.mtu.com/index.php)

- Hoster Help (http://forum.mtu.com/forumdisplay.php?f=71)

- - Songbooks (http://forum.mtu.com/showthread.php?t=8961)

Quote:

Originally Posted by ddouglass (Post 89296)

I hope you don 't have to ever Rebuild or Add your Database, because every change you make in Access will disappear. I use Access to look at the Songs Database and to use it as my basis for printing my books and am trying to use it to print my Singers lists from that database, though I have not been completely successful with that yet.

Joe, when was the last time you looked at the Songbook Creator. You can have it use either the BookID or the DiskID. You might want to check it out.

Hi ddouglass

Question:

If you make a change to the songs in edit song under tools and save it does this get reversed if you rebuild your song database?

Joe.....

Quote:

Originally Posted by Joe Nieves (Post 89449)

Hi ddouglass

Question:

If you make a change to the songs in edit song under tools and save it does this get reversed if you rebuild your song database?

Joe.....

No. The edit songs dialog changes the KMA header information so it stays with the file. The only thing that is not persistent at present is the "Hide in Songbook" selection. MTU is working on that though.

Quote:

Originally Posted by marklwood (Post 89459)

Hmm

Joe that was in February before the 4.08 release. 4.08 now saves the "Hide in Songbook" as well now.

Getting away from printing songbooks

Since 4.08 has the Songs.mdb file I wrote a little Access Sign-Up program. I copy down the songs.mdb and use it to allow singers to search the data bas and sign up for a song. This is networked back to my hoster PC where I run a second part of the program that allow me to see who signed up, Bookid, artist, title, manufacturer, and hometown of the singer. Since I can't tie in directly to hoster I just type the Bookid, singer and hometown into hoster, then click a check box on the record so I know I've already enterred it. I also have an update button that removes all the checked singers and adds any new singers to the screen. It's installed as a runtime on the signup PC so it takes very little memory on the Hoster pc.

I got tired of trying to read slips with illegible handwriting on them, and this although not perfect is much better than slips. Next step is to network 3 or 4 sign up PCs around the bar. I'm looking at using thing clients for this. I'll fine tune more once the season starts on the outer banks of NC and my singers list starts hitting 25 to 30 singers again.

Another reason i use KJ Pro, is i only run myself, not 2 or 3 computers. So i use Hoster Lite, there is no songbook feature. :r

Quote:

Originally Posted by searcherone (Post 91614)

Since 4.08 has the Songs.mdb file I wrote a little Access Sign-Up program. .

I recently got a copy of the program above from Searcherone. I am very impressed with it and it runs along side Hoster using it's Songs .mbd file, saves keep printing new books each time you add new disk's.:c I had an old laptop laying around fixed it up with a wireles card. I also got a couple of keyboard protectors which are like a very thin polyurethane material, covers the keyboard to protect from spills, use them on my Hoster machine and the signup laptop. got these from:
http://www.sourcingmap.com/silicone-skin-clearwhite-laptop-keyboard-protector-p-33405.html
for anyone who's interested.:)

Roy.