Search results

Hi. I have a form with Address details. There is a choice of Home Address and Work Address (from Address Type table). When I select Work Address in my combo, it filters the form so that only Work Addresses appear. When I select Home Address, only Home Addresses appear. Problem: If I have a...

Hi. I have a form with personal details, and a combo - combo21. This has Home Address and Work Address as its data (from Address Type table). However, when you click on either Home Address or Work Address it just stays at the same field. You can move to the next record to see a Home Address...

Hi. I want to set up a Find form for my db. The Find form should contain an Option group with 'By First Name' and 'By Surname' as the options, and a Combo box which lists the names, by First Name or Surname depending on the selection in the Option group. When I've chosen the person, I want to...

Hi. I've got a form with Job details. This form has two subforms - Companies related to Job, and Record of Conversations with Employees. I've just updated the Record of Conversations with Employees form to include the Job relevant to the employee, but it keeps asking me to fill in the Role_ID...

hi. I've got a form with a subform. The subform contains company information. The NotInList event is set to open up the Company form in order for you input the company details. It then requeries the combo and finds the information you just entered, and applies it to the fields. However, when I...

Hi. I'm quite new to Access (97) and have a problem. I have the following tables: 1. Company (with CompanyID, Company, Addrs_ID, HomeAdd_ID, Notes) 2. Address (Addrs_ID, Address1-5 etc) 3. Home Address (HomeAdd_ID, Address 1-5 etc) 4. People (PeopleID, Name, Surname, Addrs_ID - lookup to...

Hi. I get the 'Cannot assign a null value to a variable' error when I enter a new name in my 'company' (company name) combo. I have some info on creating a null value in a combo, but I don't think it worked for me. What I need to do is allow users to enter an unknown company in the combo, which...

Hi. I get the 'Cannot assign a null value to a variable' error when I enter a new name in my 'company' (company name) combo. I have some info on creating a null value in a combo, but I don't think it worked for me. What I need to do is allow users to enter an unknown company in the combo, which...

Hi. I have an Address table with Addrs_ID as the primary key, and an Address Type table which contains two records: Home Address and Work Address. There is a Personnel contact form which has a subform for the address. The Address table has a field called 'Type' and uses the lookup to find the...