-
Jul 26th, 2017, 08:08 PM
#1
Thread Starter
New Member
Advanced reminder management
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.
-
Jul 29th, 2017, 03:06 AM
#2
Re: Advanced reminder management
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
Code:
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|