Access database/Producing a message when the weekday turns to Friday

[catz]

I'm looking for Code that will allow me to program a command button whose function is to close the database to produce the message "Happy Friday and have a nice weekend"  -  only, of course, when the weekday becomes Friday.

Any help will be appreciated.

[Sidewinder]

Something like this may help:

Code: [Select]

if weekday(now) = vbFriday then msgbox("Happy Friday and have a nice weekend")

Use the code in the button click event along with the code to close the database.

 

[catz]

Thanks Sidewinder - your suggestion works perfectly!!!