Find and Replce

[Question Boy]

Hello,

I am using the following

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

which open the find and replace dialog.

Is there a way to set the 'Look In:' & 'Match:' values from vba? If not,
are there any alternatives?

Thank you,

QB

 

[Question Boy]

For anyone else that might come across this post in the future, I found a
partial answer using sendkeys (not too fond of this method)

http://www.tkwickenden.clara.net/codeex/30.htm
http://support.microsoft.com/kb/q120912/

Any alternatives?

QB

 

[Manuel]

I'd be interested in finding out if there's a way to turn off the "Replace"
feature when calling Find and Replace in this manner.

 

[John W. Vinson]

Hello,

I am using the following

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

which open the find and replace dialog.

Is there a way to set the 'Look In:' & 'Match:' values from vba? If not,
are there any alternatives?

Thank you,

QB

That is ANCIENT, hard to read, and inefficient code. Yes, I know, the wizards
still use it... but the wizards are ancient, inept, and inefficient!

If you want to dynamically update records in a table - *use an Update query*
with parameters. For example,

strSQL = "UPDATE mytable SET thisfield = [Forms]![MyForm]![txtNewValue] WHERE
thatfield = [Forms]![MyForm]![txtOldValue];"

with appropriate form design and query execution.

 

[Dirk Goldgar]

... but the wizards are ancient, inept, and inefficient!

Why John, I'm surprised to see you talk about yourself that way!

 

[John W. Vinson]

Why John, I'm surprised to see you talk about yourself that way!

It's just one of those days... :-{(