423,818 Members | 2,250 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,818 IT Pros & Developers. It's quick & easy.

Change Default setting for the Search tool?

P: n/a
when our users press "Search and Replace" all is fine exept that they
ALWAYS have
to change the criteria "Match the hole field" to "Part of the field"
(ruffly spelled...(swedish lang)).
-Is there anyway to change/ add some code so that the search dialogbox
shows with this already done? That would make me happy

Thank you for any clue!

Robert

Aug 11 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Go to:
Tools | Options | Edit/Find

Set Default find/replace behavior to:
General Search

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<Ro*********@yahoo.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
when our users press "Search and Replace" all is fine exept that they
ALWAYS have
to change the criteria "Match the hole field" to "Part of the field"
(ruffly spelled...(swedish lang)).
-Is there anyway to change/ add some code so that the search dialogbox
shows with this already done? That would make me happy

Thank you for any clue!

Robert

Aug 11 '06 #2

P: n/a
On 11 Aug 2006 05:11:08 -0700, Ro*********@yahoo.com wrote:

Tools Options Edit/Find
There probably also is a SetOption that does the same in VBA.

-Tom.

>when our users press "Search and Replace" all is fine exept that they
ALWAYS have
to change the criteria "Match the hole field" to "Part of the field"
(ruffly spelled...(swedish lang)).
-Is there anyway to change/ add some code so that the search dialogbox
shows with this already done? That would make me happy

Thank you for any clue!

Robert
Aug 11 '06 #3

P: n/a
Allen Browne wrote:
Go to:
Tools | Options | Edit/Find

Set Default find/replace behavior to:
General Search
Allen, is this app specific or for the whole of the user's installation
(ie, default behaviour will be set for all the user's apps)?

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Aug 11 '06 #4

P: n/a
The option is stored under:
\HKEY_CURRENT_USER\Software\Microsoft\Office\x.0\A ccess\Settings\
where x is your version.

It therefore applies to all databases opened by this user on this machine.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tim Marshall" <TI****@PurplePandaChasers.Moertheriumwrote in message
news:eb**********@coranto.ucs.mun.ca...
Allen Browne wrote:
>Go to:
Tools | Options | Edit/Find

Set Default find/replace behavior to:
General Search

Allen, is this app specific or for the whole of the user's installation
(ie, default behaviour will be set for all the user's apps)?

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Aug 11 '06 #5

P: n/a
You're right, Tom. You can GetOption or SetOption on:
"Default Find/Replace Behavior"

I seem to recall getting frustrated with that though. With some of these
options, there seemed to be a delay before it was applied. Can't remember if
it needed a restart.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tom van Stiphout" <no*************@cox.netwrote in message
news:mn********************************@4ax.com...
On 11 Aug 2006 05:11:08 -0700, Ro*********@yahoo.com wrote:

Tools Options Edit/Find
There probably also is a SetOption that does the same in VBA.

-Tom.

>>when our users press "Search and Replace" all is fine exept that they
ALWAYS have
to change the criteria "Match the hole field" to "Part of the field"
(ruffly spelled...(swedish lang)).
-Is there anyway to change/ add some code so that the search dialogbox
shows with this already done? That would make me happy

Thank you for any clue!

Robert

Aug 11 '06 #6

P: n/a
Thanks!
I have been in Tools | Options | Edit/Find before but it newer had any
effekt.
The key was to restart Access. I have version Access 2003
Thank you for letting me know! (On monday, I will be "The man" at the
office :) )
This is a simple issue you can say, but when users run in to it every
ten minutes, its not.

Robert

Aug 11 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.