Find and Replace

  • Thread starter Thread starter Keith Bent
  • Start date Start date
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
 

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

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
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Update Query across entire table 1

Back
Top