Advanced reminder management

[albiagro03]

Hi,
I've been working for some weeks on a project which should allow me to manage scheduled reminders.
The reminders have been set up on a DB, with date, time, description, status and more.
My program's supposed to pull out reminders within 5 mins and still open reminders, as the user can close them as he completed the task.
I compiled the most of the code on VB and the data on the DB to be extracted, but I'm still missing how to change their status when a new day starts.
E.g: I set if the date.db <> date.now, a query will update the date with the current date and the status with "Open". But doing this I will lose automatically some reminders, if the user has left them open from the previuos day.

Any ideas?

Thanks in advance.

[ChrisE]

Hi

this query checks if a Bill has been paid within 10 Days, this will check the
yes/no field !!
if the Bill has not been marked paid(yes/no field) it will appear

SELECT Orders.OrderID, Orders.OrderDate, Orders.paid
FROM Orders
GROUP BY Orders.OrderID, Orders.OrderDate, Orders.paid
HAVING (((Orders.paid)=No) AND ((Now())>=([OrderDate]+(10))));

you will have to add a yes/no field named 'paid' to the Orders Table

open the Northwind database an enter the above as a new query, play around
with it until is meet's what you want.

regards
Chris