Search results

how to hide all form controls at once like if i have many text box and labels how to make a loop to hide it all at once

I need help in the structure of each table for example one table will be for husband, wife, kids, address, phone another table to indicate who's of them need medication how to Structured that table and how to relate it with the first table what field need to be the key

well I want to make a data base for community service it will contain families data like 1- husband, wife, kids, address, phone 2- who might need a medication from any families members 3- who might need a shelter from any families members. 4- who is working from any families members I read the...

is there any way to achieve the search in one table

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

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

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

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...

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