AccessDiscussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Hi, I like to create a form where user can use to seek records from a table by specifying 1 or more search criteria. Based on the criteria specified, I'll like to display the results in a datasheet format. Anyone can advise?
This depends on what the criteria are, and how they are entered. Do you have more details? Are you looking up a PK, or parts of text, more than one field at a time, etc.?
The data are imported into Access from a .csv file. I would like to search data based on the fields. If possible, to enable search based on more than 1 field.
Once you have the data in Access in a table or query, you can use all sorts of search parameters very easily.
Can you give me an idea of the field types and what sort of data you are looking for?
Generally you can create a form that looks up columns in the table or query with a combo box. If the field contains a lot of text, you can do a string search as well. It depends on your design needs.
Seek record in Access
