Find and Replace coding

[Guest]

Hi
Can someone please help me with the coding to use to find and replace a
value from a table.
I know it can be done by using the actual find and replace box but I have
looked everywhere but I cant find the coding to use in VBA to perform the
same action.

Thanks in advance
Noemi

 

[Duane Hookom]

Try creating and running an update SQL statement.

 

[Guest]

Hi Duane
Could you please explain, do you mean create a query then put into SQL and
attach to the coding if so I have tried that but since the value I wish to
paste is stored as a variable I can not add it to the query.

Hopefully there is another way or if I have mis-understood you could you
please explain.

Thanks
Noemi

 

[Duane Hookom]

You haven't provided any table or field names or memory variables or sample
records etc. How about some help? We can't provide specifics without some
specifications from you.