Find And Replace Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a macro that will search 1 specific field and
replace any values found there. Specifically, I'm working on a travel
database, and whilst individual travellers are logged with a single Purpose
Of Travel code, stats are based on groups of codes. So I'd like to build a
macro to find and replace eg. POT1 with POT 1, 2, 3, 4, 5. It would also need
to replace POTS 2, 3, 4 and 5 as well.

Can this be done, and can it be made fairly idiot proof. I spent a while on
the Access Help section, buit nothing there seems to help
 
hehe Sorry to laugh, but Access help is no help when you
don't know what you're looking for.

You question, Yes, create a recordset and loop through it
and use the InStr function on the field to find the text,
and replace it with what ever you want.
 
Back
Top