How Do I force "Any Part of Field" in Find Box??

[Adams-Blake Co]

In an app I make use of the Access Find dialog box. I want it to default
to search in "Any Part of Field" instead of "Start of Field"? Is there a
way to do this in VB code? Are there any parms we can pass to this box
to control how it pops up??

Thanks,

Paul Raymond

--
*********************************************************
If you are in the publishing business, you must see PUB123 -
The Affordable Back-Office Software Solution for the Small Publisher.
Order-entry, invoicing, inventory, royalties, reports and more.
Adams-Blake Publishing http://www.adams-blake.com
mailto:ab...@ns.net
*********************************************************

[Dev Ashish]

Hi Paul,

The only way at present is to use Sendkeys to set the various options.
Beware of the Sendkeys bug though. Normally, I wouldn't advise the use of
Sendkeys for any functionality and suggest that you create your own form to
duplicate the Find Dialog box.

The commands are documented in the Knowledge Base in the following
article.

Article ID: Q120912 - How to Set Defaults for the Find Dialog Box
http://support.microsoft.com/support/kb/articles/q120/9/12.asp

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

Adams-Blake Co wrote in message <369FB274...@ns.net>...
:In an app I make use of the Access Find dialog box. I want it to default

:
:

[Adams-Blake Co]

What is the Sendkeys bug. I have not heard of this one. Can you elaborate??

Does anyone have a "find" form with some code behind it that I can "borrow"???

Thanks,

Paul

[Terry Wickenden]

The following is a straight copy from my web site

Open Find Dialog

This example opens the Find dialog box. 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. For
more information on this topic see ACC: How to Set Defaults for the Find
Dialog Box on the
Microsoft Knowledge Base.

To try this example out, create a button on a form and call it cmdFind. Put
the following code behind
the On Click event.

'***************** Code Start *******************
'This code was adapted by Terry Wickenden.
'from a macro example ion the Microsoft Knowledge Base

Private Sub cmdFind_Click()
Screen.PreviousControl.SetFocus
SendKeys "%ha%n", False
DoCmd.RunCommand acCmdFind
End Sub

'****************** Code End ********************

--
Hope this helps

Terry
"Conquer Access RunCommand Constants"
http://home.clara.net/tkwickenden/

E Mail remove Access to gain Access

[Dev Ashish]

Hi Paul,

Sendkeys are renowned to turn off your NumLock key when used.

-- Dev

Adams-Blake Co wrote in message <369FFCF3...@ns.net>...
:What is the Sendkeys bug. I have not heard of this one. Can you elaborate??

:
:Does anyone have a "find" form with some code behind it that I can
"borrow"???
:
:Thanks,
:
:Paul
:
:
:Dev Ashish wrote:
:
:> Hi Paul,
:>
:> The only way at present is to use Sendkeys to set the various options.
:> Beware of the Sendkeys bug though. Normally, I wouldn't advise the use
of
:> Sendkeys for any functionality and suggest that you create your own form
to
:> duplicate the Find Dialog box.
:>
:> The commands are documented in the Knowledge Base in the following
:> article.
:>

:> Article ID: Q120912 - How to Set Defaults for the Find Dialog Box
:> http://support.microsoft.com/support/kb/articles/q120/9/12.asp

:>
:> HTH
:> --
:> Dev Ashish (Just my $.001)
:> ---------------
:> The Access Web ( http://home.att.net/~dashish )
:> ---------------

:>
:> Adams-Blake Co wrote in message <369FB274...@ns.net>...

:> :In an app I make use of the Access Find dialog box. I want it to default
:> :to search in "Any Part of Field" instead of "Start of Field"? Is there a
:> :way to do this in VB code? Are there any parms we can pass to this box
:> :to control how it pops up??
:> :
:> :Thanks,
:> :
:> :Paul Raymond

:> :
:> :--

:
: