Recent content by yrstrulysa

  1. Y

    Linking Table

    Yes, it is linked to an Auto number. I did not know that this limits the visual in the Form.
  2. Y

    Linking Table

    Would you please look at the images I attached? In the combo box, users will select a range of permits.ID's. Please note, that it work well in the Export Form linking to the Export table, but because I am using the PermitInformation table as my Import table also, I'm getting this issue. Code...
  3. Y

    Linking Table

    Please look at my DATA Model attached. I can not select Permit ID, which is set as an Auto Number in a table using a form. I want the user to be able to select from a drop-down list, it appears PermitID 1 is fixed and does not allow editing. Do I create a linking table, or do I bring in a full...
  4. Y

    Positive Test Flagging & Reminders

    Your demeanour comes across as rather off-putting. I never requested your assistance, yet you responded to my post. Kindly keep your negative mood to yourself in future interactions.
  5. Y

    Import-export permit tracking system

    Like I said I already have an upload form. It's available in the files I made available via the link. My question was more would the tables and forms differ? I guess to an extent, I was not sure about how much.
  6. Y

    Positive Test Flagging & Reminders

    - Understood, my intentions were good. I did not know you cross-check platforms or that it is not allowed.
  7. Y

    Positive Test Flagging & Reminders

    Thank you, I'm glad you asked. See the link to my files in a text file(size too big to attach). 1. I would like a VBA/Macro that will take the last test date and count 5 years from that date to remind the users when a re-test is due if a test for a plant virus has come out positive. 2. The user...
  8. Y

    Import-export permit tracking system

    I agree. I intend to store files on Sharepoint, just the file details like @tvanstiphout demonstrated below. I have a Form that holds this data.
  9. Y

    Import-export permit tracking system

    Please find the link to my DB attached. The DB contains scrambled/censored data. The import form for Plant Permits already exists. It just lacks a few columns, which I brought in: Add a checkbox/drop-down field to track fumigation upon arrival. Include fields for: Permit Authorization...
  10. Y

    Positive Test Flagging & Reminders

    I am developing a Microsoft Access-based system to manage virus and bacterial retesting for plant blocks. The system tracks testing schedules, flags positive tests, and automates retest reminders using VBA and a subform to display test records. Files (Upload function does not work): [Follow the...
  11. Y

    Import-export permit tracking system

    Hi everyone, I'm working on optimizing an import-export permit tracking system and need some suggestions on improving document storage, data linking, and retrieval. Files is too big to upload, find link to it in txt file attached. Current Setup: tblPermitInformation – Stores both import &...
  12. Y

    Positive Test Flagging & Reminders

    Please see:
  13. Y

    Positive Test Flagging & Reminders

    I am developing a Microsoft Access-based system to manage virus/bacterial retesting for plant blocks. The system tracks testing schedules, flags positive tests, and automates retest reminders using VBA and a subform to display test records.
See more
Back
Top Bottom