Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help building a query/form

Status
Not open for further replies.

chipearly

Technical User
Joined
Jun 19, 2003
Messages
12
Location
US
I have learned quickly that I do not have the skills to build a query properly. I currently am building several tables that the records are entered through forms for several users. I would like to be able to search any of the tables that a user can pick from and search within it multiple fields. Am I missing some easy way to do this or would this require a lot of script writing? open for suggestions.
 
Chip,

Easiest way is to use the edit,find feature on the MS Access menu. The user can specify a find on the whole table so that the search will be kind of like what is done in Excel.

Coding something like this would take a fair amount of experience in VBA.



Mike Pastore

Hats off to (Roy) Harper
 
Chip,

You could also use the filter by form function in ACCESS that allows the user to filter on any of the fields that are on the forms.

D
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top