Msgbox to expire

[SteveGr]

Hi all,

I have a database that is used by 10 people or so. I have made a change and would like to alert them with a msgbox macro on form load. What I was thinking is to have the msgbox delete after 15 days so everyone had a chance to read it.

Any thought on how this can be done?

Thanks, Stevegr

 

[PaddyIrishMan]

SteveGR,
I know this will become completely redundant & uneccessary code but I would add a clause based upon the date on the users machine.

If Date() <= [15DaysFromDateDateYouWant] Then
     Msgbox("Whatever Message"),vbinformation
End if

I'd put this in the form load event. So when the user loads the form, if the Current date is less than or equal to the expiry date then display the message.

HTH
Patrick