Recent content by hjgwright

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

great... is there a way to remove the filter and stay on same record? Hi.. That's exactly what I need to do. Is there a way for me to say press the navigation button to go to the next record, which would remove the filter, but stay in the same place (i.e. not go back to the first record?)...

access 97.... Hi.. thanks for your reply. I don't have a copy of Access 2000, though. Would you be able to send it in 97 format? I have sorted out the form so that it is filtered, but I need to be able to navigate through the other people's details too, not just the filtered person. Cheers. HW

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

The users of the database complained that this is happening. I have sorted out the 'NotinList' part of it, so it opens up the Company form. I don't know why they would keep on deleting a name, perhaps they won't now this is sorted. I thought there might be an If combo is null bit of code I could...

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 working on a database that's been in use for a couple of years. There is already the structure config. with Employee tables etc. The tables I added were: Home Address People/Home I'm going to try what you've said. Thanks.. HW.

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

i'm having the same problem Hi. Please let me know if you find a way to solve this one. The same thing is happening with me. I am new to Access and am working on a very complex db. Maybe it has something to do with it not querying the data for the subform? A requery or something? Thanks, HW

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