Reminder for Action Closure Date Overdue (5 Days)

Question

0.00/5 (No votes)

See more:

Hi guys,
I have 3 columns:
Action Start Date, Planned Closure Date & Real Closure Date in my application called Employee Actions Manager developed by using VB.Net2010 & MS Access 2010.
I want to set a reminder that can remind me on 5th day after the Planned Closure Date for each action.
I want a reminder when I open my Application, I have all the records in data grid...can I highlight the record as a reminder???

What I already did added a query in the Action Log Table Adaptor under name (FillByPositive5DaysDelay) which is as follows:

SQL

SELECT        ID, ActionReferance, ActionDescription, ActionSite, ActionCategory, ActionImportance, ActionAccountability, ActionProgressStatus, ActionClosurestatus, ActionDoneBy, 
                         ActionComment, ActionYear, ActionStartDate, PlannedClosureDate, RealClosureDate
FROM            ActionsLog
WHERE        (PlannedClosureDate >= DATEADD(DD, + 5, GETDATE()))

But there is a SQL execution error (undefined function GETDATE in expression).So can you help me to avoid this error?

Please kindly note that I have added the following function in the Actions Log form but the same problem still persists.

VB

Private Sub GETDATE()
        System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")
End Sub

Thanks in advance!!

Posted 13-Apr-15 2:16am

Sherif Adely

Updated 13-Apr-15 9:36am

Maciej Los

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2015-04-13T02:34:00

Solution 1

Microsoft Access does not know what GETDATE() is. You can use NOW() in Access.

Posted 13-Apr-15 2:34am

ZurdoDev

Comments

Sherif Adely 13-Apr-15 10:12am

Thank you RyanDev for your prompt reply

Sorry I’m a beginner in VB and I have revised my code to

WHERE (PlannedClosureDate >= DATEADD(DD, + 5, NOW()))

But I have new error message (No value given for one or more required parameters) when I execute the query.

ZurdoDev 13-Apr-15 10:18am

The plus is weird, but I don't know if that is it.

Sherif Adely 13-Apr-15 11:29am

I removed the plus but I have the same error.

ZurdoDev 13-Apr-15 11:34am

Just a suggestion, but it would probably be faster for you to google this.

See http://www.techonthenet.com/access/functions/date/dateadd.php

First parameter needs to be in quotes. And d is day, not DD in Access.

Sherif Adely 17-Apr-15 10:50am

Thanks alot :)

Maciej Los · Accepted Answer · 2015-04-13T09:41:00

Solution 3

A proper WHERE clause should look like:

SQL

WHERE (PlannedClosureDate >= DATEADD("d", 5, DATE()))

For further information, please see:
DATE function (MS Access)[^]
DATEADD function (MS Access)[^]

Posted 13-Apr-15 9:41am

Maciej Los

Comments

Sherif Adely 17-Apr-15 10:50am

Thanks alot :)

Maciej Los 17-Apr-15 11:19am

You're very welcome ;)