Search results

  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...
  16. A

    Question Access Training Database

    I wasn't sure what I would do in order to trigger when retraining was needed. We currently retrain all employees after 5 years. Often times one of the many training classes that are required for a specific job is revised. When that happens, all Employees need to retake that specific class...
  17. A

    Question Access Training Database

    I think that I may have all the tables that I need to begin this process. I am very new at this and was hoping to get some pointers as to what I need to do next. Any help would be greatly appreciated.
  18. A

    Hi

    I am new here and have been recently introduced to Access. I have used Excel a good amount and would love some advice/ knowledge on how access works. I am reading the Access 2016 Bible now and am in the middle of a large project to help me organize a pretty disastrous training program that I...
  19. A

    Question Access Training Database

    If I were to not worry about the revision on the actual training document and just modify the date when a revision occurs, could I then create a conditional format (like in excel) that would highlight/ red flag any employee that needs retraining? Thanks in advance!
  20. A

    Question Access Training Database

    I think that using the date for the revision would work. It would make distinguishing whether the employee is needing retraining easier. I am very new at Access and have a lot to learn to make these things come together. I have been reading a couple of books, but the newness is still very real.
Top Bottom