问题 - 在表单中搜索记录 [英] Problem - Searching Records In The Form
问题描述
使用MS ACCESS 2002
我开发了一个FORM，在该FORM中，我创建并添加了一个SEARCH BUTTON，然后我创建了一个SUB-FORM，这样当END USER点击它将弹出SUB-FORM的FORM，并在该SUB-FORM中添加了我想要查看的信息的所有FIELDS。创建SUB-FORM以进行实际搜索。
但是，当我想搜索一个RECORD并在我创建的FORM中输入特定RECORD的DATA到FIELDS时，它不会让我！当我将其输入FIELD时，我想让MS ACCESS拉出RECORD。我在搜索记录时检索信息的方式是滚动数据库中的所有记录，或者如果我点击查找按钮。标准MS ACCESS工具栏中的按钮选项。
我想使用我在FORM中创建的FIELD选项并输入信息，以便MS ACCESS可以提取该特定记录，有人可以帮助我吗？我怎么能够：
1.）在我创建的字段中输入数据
2.）让MS ACCESS通过在我创建的FIELDS上键入信息来拉取记录FORM。
非常感谢您的帮助！
Using MS ACCESS 2002
I developed a FORM, and within that FORM, I created and added a SEARCH BUTTON, and then I created a SUB-FORM, so that when an the END USER clicks on the FORM it will POP-UP the SUB-FORM, and in that SUB-FORM I added all the FIELDS of the information I wanted to view. The SUB-FORM was created to do the actual SEARCHING.
However, when I want to search a RECORD and I type in DATA of a specific RECORD into the FIELDS in the FORM I created, it does not let me! I would like to have MS ACCESS pull the RECORD when I type it into the FIELD(s). The way I am retrieving the information when I am searching a RECORD is by scrolling through all the RECORDS in the DATABASE, or if I click on the "FIND" button option in the standard MS ACCESS toolbar.
I want to use the FIELD option that I created in the FORM and type in the information so that MS ACCESS can pull that specific record, can someone help me with this? How am I able to:
1.) Enter Data into the Fields I created
2.) Have MS ACCESS pull the Record by typing information on the FIELDS I created in the FORM.
Thanks so much in advance for your help!
推荐答案
在Access中搜索的方法有很多种。
我个人从不创建搜索表单，但指示我的用户使用右键单击弹出菜单。这将提供一个非常多功能的搜索工具（包括部分匹配），我的用户真的感觉控制。
想法？
Nic; o ）
There are many ways to search in Access.
Personally I never create searchforms, but instruct my users to use the right-click pop-up menu. This will give a very versatile search facility (inclucing partial matches) and my users really feel in control.
Idea ?
Nic;o)
你用的主要形式是什么？
你能做的就是这个
表单，使用表单标题，在那里添加您的搜索文本框，然后一个btn
表单基于您要搜索的表或查询
你可以在click事件上使用表单的'过滤器事件
简单的例子
表是基于一个名为tblMeow的表，它有以下字段ID，Cat，Name
u在表头中有两个文本框txtCat和txtName，以及一个名为cmdFind的btn
What is your main form used for, anything?
What u could do is this
On a form, use the form header, add your search textboxes in there, then a btn
The form is based on a table or query that u want to search on
What u can then on the click event is to use the form''s filter event
simple example
form is based on a table called tblMeow, it has the following fields ID, Cat, Name
u have a two textboxes txtCat and txtName in the form header, and a btn called cmdFind
大家好，感谢你以前的帮助！现在，我希望能够在我创建的表单上搜索多个字段。目前的问题是我只能通过一个搜索字段来提取记录。例如，让我解释一下我想要的内容：
我希望Access通过键入字段FirstName或LastName，OR Location，OR，STATUS来拉取记录，是否可以在ACCESS做到这一点？我的FORM中有大约8个FIELDS，我想使用任何FIELD来取出RECORDS，这可能吗？非常感谢！
Hello People, and thanks for your previous help! Now, I would like to be able to search in more than one field on the form that I created. The current problem is I am only able to pull out records by using only ONE search field. For example, let me explain what I would like:
I would like Access to pull records by either typing into the fields FirstName, or LastName, OR Location, OR, STATUS, can I do that in ACCESS? I have about 8 FIELDS in my FORM and I would like to use any FIELD to pull out RECORDS, is that possible? THANKS SO MUCH!
这篇关于问题 - 在表单中搜索记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
