button code needed

[pharaon]

i'm new to access vb
what I want to do is make a button to search range of columns in data table with data type Yes/no and display the results if the value is yes

 

[boblarson]

Welcome to Access World Forums. Now, based on your question I have to state that your data structure sounds like it may not be properly normalized. So some questions are in order.

What do each of those columns you are wanting to search store? What is the purpose of finding the yes? What do you plan to do if you find a yes?

 

[pharaon]

Welcome to Access World Forums. Now, based on your question I have to state that your data structure sounds like it may not be properly normalized. So some questions are in order.

What do each of those columns you are wanting to search store? What is the purpose of finding the yes? What do you plan to do if you find a yes?

thanks for you reply
ok my database have only one table
each row will contain whole family data like husband name, wife, kids, address, etc... and Yes/no data type

so if there's so many rows and some rows of it have Yes value I need to return those rows in the search result

What do each of those columns you are wanting to search store?
I answered this one


What is the purpose of finding the yes?
to return the rows that contains the Yes value

What do you plan to do if you find a yes?
display those rows in new form

 

[missinglinq]

So each Record has one Yes/No Field, and you want to return a RecordSet consisting of all Records where this Field's value is Yes?

Your talk of a 'search range of columns' sounded as if you were speaking about searching multiple Fields, which is what lead to Bob's comments about normalization.

Linq ;0)>

 

[pharaon]

the records may have more than one field with yes/no
so it will loo a range of columns for each record to see if it have yes value and if so then it will return it in the search result

 

[spikepl]

In which case please answer Bob's question what the purpose of those multiple yes/no fields is. We do understand that you wish to have many yes/no fields. We want to know what for.

 

[pharaon]

well as I said before it's family data so beside each name on the family member there will be yes/no for sickness condition of the person so in the one family there could be more than one person sick or only one person and so on for the rest of the families

 

[jdraw]

You should review table design and normalization. It is rare to have a 1 table database.
Here is a link that deals with a process to take facts about your intended database; create tables and attributes; normalize the tables and create the appropriate relationships.
I hope it is helpful to you.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Good luck.

 

[pharaon]

this is my database in the attach
I know how to make a relation between tables but to have more than one table if I can simplify it to one table

 

[pharaon]

is there any way to achieve the search in one table