Hi Guys
I have a table as below:
ProjectRef VPrintdate Reminder
P14 1/03/2012 No
P15 2/03/2012 No
P16 30/03/2012 No
Now everytime the main form is loaded I want to run the code so that it looks for the ProjectRef whose 30 days have past since VPrintDate and reminder is still No and then display it on Label20 caption e.g
Label20.caption="P14,P15 Reminders are due"
Can anyone please provide me the code for this?
Thanks
I have a table as below:
ProjectRef VPrintdate Reminder
P14 1/03/2012 No
P15 2/03/2012 No
P16 30/03/2012 No
Now everytime the main form is loaded I want to run the code so that it looks for the ProjectRef whose 30 days have past since VPrintDate and reminder is still No and then display it on Label20 caption e.g
Label20.caption="P14,P15 Reminders are due"
Can anyone please provide me the code for this?
Thanks