Solve : Access database/Producing a message when the weekday turns to

1.	Solve : Access database/Producing a message when the weekday turns to Friday?
Answer» 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.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. Thanks Sidewinder - your suggestion works perfectly!!!

Discussion