访问DLookup以搜索整个表（字段+行） [英] Access DLookup to Search Entire Table (Field+Row)

问题描述

美好的一天人们！


我正在尝试在我的表格上进行Dlookup或任何查找选项。


所以我已经拥有我的表格有一个搜索选项，工作正常，从我的桌子上得到我想要的日期。


问题是我试图放一个文本框或者我应该放什么该框显示另一个表中的信息。我知道这听起来不太清楚我会简化！


表格：列表链接到

表格人员名单

字段：小隔间号码，姓氏等

在我的表格上，我有搜索选项，根据我放的文字，它给我小隔间编号和最后一个与我的搜索相对应的名称（该选项工作正常）


问题出在哪里：

我有另一个名为Cubicle number的表将所有小隔间编号作为字段

字段：AA01，AA02，AA03（每个字段中只有1个名称）


我想要的是什么do在同一个表单上放了2个文本框，所以如果我写Mason的话。在我的搜索条件中，它将查看整个小隔间号码。表并给出了与搜索匹配的日期（字段和行）

解决方案

Mass144，


欢迎来到字节！


恐怕我仍然无法理解你的问题。请查看要求好的链接问题首先，然后提供更多信息。


关于你的最后一段：

我在尝试什么要做的是在同一个表格上放两个文本框，所以如果我写Mason，在我的搜索条件中，它将查看整个小隔间号码。表格并给出了与搜索匹配的日期（字段和行）

您可能会对搜索的工作方式产生误解。 MS Access确实有字段，但它没有行 - 就像MS Excel一样。 MS Access可以返回特定记录的索引，因为通常记录具有将每个记录标识为不同的索引。


此外，您的帖子中不清楚AA01的字段是什么，AA02等用于。


您可以提供的任何其他信息都会有所帮助，因为您还没有真正给我们任何工作。


谢谢。

所以基本上...我正在尝试基于整个表而不是字段特定的搜索选项。

我希望该搜索给我字段名称和与我的搜索相关的数据

展开 | 选择 | Wrap | 行号

Good day people!

I am trying to do a Dlookup or any lookup option on my form.

so I already have my form with a search option that works fine and get the date I want from my table.

The problem is that I am trying to put a text box or what ever I should put so that box shows the info from another table. I know it doesn''t sound clear put here i''ll simplify!

Form: List is link to
Table "Personnel list"
Field: Cubicle number, Last name, etc
On my form, I have the search option that according to the text I put, it gives me the cubicle number and the last name that correspond to my search (That option works fine)

Where the problem is:
I have another table named "Cubicle number" that have all cubicle number as a field
Field: AA01, AA02, AA03 (each field only have 1 name in it)

What I am trying to do is put 2 more text box on the same form so if I write "Mason" in my search criteria, it will look the entire "Cubicle number" table and gives me the date (Field and row) that matches the search

解决方案

Mass144,

Welcome to Bytes!

I am afraid I am still having problems understanding your question. Please review this link on Asking Good Questions first, and then provide more informaiton.

Concerning your last paragraph:

What I am trying to do is put 2 more text box on the same form so if I write "Mason" in my search criteria, it will look the entire "Cubicle number" table and gives me the date (Field and row) that matches the search

There may be a misunderstanding on your part as to how a search works. MS Access does have Fields, but it does not have "rows"--as MS Excel has. MS Access can return the index of a particular record, as usually a record has an index identifying each record as distinct.

Additionally, it is unclear from your post as to what the fields AA01, AA02, etc. are used for.

Any additional information you can provide for this would be helpful, as you have not really given us anything to work with.

Thanks.

so basically... I''m trying to do a search option based on the entire table instead of field specific.
I want that search to give me the field name and the data associated to my search

Expand|Select|Wrap|Line Numbers

这篇关于访问DLookup以搜索整个表（字段+行）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！