Search results

Yes, I want to be able to somehow tie together the information for the jobs and the status changes. As of right now when I run queries the information does not match up. I could not get that to work in my database. The pop up form does not show up at all. Am I doing something wrong?

This is an employee tracking database and it's main components are to track employee ratings (skills), OSHA certification, and eventually when I can get it to work correctly add in licensing (employees in certain states must hold the correct licenses in order to be on certain jobs) to track the...

Would it make a difference if the subform would have a new record each and every time? There would be no updating the subform as each time that status change occurs it would be a new record. So I believe I should get rid of the first part of the code, correct? Private Sub...

I currently have a VB statement written for a pop up form based on a main form. I would like to change it so it is based off of a subform and somehow tie those tables together. I'm not sure how that would work seeing as I'd have to go back and match up everything since July when I modified the...

I can post my zipped database if you would like.

If I'm understanding this correctly, I have to do the update query through a form?

UPDATE: I cannot do an update query because the foreign keys are primary keys that use an auto number. Suggestions??

I created a junction table in order to create a many-to-many relationship between two tables. My question is this: Do I run an update query in order to populate the information from the two primary keys (which are the foreign keys in the junction table) in the tables? Basically I took...

The 2 tables I'm looking to use in the junction table are: tblEmpInfo EmpInfoID <PK> EmpIDFK <FK> JobNumber tblEmpRating EmpRatingID <PK> EmpID2 <FK> EffectiveDate SuptID Status Craft The junction table would look like this: tblEmpRateInfo RateInfoID <PK> EmpInfoID <FK> EmpRateID <FK>...

I have a date field in another table that I would like to correspond to the most recent info posted. I think what I have to do is have a junction table for a many to many relationship. The job number refers to the job sites where the employees are working. Thank you!!

In my database, I have a table that is used as join table for a many to many relationship. I am having trouble using that table in queries in order to use the most recent information entered in there. For example, the table stores the emp ID and the Job Number where the employee is working...

I just updated a table in my database and now anytime I go to change the work status field Access says Microsoft Access has stopped working and then shuts down and restarts and wants to save a back up. I did the same exact process to update the table in a test environment, basically a backed up...

I am currently re-working my database and have updated a few tables, deleted a duplicate fields from tables. I currently have a pop up form that has some code behind it. I also changed a few things in the table (deleting the duplicate fields). So in tblEmpJobs there is no longer a field for...

I'm not sure what happened but it finally worked. There are no look ups at the table level. Based on the advice here I made sure to do those look ups at the form level. Thank you!!

I've tried the update query as well and it keeps telling me I need a destination field. I want to move EmpType from tblEmpInfo to tblEmp. UPDATE tblEmp INNER JOIN tblEmpInfo ON tblEmp.EmployeeID = tblEmpInfo.EmpIDFK SET tblEmp.EmpType = [tblEmpInfo].[EmpType]; Is this correct?

Am I using the wrong query to accomplish what I am trying to do?? I would like to take a field from one table and move it to another table and then delete it in the original table. No matter what I have done I CANNOT get the the field and the information into the new table. Should I being...

That did not work either. All I'm looking to do is append the one field "EmpType" from tblEmpInfo to tblEmp. Am I misunderstanding something? The tables are related by the employee ID. When I run it as a Select query everything is fine all the records match up correctly but as soon as I...

INSERT INTO tblEmp SELECT tblEmp.* FROM tblEmp INNER JOIN tblEmpInfo ON tblEmp.EmployeeID = tblEmpInfo.EmpIDFK; I switched it to this, because I thought maybe since there was an empty field it wasn't working. But the data still won't append and it is adding duplicate rows when I run it as a...

I am appending a field from one table to another and it will not work. It is telling me that it either has violations or duplicate output destination. When I run it through as a Select Query the information is correct, but as soon as I make it an Append Query it will not work. INSERT INTO...

Ok, after working on this all morning and most of the afternoon, I think I am missing a step. And I am going to have to delete some of the data I believe as well. At the moment I am currently trying to append the data from tblEmpInfo to tblEmpRating with the exception of one field. I want to...