Filtering The Search quiery with Checkboxes

[dbmanalser84]

I'm building card database, and the next step in my work is to build a form where i could search from particular card in database but besides searching where you would enter the card name only I wan't to add a couple of checkboxes that would act as filters. I have the following tables in my database:
tblCards
tblColor
tblCondition
tblEdition
tblCards is the main table and other tables are lookup tables for this table. Besides of entering the card name in search box I wan't to be able to filter the cards also by Color, Condition and Edition. Each of the lookup tables has data that also needs to be checked on the search form, for example: tblColors has five colors, red, green, blue, black, white. I wan't to have checkbox for each color in this particular example, and then I wan't to reapeat this for each possible data that could be stored in these lookup tables, so basically I wan't to have a checkbox for each record in lookup tables that I would be able to check and uncheck and thus add them in the search criteria.
I never build a search form and I would need info how to create a simple search string and how to create these checkbox filters. Any help would be appreciated. Thnx.

 

[dbmanalser84]

Image of what I want to do

To cut the long story short, and to help you better helping me here's what I wan't to recreate. How do I do it?

 

[DCrake]

Simple Software Solutions

The layout of your screen is very user friendly and I am sure alot of members would be very interested in how you got the check boxes in your lists? This question has come up many times. I would be grateful if you could pass this on to the rest of the forum.

 

[dbmanalser84]

If I....

The layout of your screen is very user friendly and I am sure alot of members would be very interested in how you got the check boxes in your lists? This question has come up many times. I would be grateful if you could pass this on to the rest of the forum.

If I understood you right you think that I created this on the picture. I'm sorry to dissapiont you but this is the screenshot from the functionig program I posted is just as a refference for everybody to see what I wan't to create.

 

[DCrake]

Simple Software Solutions

I think you misunderstood me... Alot of people on this forum have asked if it possible to have working checkboxes in listboxes (as you have displayed in you screenshot, or so it seams.)

My request was for you to enlighten members on how you achieved this. My self I use custom OCX controls to achieve this, but members who do not have access to them would appreciate your content.

CodeMaster:

 

[dbmanalser84]

Well.

I think you misunderstood me... Alot of people on this forum have asked if it possible to have working checkboxes in listboxes (as you have displayed in you screenshot, or so it seams.)

My request was for you to enlighten members on how you achieved this. My self I use custom OCX controls to achieve this, but members who do not have access to them would appreciate your content.

CodeMaster:

I didn't missunderstood you, I think you misunderstood me. As I said I haven't created this, I "Print Screen" it from an existing program Magic Workstation (sorry if mentionnig this program is illegal, it's free tought). So, I cannot help you, maybe the creators of the program can, sorry.

I also, as other members, wanted to know how can I create this myself and implement it in my database? My form should look exactly and have the exact same data because I'm build card Collection Database.

 

[DCrake]

Simple Software Solutions

I stand corrected.

However, if Access is an important part of your job or you want to create the real thing there is a web site that has over 40 ocx's that do all sorts of things. The screenshot is a simple spash of one activeX that uses tick boxes on listboxes that can be manipulated to give you what you want. I have also posted the link to their web site.

Bare in mind you have to pay for the ocx's but in the long run I have found that they have repaid themselves over and over as they make life a lot simpler. They work for both Access and VB you can also get .net versions.

David
http://www.dbi-tech.com/product_page_Studio_Controls.asp