Positive Test Flagging & Reminders

[yrstrulysa]

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.

​

 

[yrstrulysa]

Please see:

 

[plog]

Ok? How can we help you?

 

[yrstrulysa]

I can't post my requirements, or a URL link. How come? What am I doing wrong?

 

[yrstrulysa]

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): [Insert Google Drive link here]

What I Have Done So Far

1. Created a Table for Retesting (TblBlockRetesting).
2. Subform: QfrmBlockPath_subform - Link & Functionality
   
   • This subform is embedded in the Blocks Administration Form (frmBlocks Admin).
   • It is linked to the main form using:
     • Master Field: Nr
     • Child Field: Nr, Block

Testing Reminder - How It Works

• Checks if a block has tested positive (TestResult = "A/EC").
• Looks at the TestDate column to determine if the test was conducted 5+ years ago.
• Inserts overdue tests into TblBlockRetesting if they are not already recorded.
• Triggers a pop-up reminder listing overdue blocks.

I tried using a VBA script, but it is currently calling a previous macro, and I do not know how to remove it.

Please provide the VBA code you are using so I can help you fix the issue with the macro call.

 

[plog]

We are now up to 3 posts where you give us a synopsis of your project and I think I finally see a sentence hidden in there that has to do with an issue (but no specific question though):

I tried using a VBA script, but it is currently calling a previous macro, and I do not know how to remove it.

The most common way to call a macro from VBA is via the DoCmd.RunMacro method:

DoCmd.RunMacro method (Access)

Office VBA reference topic

learn.microsoft.com

So, my suggestion is to search (Ctrl + f) your VBA for either the name of the macro that is no longer in use or 'DoCmd.RunMacro'.

 

[arnelgp]

cross posted here:

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. Files(upload function dont...

www.accessforums.net