using VBA to dictate criteria in Find and Replace dialog

A

ArielZusya

I've got a button on a data entry form that brings up the Find and Replace
dialog. Right now it comes up with the following criteria as default:

Find What: [blank]
Look In: [current field]
Match: Whole Field
Search: All
Match Case [unselected]
Search Fields As Formatted [selected]

I'd like to pass other criteria to the Find and Replace dialog. Is there a
way to do that without creating my own search form? I'd like the "Look In:"
to point to the entire database and the "Match:" to use "any Part of Field"
but I'm not sure how. Your help would be greatly appreciated! Thanks!
 
A

ArielZusya

Interesting... a little bit scary but it worked. Thanks!

John Spencer said:
The only way I know to do this is to use the notorious SendKeys function.

See the following article

ACC2000: How to Set Defaults for the Find and Replace Dialog Box
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q208923

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

ArielZusya said:
I've got a button on a data entry form that brings up the Find and Replace
dialog. Right now it comes up with the following criteria as default:

Find What: [blank]
Look In: [current field]
Match: Whole Field
Search: All
Match Case [unselected]
Search Fields As Formatted [selected]

I'd like to pass other criteria to the Find and Replace dialog. Is there
a
way to do that without creating my own search form? I'd like the "Look
In:"
to point to the entire database and the "Match:" to use "any Part of
Field"
but I'm not sure how. Your help would be greatly appreciated! Thanks!
Click to expand...
Click to expand...
 

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 3
Find and Replce 5
Automating a Find and Replace. 2
find & replace 3
access97 to 2002 search button conversion error 1
Using Like operator in VBA 6
Find & Replace 1
Manipulate Find Replace Dialog Box using Code 4

Top