请使用搜索表单帮助 [英] Help Please with Search form
问题描述
您好，此网站上的用户似乎非常有帮助。我希望你们能帮助我。我一直在搜索过去两周如何在工作中为我的数据库创建搜索表单。我在使用代码方面并不是很有经验，尽管我已经能够将其中的一些代码拉掉。这就是我所做的：
我的同事使用两个数据库 - 一个用于跟踪器，另一个用于运送工具。 （因为他绝对没有计算机经验）然后我拿出他们的信息并将它们组合在一个查询中，然后将查询变成一个表。更新每周发生一次。
接下来我创建了一个新表单（未绑定）。然后我将查询make表的子表单放在页脚中。然后尝试更改字段名称以符合我自己的数据库。但我遇到了问题。好消息是，它正在做点什么。坏消息是，它没有按照我的意愿行事。如果有人可以引导我完成编写If is not isNull的步骤（我。等等......
1.我得到的不是Null。
2.我不理解我或我！
我希望用户能够输入3个字段以缩小搜索范围。（或者我本来就做了一个表格过滤器。）
请帮忙......
任何建议，指针或小费都适用。
Hello, the users on this site seem to be very helpful. I hope you guys can help me. I have been searching for the past 2 weeks on how to create a search form for my database at work. I''m not really experienced with working with code, although I have been able to pull a couple of them off. This is what I did:
I have two databases my co workers use - one for the trackers and one for the shipping guy. (Since he has absolutly no computer experience) Then I took their info and combined them in a query, then made the query into a table. The update happens once a week.
Next I created a new form (unbound). Then I put the sub form of the query make table in the footer. Then tried changing the field names to conform to my own database. But I am having problems. The good news is, it''s doing something. The bad news is, it''s not doing what I want it to. If someone can walk me through the steps of writing the If is NOT isNull(ME. blah....
1. I get the is not is Null.
2. I do not understand the Me. or Me!
I want the user to be able to enter maybe 3 of the fields in order to narrow the search. (or i would have just done a form filter.)
Please help...
Any suggestion, pointer or tip is apprieated.
推荐答案
你好，这个网站上的用户似乎非常有帮助。我希望你们能帮助我。我有过去两周一直在寻找如何在工作中为我的数据库创建一个搜索表单。我对使用代码并不是很有经验，尽管我已经能够将它们中的几个关闭。这就是我所做的：
我的同事使用了两个数据库 - 一个用于跟踪器，一个用于运送人员。（因为他绝对没有计算机经验）T我带着他们的信息并将它们组合在一个查询中，然后将查询变成了一个表。更新每周发生一次。
接下来我创建了一个新表单（未绑定）。然后我将查询make表的子表单放在页脚中。然后尝试更改字段名称以符合我自己的数据库。但我遇到了问题。好消息是，它正在做点什么。坏消息是，它没有按照我的意愿行事。如果有人可以引导我完成编写If is not isNull的步骤（我。等等......
1.我得到的不是Null。
2.我不理解我或我！
我希望用户能够输入3个字段以缩小搜索范围。（或者我本来就做了一个表格过滤器。）
请帮忙......
任何建议，指针或小费都适用。
Hello, the users on this site seem to be very helpful. I hope you guys can help me. I have been searching for the past 2 weeks on how to create a search form for my database at work. I''m not really experienced with working with code, although I have been able to pull a couple of them off. This is what I did:
I have two databases my co workers use - one for the trackers and one for the shipping guy. (Since he has absolutly no computer experience) Then I took their info and combined them in a query, then made the query into a table. The update happens once a week.
Next I created a new form (unbound). Then I put the sub form of the query make table in the footer. Then tried changing the field names to conform to my own database. But I am having problems. The good news is, it''s doing something. The bad news is, it''s not doing what I want it to. If someone can walk me through the steps of writing the If is NOT isNull(ME. blah....
1. I get the is not is Null.
2. I do not understand the Me. or Me!
I want the user to be able to enter maybe 3 of the fields in order to narrow the search. (or i would have just done a form filter.)
Please help...
Any suggestion, pointer or tip is apprieated.
这是从组合框中选择构建过滤字符串的示例。
Here is an example of building a filter string from the selections made from comboboxes.
哦，我看到!!!我刚刚回到学校，了解有关代码的更多信息。我很高兴能与它合作。希望我能够提出像你这样的提示和技巧。
我将尝试这个并告诉你我是怎么做的。非常感谢你的帮助！
Stephanie
Oh I see!!! I have just enrolled back into school to learn more about code. I am very excited to work more with it. Hopefully I will get to the point to give out tips and tricks like you.
I am going to try this and let you know how I do. Thank you so much for your help!
Stephanie
好的。我做的不对。我一直收到一条错误消息，说明变量未定义。
Ok. I''m not doing something right. I keep getting an error message saying the variable is not defined.
这篇关于请使用搜索表单帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
