Microsoft access

[Beavis]

both questions pertain to MS access:

is there a way in MS Access to change the case on all the song names at one time?

is there a way to delete a blank space before the song name begins (by this i mean some songs the spacebar was hit before typing the first letter) i want to delete all the blank spaces with one click.

[Skybird74]

Originally Posted by Beavis

both questions pertain to MS access:

is there a way in MS Access to change the case on all the song names at one time?

is there a way to delete a blank space before the song name begins (by this i mean some songs the spacebar was hit before typing the first letter) i want to delete all the blank spaces with one click.

It really would be better to do all your editing from within Hoster. That way the database will be corrected & new songbooks will also show all your changes.

[Beavis]

i do do all my edititing through hoster, but there are to many songs to correct 1x1

why wouldnt it change in the songbook if i edit through access
? its still the database.

im not so worried about the change case because i can edit that in word.

[Roy Dennis]

Not recommended but,
You can remove leading spaces in Access by selecting the column then use find and replace. From the Match selection drop down box select Start of field, in the find enter a blank space, in the replace leave blank then hit replace all. If you try this bear in mind that if you ever rebuild the songbook all the changes will be lost.

However as Skybird stated, it is best to do all your editing in Hoster Edit dialog, if you click on a column header all the leading spaces will appear at the top for you to manually edit them one at a time but the change will be permanent.

You can change the case easy for your songbook in Microsoft Word processor.
It depends on your version of word but in my Word 2000 that I still use, from the format menu is an option for change case, I always select "Sentence case" this will change the whole book in a matter of minutes.

[Roy Dennis]

Originally Posted by Beavis

why wouldnt it change in the songbook if i edit through access
? its still the database.

im not so worried about the change case because i can edit that in word.

As I stated above, if you ever rebuild Hosters database all your changes would be lost because Hoster builds its database from the headers in the song files.

[Beavis]

i undertsand the loss, but its a quick fix after i edit it. correct ?

[Roy Dennis]

yes

[bryant]

Originally Posted by Roy Dennis

yes

I hate to ask this, however, how does one get into Access?

[Roy Dennis]

It is one of the Microsoft Office programs, you either have to purchase Microsoft Office Professional or purchase it as a separate item.
Once installed on your computer you start it like any other program in your Start/programs list, if it is on your computer you can open your songs.mdb by right clicking it and selecting "Open With" and it will appear in the list.

I'd say, if you haven't already got it, stay away from it, you can cause more problems to Hoster using it.
If you have Microsoft office Excel version 2007 or above you can open the songs.mdb in that to view it, sort data and print lists.

[ddouglass]

Bevis - using find and replace in Access is going to be trick as all words have a space between them. I don't think that is going to be an easy task to do either with Access or in the Edit through Hoster. You will need to pay very close attention and approve or skip each one.

Bryant - as Roy has stated Access is a Microsoft Office program. If you don't know what you are doing in it, I also recommend not trying to use it.

To all - the only use you should really make of Access is for viewing your database files, and only by making a copy of the file and view that rather than the original file created by Hoster. The files created by Hoster are done in a very old version of Access engine. If you open it in a newer version of Access the file can get updated and therefore corrupted where Hoster will not work with it correctly.

[Beavis]

dale, would it correct it in the songbook after i edit it in access ?

[Beavis]

[quote=Roy Dennis;110737]Not recommended but,
You can remove leading spaces in Access by selecting the column then use find and replace. From the Match selection drop down box select Start of field, in the find enter a blank space, in the replace leave blank then hit replace all. If you try this bear in mind that if you ever rebuild the songbook all the changes will be lost.QUOTE]

it seemed to work ok, it took me a moment to figure out the enter a space in the find field, cause when i deleted the entery it wouldnt let me replace all.

will it apply to the songbook now ?

[Beavis]

After testing it, it worked perfectly Roy !! thank you, my songbook looks right now !! plus even if i rebuild my DB its a 1 minute fix.

[bryant]

"Bryant - as Roy has stated Access is a Microsoft Office program. If you don't know what you are doing in it, I also recommend not trying to use it."

Was just curious, as I hear about it a lot on here, and seems I don't have it anywhere. I was substitute teaching a computer class the other day and one of the kids mentioned it.

[Beavis]

its kinda of like excel.

[Lonman]

Originally Posted by bryant

"Bryant - as Roy has stated Access is a Microsoft Office program. If you don't know what you are doing in it, I also recommend not trying to use it."

Was just curious, as I hear about it a lot on here, and seems I don't have it anywhere. I was substitute teaching a computer class the other day and one of the kids mentioned it.

It doesn't come with Windows, Access is a separate add-on program or comes bundles in Microsoft Office Pro. Although some newer versions of Windows Vista & 7 do come with a demo version of Office but I don't believe I saw Access bundled in at least the ones I bought.