Help Please - is this possible

  • Thread starter Thread starter Stephen Wright
  • Start date Start date
S

Stephen Wright

Hello, I am running Acc2000 and want to allow users to
selectively change data using find and replace.

The way that think would work to control the operation
would be to have a text box (Region) with the control
source being an sql grouping the regions that will need
amending and another text box grouping the new regions. I
would the want to transfer the content of the text Box
Region to the Find What Section of the Find & Replace
dialogue and the other text box content (NewRegion) to
the Replace dialogue.

The table with the Data to amend is called Addresses
and the Region Code is stored in Region.


I hope I have explained this ok - many thanks

Stephen
 
Hi Stephen,

As I read you, you have a table called Addresses with a field called
Region which contains a region code of some kind, and you want to be
able to update specific region codes (e.g. if the code is "XXX" you want
to change it to "YYY").

You can do that with an update query, with parameters that it gets from
the Region and NewRegion textboxes on your form. The SQL view of the
query will look something like this:

UPDATE Addresses
SET Addresses.Region = Forms!MyForm!NewRegion
WHERE Addresses.Region = Forms!MyForm!Region
 
Hi John.

Thanks, sorry for the delay in replying I've been trying this out to update
other fields
it's saved me hours of find of replace

Thank you

Stephen
 
Back
Top