查找 - 搜索 - 匹配：字段的任何部分 [英] Find - Search - Match: Any Part of Field

问题描述

有没有办法将默认搜索更改为任何部分字段

而不是整个字段？我在字段中搜索

时所做的第一件事就是将默认设置从整个字段改为

到字段的任何部分。因为这样我就不必键入

整个单词我正在寻找。对于使用我的数据库的所有人来说，这是非常令人沮丧的。任何帮助将是

赞赏。谢谢。

Is there any way to change the default search to "Any Part Of Field"
instead of whole field? The first thing I ever do when searching for
something in a field is change the default setting from "Whole Field"
to "Any part of field" because that way I don''t have to key in the
entire word I''m searching for. It is especially frustrating having to
explain this to all of the people using my database. Any help would be
appreciated. Thanks.

推荐答案

更改下面的设置：

工具|选项|编辑/查找

设置默认查找/替换为常规搜索。


如果要在启动代码中以编程方式执行此操作：

Call SetOption（" Default Find / Replace Behavior"，1）

-

Allen Browne - Microsoft MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" Pete" <所以********** @ netzero.net>在消息中写道

news：11 ********************** @ g14g2000cwa.googlegr oups.com ...

Change the setting under:
Tools | Options | Edit/Find
setting Default Find/Replace to General Search.

If you want to do this programmatically in your startup code:
Call SetOption("Default Find/Replace Behavior", 1)
--
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.

"Pete" <so**********@netzero.net> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

有没有办法将默认搜索更改为任何部分字段
而不是整个字段？我在字段中搜索某些内容时所做的第一件事是将默认设置从整个字段更改为字段的任何部分。因为这样我就不必键入我正在寻找的整个单词。特别令人沮丧的是，不得不使用我的数据库向所有人解释这一点。任何帮助都将受到赞赏。谢谢。

Is there any way to change the default search to "Any Part Of Field"
instead of whole field? The first thing I ever do when searching for
something in a field is change the default setting from "Whole Field"
to "Any part of field" because that way I don''t have to key in the
entire word I''m searching for. It is especially frustrating having to
explain this to all of the people using my database. Any help would be
appreciated. Thanks.

Pete写道：

Pete wrote:

有没有办法将默认搜索更改为领域的任何部分
而不是整个领域？我在字段中搜索某些内容时所做的第一件事是将默认设置从整个字段更改为字段的任何部分。因为这样我就不必键入我正在寻找的整个单词。特别令人沮丧的是，不得不使用我的数据库向所有人解释这一点。任何帮助都将受到赞赏。谢谢。

Is there any way to change the default search to "Any Part Of Field"
instead of whole field? The first thing I ever do when searching for
something in a field is change the default setting from "Whole Field"
to "Any part of field" because that way I don''t have to key in the
entire word I''m searching for. It is especially frustrating having to
explain this to all of the people using my database. Any help would be
appreciated. Thanks.

您是否让人们浏览原始数据？馊主意。构建一个前端

结束GUI并连接到一个隐藏在用户之外的后端。


所以，也许你有一个来自连续的查看或某些，用户

是否右键单击要搜索的列？


构建一个正确的搜索表单。我这样做的方法是将表单拆分为

二，顶部包含一堆未绑定的文本框，为用户检查

框，组合等为

搜索建立他/她的标准。顶部还有一个标记为搜索的按钮，当

用户按下它时，代码运行以根据提供的标准

构建查询。然后，您可以自动预先添加和删除通配符，以获得
文本值，组合值（如果您没有使用系统生成的PK和

FK值，那么你也可能想要一个清除的东西。按钮

重置搜索。表格的下半部分包含一个子表格

显示您的数据。


HTH


Edward

Are you letting people browse the raw data? Bad idea. Build a front
end GUI and connect to a back-end that''s hidden from the users.

So, maybe you have a from in Continuous view or somesuch, and the user
is right-clicking on a column to search?

Build a proper search form. The way I do it is to split the form into
two, with the top part containing a bunch of unbound text boxes, check
boxes, combos etc. for the user to build his/her criteria for the
search. The top part also has a button marked "Search", and when the
user presses it code runs to build a query based on the criteria
supplied. You can then automatically pre- and ap-pend wildcards to
text values, combo values (if you''re not using system-generated PK and
FK values, natch) etc. You''ll also probably want a "Clear" button to
reset the search. The lower half of the form contains a subform to
display your data.

HTH

Edward

Allen，


我想说谢谢！这让我疯了好几个月。每个新员工都需要培训他们从全场

转到任何部分......。行为。我非常感谢你的帖子。我已经成功将这个成功添加到我的总机，所有其他表格都可以工作

太棒了！


Peace，

Joseph

Allen,

I wanted to say Thank You! This has driven me crazy for months. With
every new employee I have to train them to move from the "Whole Field"
to "Any Part..." behaviour. I am very appreciative of your post. I
added this successfully to my switchboard and all the other forms work
great!

Peace,
Joseph

这篇关于查找 - 搜索 - 匹配：字段的任何部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！