FIND & REPLACE MACRO (Microsoft Access)

S

Shirley

I am building a macro to find and replace zeros (0) that are imported from
Excel (blank cells). I have used a combination of Select Object, RunCommands
and SendKeys to accomplish this action. It seems to work up to the point of
"REPLACE ALL" I can't find an action that would force "ENTER" to complete
the action. Any thoughts would be appreciated!
 
S

Steve Schapel

Shirley,

It is not 100% clear what you are trying to do here. But I would expect
that running an Update Query on your imported data, possibly employing the
Replace() function, would be the way to go here. Once you have set up your
Update Query, you can use an OpenQuery action in your macro to run the
update.
 

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 3
Find and replace macro for Special ^p - MS Word 0
Word macro that can call cells out of Excel for a find and replace 0
The expression you used has a function name Access can't find 2
Word Macro for multiple searches, incl. in footnotes 2
how can I use Word find and Replace to search inside a stringvariable (in a macro) 1
Loop Macro to edit Date 0
Access 2003 macro hangs--sendkeys not working 1

Top