[AccessD] Change default setting on find dialog box

[Jim Hewson]

I needed to search a particular field using a button on a form.
I used the following code on the on click event:

​DoCmd.GoToControl Screen.PreviousControl.Name
    err.Clear
    SendKeys "%ha%n", False ' sets Match to "Any Part of Field"
    DoCmd.RunCommand acCmdFind

On Wed, Oct 12, 2016 at 7:17 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> That gets me three options: fast search, general search, start of field
> search.  What I'm looking for when I do a find or replace (like looking for
> a value in a table in datasheet view) is Look in: Current document, Match:
> any part of field.
>
> Any way to set that globally?
>
> TIA
>
> r
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Stuart McLachlan
> Sent: Wednesday, October 12, 2016 3:09 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Change default setting on find dialog box
>
> File - Options - Client Settings - Default find/replace behaviour.
>
>
>
> On 12 Oct 2016 at 14:39, Rocky Smolin wrote:
>
> > Lambert:
> >
> > Thank you.  But I was looking for how to set the options through the
> > Access UI.
> >
> > r
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of Heenan, Lambert Sent: Wednesday, October 12, 2016 9:27 AM To:
> > 'Access Developers discussion and problem solving' Cc: 'Off Topic'
> > Subject: Re: [AccessD] Change default setting on find dialog box
> >
> > Should be the same as all the previous versions,
> >
> > See here for example
> > https://bytes.com/topic/access/answers/758233-code-find-replace-defaul
> > t-part -field
> >
> >
> >     'Set to General Search - Part of Field
> >     Application.SetOption "Default Find/Replace Behavior", 1
> >
> >       'do whatever you like in here, but Reset Option at some point
> >
> >     'Reset to Fast Search - Whole Field
> >     Application.SetOption "Default Find/Replace Behavior", 0
> >
> >
> > Lambert
> >
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of Rocky Smolin Sent: Wednesday, October 12, 2016 10:45 AM To: 'Access
> > Developers discussion and problem solving' Cc: 'Off Topic' Subject:
> > [AccessD] Change default setting on find dialog box
> >
> > Dear List:
> >
> >
> >
> > Is there a way to change the default setting on the find/replace
> > dialog box in Access 2010?  Searched the internets but couldn't find
> > an answer.
> >
> >
> >
> > MTIA
> >
> >
> >
> >
> >
> > Rocky Smolin
> >
> > Beach Access Software
> >
> > 760-683-5777
> >
> >  <http://www.bchacc.com> www.bchacc.com
> >
> >  <http://www.e-z-mrp.com> www.e-z-mrp.com
> >
> > Skype: rocky.smolin
> >
> >
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>