Find and Replace

  • Thread starter Thread starter Keith Bent
  • Start date Start date
K

Keith Bent

How to I make a macro to automate find in replace for a
specific table column.
 
Keith,

There is the RunCommand,Replace macro action which you could use.
However, this simply opens the normal Find/Replace dialog, so is
probably not what you mean by "automate". It is possible to use a
macro with SendKeys actions for this purpose, but this is not
recommended, so I won't mention it :-) Probably a lot more applicable
would be the use of an Update Query. The details of this will depend
on which version of Access you are using.

- Steve Schapel, Microsoft Access MVP
 
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

MS word Find and Replace using Regex - Help required 0
Record Macros in Access 2003? 1
Paste into find dialog using macros. 3
FIND & REPLACE MACRO (Microsoft Access) 1
Find/Replace - from old to new 1
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Find / Replace 3
Find and Replace 1

Back
Top