Search results

Each combo box record source is a table, Dept table, Div table, etc. The column count is two; DeptID, Deptname.

I have an Employee table and sometimes needs to be updated if an employee moves to another department. I wrote a query that will select all of the employee's data. I want to use a View/Update Form that will display the employee's data, Department, Division, Cost Center, etc. However, each of the...

RI Worked Great thanks RI Worked Great thanks

I have a Form that I use to view records from a Main Table. The records have an Autonumber. I also have a Remarks Table that contains remarks for each record in the Main Table. The records in the Remarks table records also have an Autonumber for each remark and save the Autonumber for the Main...

Worked Great Thanks Worked Great Thanks

I have a Form that I use to insert records to a table. The STATE field is not on the Form, but needs to be populated on the table based on the TOWNCODE field that is on the Form. If the TOWNCODE entered on the Form is > 20 then the STATE is 2, else the STATE is 1. How can I do this?

I problem is the table data. Not all the columns I am serching on have data(empty). This is Jon's last statement: "Unfortunately, the Like operator cannot return Null values. So when the text box or combo box is left blank, it fails to return all the records if the field happens to contain Null...

oooooooooooohhhhhhhhhh I now understand that I can not have empty columns in a table for a search. I have put a default of "Unknown" on all text fields and 0 for all numeric fields. Thanks

I have a Search Query based on a Form. It does not retrieve any columns from the table if any column is empty. Why? I thought the & "*" would find all records. SELECT DISTINCT LITE.OWNER, LITE.LAMP_SUFF, LITE.LAMP_NUMBER, LITE.TOWN_CODE, LITE.ACCT_NO, LITE.STR_NAME, LITE.STR_DESC...

I did have Page header footer, instead of Form Thanks

I have a Combo Box based on a table list on a Form. I want to choose several items from the list to feed a Lookup Query. Can this be done? :rolleyes:

I created a Form with a Header and Footer. When I see it in Form View, it only displays the Detail records. Why?

Thanks again

Nevermind, I missplelled Me.TxtEmpNum=Me.cboEmployee.Column(3), should have been Me.cboxEmployee. Thanks it works fine

I had forgotten that, it was Column(2) that I wanted. However, I still get the compile error. Is the Text Box bound?

I have a Combo Box driven by a query which has hidden columns in the combo. I have created text boxes that I want to populate with these hidden columns. In the AfterUpdate of the Combo, I have Me.TxtEmpNum=Me.cboEmployee.Column(3), but I get compile error: 'Method or member data not found'. Is...

Why are the text boxes bound to the fields in the Incident table? The insert of the Employee table data to the Incidents table is done with a Command button with a .AddNew on the Click Event. Can I just add a .Fields ("EmployeeNumber") = cboxEmployee.Column(3) to the event. (did not work) If I...

Still having problems The (1) combo based on the Employee table to select the relevant employee is already there. In the query used to drive the combo, I have included all the data I want to store, EmployeeNumber, Department, Cost Center, Location, etc. and made these as hidden columns in the...

I have this Access application. The Incidents table was created incorrectly. apparently the design was not thought over. The Incidents table was created to store employee accidents. However, since the employee data is based in nicely normalized data, all Incident reports will have the employee's...

Yes, that would be good