ms访问创建搜索表单的最佳方式 [英] ms access best way to create a search form

问题描述

嗨我很新访问，我现在处于创建数据库表和各种表单以输入数据的阶段，但我需要一种基于某些搜索条件显示数据的方式


为此我已经创建了一个包含各种未绑定字段的表单，但我现在知道如何继续。


i也根据我要显示的表创建报表结果就是现在只显示所有记录


我该怎么办？

搜索可以找到类似的数据，除了字段中的相同数据

解决方案

嗨Madsma，欢迎来到BYTES论坛，这个论坛面向开发者和普通用户，可以自由地详细询问，专门讲究你想做什么。您可能无法获得足够简单的响应，因为您的问题不明确。我想你再次提出你的问题，这次包括表格，搜索条件以及你认为必须解决问题的所有提示。对于这个问题类型，我可以告诉你去下面的网页，这可能会对你有帮助。

如果你提供进一步的细节，我可以向你保证，你会得到你甚至没想过的惊人答案。 br /> （69.0 KB， 923观看次数）

hi iam quite new to access and i am now at a stage where i have created my database tables and various forms to input data on them but i need a way of displaying data based on some search criteria

for this i have created a form with various unbound fields but i do now how to proceed.

i also have create a report based on the table i want to display results from that is now just displaying all records

how should i proceed?
can the search find similar data except for identical data in the fields

解决方案

Hi Madsma, Welcome to the BYTES Forum, this forum is for developers and ordinary users, Be free to ask in details, Speak exclusively what exactly you want to do. You may not receive enough response simple because your question is not clear. I suppose you ask your question again, this time include tables, search criteria, and all hints that should you think mandatory to solve your problem. For this question type I can tell you go to the web pages below that may help you.
If you give further details, I can assure you will receive amazing answers that you might not even thinking of.
http://bytes.com/topic/access/answer...-form-database

hi Mr Key thank you for replying and sorry for that post i wasnt sure i could asked using so many details.
ok here i go again

i have a table containing my data called dataSource
it contains the field ID(primary key),name,age,date,team
i also have a form called dataEntry using the form wizard that enable me to enter data into my table(datasource)

i also created a report called report1 using the report wizard that displays all fields of each record line by line

What i want to do is to create some sort of search form that when the users enters some values of his choosing the report report1 will open containing only the hits.
About the Hits: I need to be able to enter data in any or all the fields in the search form and get matching results in the report but i need to search for similar matches beside exact matches. So if i only enter Andrew in the name field and hit the search button the report1 should open displaying all the records that contain in the name the text Andrew
like: Andrew Johnson
Andrew.O.Grimes
or even Sir Andrew Loyd

For the search form i have created a form with unbounded fields called searchForm that contains the fields:name,age,date and team(all of which are data existing in my table)
and a button called search but i do not know how to proceed

ps:I need for some more functionality but I want to deal with each task at a time

Well Madsma, Try to use this findrecord form, import it to your database, you will be able to search from all queries and Tables in your database and create a new query from which you may create a report.
To search for the records that you are not sure, you may write in the criteria as follows
1. *xxx*? if you meant for the records that might contain ...xxx...
2. *xxx if it contain ...xxx
3. xxx* if it contains xxx...
4. xxx if you mean the whole word
5. *? for all records in that particular table/query
Open the Attached Search form to see if it can help you.
For further information about this form, open the link below!
(69.0 KB, 923 views)

这篇关于ms访问创建搜索表单的最佳方式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！