Find and Replace coding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Noemi - 20 Mar 2005 23:59 GMT

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

Reply to this Message

Duane Hookom - 21 Mar 2005 01:42 GMT

Try creating and running an update SQL statement.

Signature

Duane Hookom
MS Access MVP

> Hi
> Can someone please help me with the coding to use to find and replace a
[quoted text clipped - 5 lines]
> Thanks in advance
> Noemi

Reply to this Message

Noemi - 21 Mar 2005 03:56 GMT

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

> Try creating and running an update SQL statement.
>
[quoted text clipped - 7 lines]
> > Thanks in advance
> > Noemi

Reply to this Message

Duane Hookom - 21 Mar 2005 04:34 GMT

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.

Signature

Duane Hookom
MS Access MVP

> Hi Duane
> Could you please explain, do you mean create a query then put into SQL and
[quoted text clipped - 20 lines]
>> > Thanks in advance
>> > Noemi

Reply to this Message