im using access 97 and am fairly new to this. I am currently wanting to do a search of a table where all the data items in it are checkboxes. eg. the table is of various different software stored on all different machines. each columns heading is a type of software and under it are checkboxes to show wether the coresponding computer has this software. I want to do a search so i can type in the software name and it will return me a list of all the computers with this software. Is this possible and what do i search for as im not searching for a name???
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search with checkboxes
- Thread starter mrobinson
- Start date
Hi!
With the way you have the data set up, there isn't a clean easily understood way to find the information you want. You can use VBA behind a form to get this info out the way you want to present it to the user. Alternatively, you can redesign your table structure like this:
tblSoftware
fldSoftwareID
fldSoftwareName
etc.
tblComputers
fldComputerID
fldComputerLocation
etc.
tblSoftwareOnComputers
fldSoftwareID
fldComputerID
With this structure you can easily write queries to determine what software a computer has and where certain software is located.
hth
Jeff Bridgham
bridgham@purdue.edu
With the way you have the data set up, there isn't a clean easily understood way to find the information you want. You can use VBA behind a form to get this info out the way you want to present it to the user. Alternatively, you can redesign your table structure like this:
tblSoftware
fldSoftwareID
fldSoftwareName
etc.
tblComputers
fldComputerID
fldComputerLocation
etc.
tblSoftwareOnComputers
fldSoftwareID
fldComputerID
With this structure you can easily write queries to determine what software a computer has and where certain software is located.
hth
Jeff Bridgham
bridgham@purdue.edu
Sure,
Assuming you're using the design grid to build your query, just do a search where the value is "Yes". Because check boxes are boolean, you can query for yes or no values.
Just build your query, selecting the fields that you want to see. For the criteria under one of your software fields, enter Yes. Your results will be your selected field that have the software you set the criteria for.
Hope this helps
Assuming you're using the design grid to build your query, just do a search where the value is "Yes". Because check boxes are boolean, you can query for yes or no values.
Just build your query, selecting the fields that you want to see. For the criteria under one of your software fields, enter Yes. Your results will be your selected field that have the software you set the criteria for.
Hope this helps
- Status
Similar threads
- Locked
- Question
