ACC97: How to Set Defaults for the Find Dialog Box

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q120912

Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

This article describes two methods that you can use to invoke the Find dialog box with different default settings.

Back to the top

You can also change these settings by invoking the Find dialog box with the DoMenuItem action (or RunCommand in Access 97) by using the SendKeys action to select different settings. For example, you can invoke the Find dialog box by using a macro with the following actions:

   In Access 97:

      SendKeys
         Keystrokes: %ha%n
         Wait: No
      RunCommand
         Command: Find

   In Access versions 2.0, 1.0, and 1.1, and in version 7.0:

      SendKeys
         Keystrokes: %ha%n
         Wait: No
      DoMenuItem
         MenuBar: Form
         MenuName: Edit
         Command: Find

This macro can then be assigned to a command button, to a button on a form, or to an event on a form. When you run this macro, the Find dialog box appears with Any Part Of Field selected in the Match box (or Where box in versions 2.0, 1.0, and 1.1). The keystrokes sent by the SendKeys action are:

ALT+H to select the Match box
"a" to select Any Part Of Field
and ALT+N to select the Find What box

The SendKeys action must come before the call to open the dialog box, although it may seem that the call to open the dialog box must come first. However, if you put the call to open the dialog box first, the macro runs the RunCommand action and then waits for the dialog box to close before the macro then continues to the next action (the SendKeys action). The SendKeys action sends your keystrokes to the form.

The following table lists the keystrokes to send to select various items in the Find dialog box.

In Access 97 and version 7.0:

   Option                       Setting             Keystrokes
   -----------------------------------------------------------
   Match                        Any Part of Field   %ha
   Match                        Start of Field      %hs
   Search Only Current Field    <cleared>           %e
   Match Case                   <selected>          %c
   Search Fields as Formatted   <selected>          %o
   Search                       Up                  %ru
   Search                       Down                %rd

In Access versions 2.0, 1.0, and 1.1:

   Option                       Setting             Keystrokes
   -----------------------------------------------------------
   Where                        Any Part Of Field   %ha
   Where                        Start Of Field      %hs
   Search In                    All Fields          %l
   Match Case                   <selected>          %s
   Search Fields As Formatted   <selected>          %o
   Direction                    Up                  %u

You can combine these keystrokes to make multiple selections. For example, the following actions open the Find dialog box with Start Of Field selected in the Match box. Then, the actions clear the Search Only Current Field box (or select the All Fields option in version 2.0). And then the actions select Up in the Search.

   In Access 97:

      SendKeys
         Keystrokes: %hs%e%ru%n
         Wait: No
      RunCommand
        Command: Find

   In Access versions 2.0, 1.0, and 1.1, and version 7.0:

      SendKeys
         Keystrokes: %hs%e%ru%n  (%hs%l%u%n in version 2.0 and 1.x)
         Wait: No
      DoMenuItem
         MenuBar: Form
         MenuName: Edit
         Command: Find

Back to the top

REFERENCES

For more information about the Find command, search the Help Index for "Find", and then "Finding data using Filters", or ask the Microsoft Access 97 Office Assistant.

For more information about the SendKeys action, search the Help Index for "SendKeys", and then "SendKeys Statement", or ask the Microsoft Access 97 Office Assistant.

For more information about running macros, search the Help Index for "Macros", click Running, and then click Run a Macro. You can also ask the Microsoft Access 97 Office Assistant.

Back to the top

APPLIES TO

Microsoft Access 97 Standard Edition
Microsoft Access 1.0 Standard Edition
Microsoft Access 1.1 Standard Edition
Microsoft Access 2.0 Standard Edition
Microsoft Access 95 Standard Edition

Back to the top

kbhowto KB120912

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top