Quote:
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.