Auto Message

[maya]

Hi,

Im coming up with an access application where in this application the user will be recording stuffs and wach record will have the date when the user recorded it. Now one feature has to be added which is to create an auto message which pops out when the user checks for the record entered and if it has been in the database for more than 2 weeks a message box will appear stating a warning...how to do that and which event should i use...thank you.

regards
Maya

 

[louchey]

Try searching previous posts for "dateDiff" and "MsgBox" function

Regards

Ben

 

[maya]

thanx

solved it using
if (DateTime.Date- me.Date) then
....

 

[Rich]

You should not use Date as a field name, it's a reserved word in Access