K
Keith Bent
How to I make a macro to automate find in replace for a
specific table column.
specific table column.
S
Steve Schapel
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
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 applicablewould 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