Re: Re: How to do a Specific Search with " "

message from Miracle on 14 May 2004

Doug, Thanks for your response.. actually it is a database for a website
in which product names have similiar names.. I have a product with an
item code of "abc" and then other items with a code of "abcd", "abcde"
and so on.. I am trying to do a search and replace to rename the
items.. problem is the item codes are also blended in another column in
the database which has the item codes for particular items mixed
together in the same box so that I can not use the search and replace
for the "whole field". If I do a search and replace for say "abc" using
the "any part of field" command to do the name change database wide, it
not only replaces abc to the new name but also replaces item "abcd" to
the new name with a d on the end. For example:

If I change item _ABC_ to a new name of _Sony_ it will also change item
_ABCD_ to a new name of _SonyD_ since it picks up the ABC in the
beginning of the item code. Grrrrrrrrrrr....... :eek:

Thanks,
Chris

John Vinson replied to Miracle on 15 May 2004

Could you post some actual examples? Given this, I don't see how ANY
process, automated or manual, can determine which ABC is a code and
which is part of some other code! Is there *any* sort of delimiter?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Archived message: Re: Re: How to do a Specific Search with " " (MS Access Forms)