Search results

  1. K

    Re-Working Current Database

    I have a very stripped down version of the database that I am working with. My only concern with appending the data is making sure that it tblEmpInfo is appending the correct data to the tblEmpRating since there is no direct correlation between those 2 tables.
  2. K

    Re-Working Current Database

    THANK YOU SO MUCH!!!! The way you have it set up makes more sense. I will be adding more sections to the database. To answer your question regarding the skills, there are 72 skills the employee can be rated on depending on the work he did at the jobsite, also the employee rates himself on...
  3. K

    Re-Working Current Database

    Can someone help? I am at a loss as to how to proceed. The original way of thinking is flawed. And as soon as I go to change it, I find another problem logically with the way that will work. I know that databases are a work in progress but I cannot go forward with anymore additions to...
  4. K

    Re-Working Current Database

    I did not realize in the original post that the documents did not attach. My other thought was that I could link the EmpRating table and EmpInfo table and get rid of some of the fields. Would that be better since some fields will not be filled out if the employee is being laid off? Thanks...
  5. K

    Re-Working Current Database

    I have created an employee tracking database that tracks, skill inventories, licensing, certifications, and safety training. After adding tables and different reports and forms for tracking what management wanted, I realized that the database needs reworking. I have to tables that carry...
  6. K

    Database needs some reworking...

    I can do that...I have most of the original idea on paper. I will be posting there shortly. thank you so much!
  7. K

    Database needs some reworking...

    Hello All, I had created a database a number of months back and received wonderful advice and constructive criticism from you. After getting halfway through and seeing some requests come through from management on what they want to see or improvements, it looks as though there will have to be...
  8. K

    Pop Up Form

    Here is the code: Private Sub EmploymentStatus_AfterUpdate() If Me.EmploymentStatus = "Active" Then Me.tblEmpInfo.Visible = True Else Me.tblEmpInfo.Visible = False End If End Sub Private Sub Form_Current() If Me.NewRecord Then Me.tblEmpInfo.Visible = True Else If...
  9. K

    Pop Up Form

    It pops up based on if the employee status = "Active" or if I add a new record.
  10. K

    Pop Up Form

    I have a pop up form in my database that is used when it meets a certain criteria. The issue I am having with this form is I cannot go through the records. For example, if I want to see how many jobs a person has been on, the form will not allow me in the record navigation to go through the...
  11. K

    Duplicate info in tables Best Practice

    It wouldn't be duplicate records in the same table. It would be in two different tables. One table tracks the job the employee is on the other table tracks performance. It just so happens that the employee is evaluated each time he transfers, is rehired or laid off from a job. But if the...
  12. K

    Duplicate info in tables Best Practice

    I am debating on adding another field to a table in order to track dates. I have the information in another table but these 2 tables have no relationship to each other. Initially, I was thinking of creating a relationship between the two tables in order to pull the date from there. But this...
  13. K

    Starting over with raw data and random join question

    I think I made that even more ambiguous than the original question. I am looking to use the EvalDate in tblEmpRating for other reports that tie back to tblEmpInfo. I thought that I needed to join those tables in order to be able to pull information from them. For instance, I want a query to...
  14. K

    Starting over with raw data and random join question

    There is no confidential data in this file. I'm not sure if it is even possible the more I think about it. Instead of having the pop up table that is currently in the Employee Entry form, I want to just add it to frmRatedby Status and I wanted to try and match up the most current records...
  15. K

    Starting over with raw data and random join question

    I have a test database that I have been using to test the changes as well as a live database that I enter the data in. I have been using reports and queries from the live database as I test them out and add them there. There have been a few subtle changes over the past few months. Those...
  16. K

    Starting over with raw data and random join question

    I have almost all of my info with the exception of few hundred pieces of data entered into my database. After looking it over and looking for ways to improve it, would it be easier to import all the tables into a brand new database and starting fresh with everything? I have made a lot of...
  17. K

    Using DMax Function in a query

    There is no date field in the table. Although I am thinking of adding one to better be able to track when these employees came and went so I can see a history by date rather than the auto number. Although, that table should match up by Date to the tblEmpRating. Would it make sense to have...
  18. K

    Using DMax Function in a query

    I will be running 2 reports each week using the most recent information in the tblEmpInfo (OSHA by Job report and a Licensing Log). In the tblEmpInfo the JobNumFK and CraftCode may change. For example, EmpIDFK 4978 was at C43205 but then transferred to C43185. Currently that information is...
  19. K

    Using DMax Function in a query

    Pbaldy, I tried to do what you had suggested and it the query will not run. I'm assuming I'm not using the correct syntax? SELECT Max(tblEmpInfo.EmpInfoID) AS MaxDateEmpInfoID, tblEmpInfo.EmpInfoID FROM tblEmpInfo GROUP BY tblEmpInfoID.EmpIDFK Please help!! Thank you!!
  20. K

    Using DMax Function in a query

    The query I am working on is qryOSHAJob. Can someone please look at it and tell me what is wrong. In that field, the DMax expression comes back with a number of 330. I don't know how or why it comes back that way. But what I am looking for it to do, is for each EmpIDFK I want it to pull...
Back
Top Bottom