Song Book Double Listings

[MrMark]

I Had an idea, but I've also had many other ideas too. Thanks or the assurance.....it worked.

[mikedomi]

glad to here it

[MrMark]

Is there anyway to go into the database and change everything to uppercase? Some songs are in uppercase and lowercase, if i can get through the database and change everything to upper at once that would be great. This way I wouldn't have to go and edit every freaking song through hoster. My viewer is Microsoft Word.........Would it be good if I got a hold of Access? Isn't this HOLSTER database built through Access?

[mikedomi]

this info is stored in the kma header
no you have to use hoster or a hex editer to do this
1 at a time unless there is some one else who knows more about it then i do

but as far as i know that is the only way to do it

[nreel]

Post #5 by MrMark

Is there anyway to go into the database and change everything to uppercase?

IF you are talking about the Song Books and you have MSWord<--Registered Trademark of Microsoft Corporation, then, yes.

Open your SongBook.RTF in MSWord<--Registered Trademark of Microsoft Corporation, click on FORMAT, Click EDIT, CLick SELECT ALL, Click on FONT, Click the BOX next to ALL CAPS to CHECK it, Click APPLY, Click FILE, and Click SAVE.

If you are talking about making HOSTER's Songs.MDB all CAPS, you can copy the data from the Songs.MDB into MSWord<--Registered Trademark of Microsoft Corporation and perform the same procedure in the paragraph above.

Then, with a little more ingenuity, you can delete all the Data in the Songs.MDB and copy the "ALL CAPS" Data from MSWord<--Registered Trademark of Microsoft Corporation back to the SONGS.MDB.

[MrMark]

I figured out how to change everything into uppercase through word, no problem. My issue is as, In my hoster songbook database i have some of my songs in uppercase...........by this it sepreates the text into two different words...e.g. Nickelback in lower case would show up as a different entre as if it was in uppercase. So by changing word to all uppercase it still doesnt allow me to eliminate the different listings...........are you lost yet? Nickelback listed twice because of the upper and lowercase.....so I need to change everything to uppercase through hoster songbook, can it be done?

[nreel]

Unfortunately, the way Hoster is PROGRAMMED, even if you are, and I was, able to change the FONT to a FONT that FORCES upper case in the Songs.MDB, which you can ONLY do, directly, if you have MSAccess97<--Registered Trademark of Microsoft Corporation, and, or use MSAccess2000 <--Registered Trademark of Microsoft Corporation and CONVERT back and forth between MSAccess2000 and 97<--Registered Trademark of Microsoft Corporation, you will ONLY see HOSTER FORCING the FONT to appear in the STYLE HOSTER is PROGRAMMED to display...such as what is appearing in the "Song" and "Title" fields on the Hoster MAIN SCREEN...and uses the SAME FONT when CREATING a Hoster generated SONG LIST, which, COMPLETELY, disregards any FONT the SONGS.MDB is using.

So, until Hoster's SongBook Feature is programmed NOT to recognize SAME WORDED Songs as TWO SEPARATE Songs due to one Song being UPPER Case and ONE SONG being LOWER Case, here is another reason not to use printed Song Lists.