Event occur on specific weekday (Access 2002, Win 2nd E)

Topic

New Reply

I need a message to be displayed when a form is closed, but only on Friday. How do I set the message only to be displayed on Fridays?

Thanks for any help. Fay

Reply | Quote

Replies

Something like this will work in the Close event of the form:

  If Weekday(Date) = vbFriday Then
    MsgBox "It's Friday!"
  End If

Reply | Quote

Thanks Charlotte. I had everything right EXCEPT the (Date). Plugged it in and like magic it worked. Thanks again. Fay

Reply | Quote