Reminder alerts

Hi Adam,
I use a much simpler version of what you have built but instead of using a toggle to 'stay on top', mine always 'stays on top' but I then hide it off to the side of the screen when it's not in use.
In the attached example, click on the date to hide Form1 and to bring it back, move the mouse to the left of the screen to where it's been docked.
Maybe it's something you might find useful.
Regards,
Derek.

  Rec_Id := SQLExecute('SELECT id FROM reminder WHERE (PlaySound = 1 or MsgPopup = 1) and '
         + '((duedate Is Not Null and Date(duedate) < strftime(''%Y-%m-%d'', ''now'',''localtime'')) or '
         + '(Date(duedate) = strftime(''%Y-%m-%d'', ''now'',''localtime'')))' );

I removed the check for the "datetime" column from the request

You should decide what criteria to use to check records in the OnTimer procedure.
You have the following fields StartDate, StartTime, DueDate, DueTime, PlaySound, MsgPopup, taskCompleted. Which fields should be included in the verification and under what conditions. Moreover, checking for messages and sound should be separated separately.

Hi Adam

I don't understand what algorithm you are trying to achieve.
Why then StartDate, StartTime? Why are the signs of message or sound output automatically removed immediately after one trigger? No more reminders needed? Maybe I haven't studied the project well enough?

I'll shorten my question.
You have StartDate, StartTime, DueDate, DueTime. For which Start or Due event should the reminder be triggered?
Right now you are checking (DueDate <= current date) and (message OR sound are 1).
The second part of the test (message OR sound equals 1) is already incorrect. It causes both message output and audio output to be executed even if only one of them is enabled.
Find answers to the questions for yourself and adjust the condition check.