Acc2000: Change defaults for Find dialog box doesnt work using runtime

M

Mark

Hi all,

I followed this MSKB article to set the find dialog defaults in an A2k
database:

ACC2000: How to Set Defaults for the Find and Replace Dialog Box
(208923) - This article describes how to set different default settings for
the Find and Replace dialog box in Microsoft Access 2000

It advises to use a sendkeys macro to change the settings on the dialog box.
I also mapped the macro to ^F using an autokeys macro.

It works fine on the full version of access, but on the runtime the find
defaults aren't changed.

On the runtime, after I use the find macro, and then close the find macro
and close the form I was searching, I see "Setting up wizards" appear in the
status bar, and a progress bar that doesn't move. This hogs 100% CPU time on
the PC, and an attempt to exit the database causes access to crash, or
require an end-process in task manager.

I know people generally advise against using sendkeys, so please advise if
there another way (code?) to change the find dialog box to enable 'search
fields as formatted' and 'any part of field' as defaults?

Thanks,

Mark
 

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

access97 to 2002 search button conversion error 2
Default find and replace parameters 0
How do I change the default Match list in Find and Replace box? 2
Change defaults in Find dialog box 0
forms: find and replace dialog box: change default for match field 4
Manipulate Find Replace Dialog Box using Code 3
Excel wait for Find Replace dialog box in Word 4
SendKey to open find dialog 0

Top