Search results

Believe me I've tried everything, but having the two tables is the only way I have gotten the results I need. I am using combo boxes in the form for both the Primary and Secondary fields. When entered the data into the primary field it would change the Secondary field as well. Not what I...

I have a table called Primary Employees and another table called Secondary Employees. I also have a form where you can add new employees, which updates the Primary Employees table. What I would like to do is, after I add a new employee have the new data update both the Primary and Secondary...

Thanks Pat for your input. It's good to know the code is right. LOL. Is there a way that I can take all the data on the form and perhaps send it to a new or existing Table so that I can query on on table as opposed to querying multiply tables in one query. Hope I'm making sense. See, what...

How would I go about updating a table from a form? My table consists of employee contact information, ie.. Cell phone, pager number, home phone. I have created a forum with unbound combo box called employee. As I choose the employee name all other fields are populating just as i want. After I...

How would I go about "Faking" the look up? I cannot code VB and I'm a very basic Access user to this point.

Ok, sorry about that. Let me see if I can be a little more clearer. I have a Form based on a query. This query prompts me for three different responses. 1) System Name... 2) Primary Oncall Person Name..... and 3) Secondary Oncall Person Name. Now, the "System Name" comes from a table called...

I have criteria asking for the SYSTEM I want to look up. I have the criteria defined as ["Enter System Name:"]

because the form is based on a Query it will not allow me to change any fields. I want to take the data that I enter and save it to a database

If I have a form which is based on a Query and is using 3 different tables, how would I go about updating specific records from the form into a specific table?

If I have a form which is based on a Query and is using 3 different tables, how would I go about updating specific records from the form into a specific table?

If I have a form which is based on a Query and is using 3 different tables, how would I go about updating specific records from the form into a specific table?

How can I update a database when the forms record source is a query? the form works great but it won't let me change any of the fields or save it to a database. I have to form based on three different tables. When I define a SAVE Button, it will not save it to the database

Is the RecordSource the same as the Control Source for the field?

:confused: Does anyone know how I would go about inputting data in a field (employee name) and get other information from another database? Example: If I type in the employees name, I would want all the other fields associated with that employee record to be automatically enter in the other...

How would that be coded if I wanted to have a total of all the maintenance cost at the end of the report?

How would I change a field that has not data and insert data throughout the database? For example... If I have a field call Maint cost and some of the fields have data (currency) in them, and some of them are blank. How would I change the blank fields into $0?

If I have a field called Maintenance Cost and I wanted to calculate what I'm spending monthly and add it to an existing report, how would I go about doing that. I have looked at the =Sum([maint]) but all it does is puts the total of the last record on the page, it does not calculate all the...

Is there a way I can assign a command button to edit the form?

How would I be able to lock down anyone from editing a form or report but allowing them to run/update the form (new records) and report.

Thanks!!!! That worked GREAT!!!!