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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FIND & REPLACE MACRO (Microsoft Access) 1
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Macro Find and Replace 4
Macro / replace (wildcards) 1
Replace Function 2
Find and Replace in PowerPoint 1
Shape Arrays VBA 0
Find and Replace 4

Back
Top