Songbooks

[Lonman]

I prefer Access personally. I still use laser discs as well & those wouldn't be listed in a Hoster made book.

[UPNext]

Originally Posted by Lonman

I prefer Access personally. I still use laser discs as well & those wouldn't be listed in a Hoster made book.

Using Access, do you have anything that eliminates duplicate entries when your songbook is created?

[ddouglass]

Originally Posted by UPNext

Using Access, do you have anything that eliminates duplicate entries when your songbook is created?

With Access you can create your own queries to do just about anything you want, but it takes a bit to learn how. I have been using Access for 20 years and I find it quite easy to use.

[UPNext]

Originally Posted by ddouglass

With Access you can create your own queries to do just about anything you want, but it takes a bit to learn how. I have been using Access for 20 years and I find it quite easy to use.

Have you created a query to take out duplicates in your songbooks?

[ddouglass]

No because I don't have that many duplicates to worry about. Besides most of my singers know which brand they like and if I took them out they would hollar.

[Wade Shuey]

I have 2007 access but never used it before... Don't really know how it even works?? I'm only guessing, but I bet most other users won't know how to use it either. How do you even get your song book to load into access to be able to change it?

[ddouglass]

We started with it from the beginning, built the table, queries and reports from scratch.
That said you can copy the file songs.mdb (don't work directly on the original file) then open it in Access. From there you can add queries and reports.

[stublack]

I didn't vote on this poll because there was not an option that fit.

I used KJ Pro in the past before I purchased Hoster.
I have used Excel for other purposes and did consider using it for my songbooks.

For my purposes the Hoster Songbook is just a lot simpler.

So if there was an option that said Hoster Songbook is better for your purposes than any other program that you've used I would have place my vote there

[bigjohn]

Hoster songbook works ok not the best and not the worst I forgot how to make it list in excel old age i guess.

[Musicman51]

I like KJ pro for the reasons stated above. I used KJPro when i was doing karaoke with a player, only program worth a durn at that time. Outdoor yard parties, pool parties, and biker rallies i still take my JVC, and old backup disc to use. So the Hoster books would do me little good actually.

So i have just stayed with KJ Pro. I keep the duplicate titles in, i tried leaving them out, and everyone drove me nuts asking what lable the song was on.

Last count i had 9 D.I.V.O.R.C.E. recordings on different lables.

[Joe Nieves]

Originally Posted by ddouglass

No because I don't have that many duplicates to worry about. Besides most of my singers know which brand they like and if I took them out they would hollar.

Hi ddouglass

I like access too and find it helps me clean up hoster database issues quickly.

As for the hoster song book I don't use it at all.
Main reason not setup to print by Disc ID only by book ID

When singers want a song in SoundChoice or ChartBuster ver. they like to see it listed in the book that way SC2535-05 CB90045-09, mush easier to remember then Book ID 11205939 or 396943824.

I use Music Book Dlx find it very useful, accurate and easy to use takes care of dup's and has many features not availible in other song book programs.

Would be nice if Hoster would allow other database to be used for import.

Joe....

[ddouglass]

Originally Posted by Joe Nieves

Hi ddouglass

I like access too and find it helps me clean up hoster database issues quickly.

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.

Originally Posted by Joe Nieves

As for the hoster song book I don't use it at all.
Main reason not setup to print by Disc ID only by book ID

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.