Recent content by AGNewton5

  1. A

    Employee Schedule Database

    I am trying to create an Employee Schedule database that will use Employee data from a training database (also MS Access). I am basically wanting to have 2 options for each Employee when it comes to their schedule. The Employee will either be assigned to a team (5 teams- they will have the...
  2. A

    Solved Autocheck a check box in a form

    It was a typo. I meant to type DateOfCourse. Thank you for your help!
  3. A

    Solved Autocheck a check box in a form

    Thank you! That worked great
  4. A

    Solved Autocheck a check box in a form

    I am wanting to auto populate a checkbox when a specific textbox has a date in it. The textbox is named DateOf Course The checkbox is named PassFail The date doesn't need to be a specific date, I have a separate validation point for doing that, I just want to make sure that a valid date is...
  5. A

    Solved Need help with form reference/ conditional formatting

    Will do. Thank you for your help!
  6. A

    Solved Need help with form reference/ conditional formatting

    Thank you arnelgp! You are a lifesaver. I have been fighting that for too long.
  7. A

    Solved Need help with form reference/ conditional formatting

    Is there a way that I can do this and reference a specific RevDate on tblTraining based on the record that is being added on the form? This is almost doing what I am wanting to do.
  8. A

    Solved Need help with form reference/ conditional formatting

    I have added the DB, Thank you!
  9. A

    Solved Need help with form reference/ conditional formatting

    I have a Form that I am wanting to reference the entered date in a texbox [jtblPositionTraining]![DateOfCourse] to the date that the course was last updated, which is in a different table [tblTraining]![RevDate]. I am wanting to use conditional formatting to show when...
  10. A

    Question Training Database

    I inherited a pretty archaic system of paperwork. The business has several positions (8), and about 140 different training courses. Each position can share several of the same training courses, but each position MUST complete the required courses before they are qualified to do the task. The...
  11. A

    Question Training Database

    Would this work better. I am really lost here and just want to make sure that I'm not wasting my time. I have the TrainingRevisionData table to allow me to update the TrainingData when necessary adjustments are made to our ever changing manufacturing environment. I am very new to this, but...
  12. A

    Question Training Database

    Employees can be qualified in more than one position and to be qualified they must complete between 20-45 different trainings. I want to document when the training is completed. I would also need each employee to be requalified after 5 years, or if the training is revised before the 5 year period.
  13. A

    Question Training Database

    Any suggestions on this idea? I have about 150+ different training classes and 30-40 are shared between several positions, so any thoughts would be appreciated. Thanks again
  14. A

    Question Training Database

    I am very new at this. If I were to have a Positions table that had all the various positions that I employ, how would I link the individual training classes to each specific position? Thanks again
  15. A

    Question Training Database

    I am very new to Access and am in the middle of trying to build a database to make my job a little easier. I have built the tables that I believe I need, but am having some logic issues in building the needed relationships to connect everything together. I need this database to have a few basic...
Top Bottom