Discard MTU in Programs

[Ernie]

When I go into Select Multiple no songs that I've changed come up. It stays blank. When I opened songs mdb I cleaned up 6 songs along with artist. You're not talking about going into Songs mdb and hitting ctrl F and then opening Replace are you? Your only talking about physically correcting the underscors on the actual list one at a time. Is there anything I need to have set on the Select Multiple window?

Thanks again,
Ernie

[ddouglass]

Select Multiple will not show any songs until you enter a search criteria and click on find.

[mindonstrike]

Originally Posted by Ernie

When I go into Select Multiple no songs that I've changed come up. It stays blank. When I opened songs mdb I cleaned up 6 songs along with artist. You're not talking about going into Songs mdb and hitting ctrl F and then opening Replace are you? Your only talking about physically correcting the underscors on the actual list one at a time. Is there anything I need to have set on the Select Multiple window?

Thanks again,
Ernie

In songs.mdb click the top of the title or artist column to highlight it. Press control F and replace tab. put an underscore in the find field and a space in the the replace field. Be sure it is set for finding in any part of the field. and click next and replace to do one at a time or "replace all" if you don't want to preview the song name before replacing.

Don't save anything or convert anything if Access asks (it did this automaticly). Close Access and Open Hoster and select the songs you changed and click apply. And you are done.

You don't have to have a separate change/save session for each column. Make all your changes for title and then make all your changes for artist and then close access and do your thing in Hoster.

[Ernie]

Mindonstrike,
I replaced ALL in Access. Now, in Hoster you said... Select the songs you changed and click apply. Select what songs, where? I went to tools, edit songs, select multiple and there are no songs. How do I get the list of songs that I took care of in Access. By the way I have no idea what songs were taken care of in Access, because I had a ton of them. Still confused!?!? Right now my one brain cell is in overdrive.

Thanks,
Ernie

[Ernie]

I just tried something... I went to Edit Songs, selected Multiple Songs. In the Match Box I put *, ticked Title and Artist, then hit find. A bunch of songs came up. I then hit Apply, and a box came up saying Modifying Songs DB and kma File Headers. It looks like it's going to process every song in my kma list, because it went from 0 and is going to 25480. Does this sound right???

Thanks Again,
Ernie

[laddie]

Originally Posted by Ernie

I just tried something... I went to Edit Songs, selected Multiple Songs. In the Match Box I put *, ticked Title and Artist, then hit find. A bunch of songs came up. I then hit Apply, and a box came up saying Modifying Songs DB and kma File Headers. It looks like it's going to process every song in my kma list, because it went from 0 and is going to 25480. Does this sound right???

Thanks Again,
Ernie

Yep, that sounds right!

[mindonstrike]

Originally Posted by Ernie

I just tried something... I went to Edit Songs, selected Multiple Songs. In the Match Box I put *, ticked Title and Artist, then hit find. A bunch of songs came up. I then hit Apply, and a box came up saying Modifying Songs DB and kma File Headers. It looks like it's going to process every song in my kma list, because it went from 0 and is going to 25480. Does this sound right???

Thanks Again,
Ernie

If you use the wildcard ( * ) it doesn't matter which buttons are depressed, everysong you have will come up. If they are a certain brand you could narrow your search that way or a range of bookid's. No matter though doing all of them shouldn't hurt anything, it just takes a lot longer.

Sam

[Ernie]

If there was a way to seperate the songs that have the underscores, I would have done it that way. With over 25,000 songs, it's just easier to let it run.