Warning message or email

[redbay]

i have a field on a form called action closed and a date that the action has to be closed by (3 days later than date entered), can i get either a warning to pop up or an email sent to the user if the action hasnt been closed by the specified date?

 

[gol4]

Yes you can. How you accomplish this depends on your database design. First you need a query to find if the field is null or has a improper date
then you will need to decide when you want this query to run. Then the warning could be a simple msgbox via a macro. To do the email you would need a list to decide which user gets what. I can say each of these steps and how to do them are covered very well here in teks-tips and can be got either via a search or the FAQ section.

 

[redbay]

Like the idea of running it through a query and a message box, have searched through queries and the FAQ section but have not come up with anything, any further suggestions will be welcome!