如何为数据库创建搜索表单。 [英] How to create Search form for database.

问题描述

您好我想为我的数据库创建一个搜索表单，搜索方式为：


首页

最后

联系方式号码

街道

城市

州

邮编


什么是最容易实现这一目标的方法吗？我想我应该提一下我有一张名为tblcustomerinformation的表。我希望搜索列出可能的匹配项，我希望能够点击并打开记录。


谢谢

解决方案

您好我想为我的数据库创建一个搜索表单，搜索方式为：


First

最后

联系电话

街道

城市

州

Zip


实现这一目标的最简单方法是什么？我想我应该提一下我有一张名为tblcustomerinformation的表。搜索完成后，我希望它能打开匹配的记录。

有几种不同的方法可以做到这一点...


1.你可以在哪里有文本框用户输入搜索条件，然后按搜索键。按钮

2.您可以使用组合框预先形成搜索。用户可以键入他们想要搜索的内容，也可以从列表中选择


我个人喜欢搜索按钮。方法。我相信TSDN的其他成员会有其他想法，但如果你想这样做，请告诉我，我可以帮助你。



有一个好的！

有几种不同的方法可以做到这一点......


1。您可以在文本框中输入用户输入搜索条件，然后按搜索按钮。按钮

2.您可以使用组合框预先形成搜索。用户可以键入他们想要搜索的内容，也可以从列表中选择


我个人喜欢搜索按钮。方法。我相信TSDN的其他成员会有其他想法，但如果你想这样做，请告诉我，我可以帮助你。



有一个好的！

搜索按钮正是我正在寻找的。

搜索按钮正是我正在寻找的。

好​​的，这就是你需要做的事情


一旦你创建了所有的表格您想要显示的字段，您将创建 BOUND 文本框。 （绑定意味着它与表中的feild连接）在本例中我将使用LastName。


1.一旦你创建了绑定的文本框（如果你不知道，我可以告诉你如何做到这一点）。您将在它旁边创建一个空白按钮。

2.创建按钮后，将此代码放在OnClick中。按钮的事件。您将不得不将相应的名称放在相应的位置

展开 | 选择 | Wrap | 行号

Hello I would like to create a search form for my database that searches by:

First
Last
Contact Number
Street
City
State
Zip

What is the easiest way possible to accomplish this? I guess I should mention I have a table called tblcustomerinformation. I would like the search to list possible matches and from that list I would like to be able to click and open the record.

Thank you

解决方案

Hello I would like to create a search form for my database that searches by:

First
Last
Contact Number
Street
City
State
Zip

What is the easiest way possible to accomplish this? I guess I should mention I have a table called tblcustomerinformation. Once the search is completed I will like it to open the matching record.

There are a couple different ways you can do this...

1.You can have text boxes where the users enter search criteria and then press a "search" button
2.You can have a combo box preform your search. The user can either type in what they want to search for or select from a list

I personally like the "search button" method. I am sure others memebers of TSDN will have other ideas but if you would like to do this let me know and I can help you out.


Have a good one!

There are a couple different ways you can do this...

1.You can have text boxes where the users enter search criteria and then press a "search" button
2.You can have a combo box preform your search. The user can either type in what they want to search for or select from a list

I personally like the "search button" method. I am sure others memebers of TSDN will have other ideas but if you would like to do this let me know and I can help you out.


Have a good one!

Search Button is exactly what im looking for.

Search Button is exactly what im looking for.

Ok well here is what you are going to need to do

Once you are have your form created with all the feilds you would like displayed, you are going to create a BOUND text box. (Bound means that it is connected with a feild in a table) in this example i will use LastName.

1.Once you have created your bound text box ( i can tell you how to do this if you don''t know). You will wnat to create a blank button next to it.
2. Once you have created the button place this code in the "OnClick" event of the button. You are going to have to put the appropreate names in the corrisponding places

Expand|Select|Wrap|Line Numbers

这篇关于如何为数据库创建搜索表单。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！