Reminders pop-ups on a particular day in access 2

[springy2003]

Hi, I am not sure if it can be done in coding, but I want my database that I have at the moment to produce a pop-up box every friday. The pop-up box isn't really a pop-up box, but really just a form that just remind the user to backup data. So is there a code that can check the day and if the day match, it will open up the form. I know I have to use the autoexec marco to do this, probably...

Thank you

Richard

 

[ETID]

here's one example....


sub its_friday()

if Weekday(Now()))=6 then
msgbox("Please backup your data")
else
end if

end sub

 

[springy2003]

HEHE, thanks for that mate. Needed that!!!

 

[springy2003]

One more question, what if I want a message box to pop up on the first of the month? I try replacing Weekday with Month and 6 with 1, but it doesn't work. Any suggestion?

 

[Gwena]

The code should be something like this:

If Day(Now()) = 1 Then
MsgBox ("Please backup your data")
Else
End If

it will pop every 1st of the month

 

[ETID]

And here are both arguments in one sub...

if Weekday(Now()))=6 or Day(Now()) = 1 then
msgbox("Please backup your data")
else
end if