Find and Replce

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

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
 
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.
 
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
Click to expand...

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.
 
Back
Top