Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jeannier1975

  1. jeannier1975

    Calendar to track lab test results

    Sorry i had to be out for awhile due to surgery now im back at my project looking for help again.
  2. jeannier1975

    Calendar to track lab test results

    i created the tables like you instructed but now how do i create a relationship between them how do i get the tables to be normalized. https://files.engineering.com/getfile.aspx?folder=018d1d39-7034-4888-b449-c4ae8e248253&file=14DAYFALLOFFREPORT.accdb
  3. jeannier1975

    Calendar to track lab test results

    can you show me please i have been racking my head for weeks for a solution.
  4. jeannier1975

    Calendar to track lab test results

    im still trying to work that out this is not mine it was just handed to me from the department manager
  5. jeannier1975

    Calendar to track lab test results

    i was going to put that in in a bit it just long process of me putting all the data in i have the data in an excel sheet . https://files.engineering.com/getfile.aspx?folder=9f2bef29-8441-4bfd-be74-371ddd81776e&file=Copy_of_14_Day_Follow_Up_Fall_Off_Log_MASTER2.xlsm
  6. jeannier1975

    Calendar to track lab test results

    ok i got it to work but i need to add some conditional formating based on labtest result I need to put this on the text boxes on the calendar for the test done for listeria in a given location. i have created a query for the test restults which is. SELECT [14DayFollow-upFallOffT].Location...
  7. jeannier1975

    Calendar to track lab test results

    I would like to thank everyone for their help and assistance [gorgeous]
  8. jeannier1975

    Calendar to track lab test results

    i keep getting an error i have been going through the code i am stumped
  9. jeannier1975

    Calendar to track lab test results

    im trying to download the file here but keep getting a error.
  10. jeannier1975

    Calendar to track lab test results

    dtpYear is a list box that list the years the user select the year yes i stepped into the code and it steal doesnot add the labels for the name i can send you my database if you like.https://files.engineering.com/getfile.aspx?folder=f12f5480-ffeb-4d30-8e06-3a1c425814c5&file=calendar_example.accdb
  11. jeannier1975

    Calendar to track lab test results

    This what i get still not sure what the issue is
  12. jeannier1975

    Calendar to track lab test results

    i think it has an issue with FillMonthLabels sub routine because it wont add the labels to the form
  13. jeannier1975

    thread702-1705763 i need to put te

    thread702-1705763 i need to put test result in a database but have no idea where to start. I though t of using this as a example but i get stuck. https://files.engineering.com/getfile.aspx?folder=b6c43650-27fa-48c7-a771-8db7ad7e8144&file=14_Day_Follow_Up_Fall_Off_Log_MASTER2.xlsm
  14. jeannier1975

    Calendar to track lab test results

    I have a form that i for from old post that MapJ wrote but having a hard time getting the code to work. my form looks like the attachment . i have the following code that i am trying to input the dates depending on a year that is selected but i get an error. Run time error 424 Object required. I...

Part and Inventory Search

Back
Top