Search results

On my form I have a combo box where the user can select the sex of a person. I had set the row source of the combo to a table, tblSex and this works fine. Now I want to programatically add the table entries ( simply male or female) to the row source, having set the combobox to value list. I...

Is there any way to do this ?

Hi all I'm redesigning my db and using 2007. I have a main form frmHousehold which has a subform frmPeople ( all the people in that household) and the subform frmPeople has a tab control in it with 7 tabs. One of the tabs has another subform on it showing e.g what type of cakes this person...

I have a table including a personkey, emailaddress1 and emailaddress2. On my form I wish to have a combo box where I can select which email address to use. I would like to build a union query as the row source for the combo box. So far I have SELECT tblPeople.PersonalEmail1 FROM tblPeople...

I have two tables, people and households. One household can have several people living there. We cant have any person who does not have a household to belong to , i.e he or she has to have an address. My people table has four fields FirstName, LastName, personkey (autonumber unique key)...

I have a database of 7000 records. It is split into front and back end. There are 3 users. Today a table vanished completely. The filesize in Windows explorer is 1mb though a backup from a few days ago was 3mb. Has anyone had this experience before and is there anything I can do to get the table...