G
Guest
Hi guys,
I have created a form which runs a query listing all suppliers in our
database, every 6 months we want to go through this list and remove or update
each supplier - is there a way to automatically schedule a msgbox to appear
on a certain date 6 months from now?
I imagine I can do something along the lines of declaring a date which is 6
months from now and then everytime the form is open I simply compare today's
date with the declared date and if they don't match, do nothing, if they do
match then open the MSGBOX, but my VB skills are very limited and I'm not
sure exactly how to code this.
Any help would be gratefully received.
I have created a form which runs a query listing all suppliers in our
database, every 6 months we want to go through this list and remove or update
each supplier - is there a way to automatically schedule a msgbox to appear
on a certain date 6 months from now?
I imagine I can do something along the lines of declaring a date which is 6
months from now and then everytime the form is open I simply compare today's
date with the declared date and if they don't match, do nothing, if they do
match then open the MSGBOX, but my VB skills are very limited and I'm not
sure exactly how to code this.
Any help would be gratefully received.