Dear gents ,
Um trying to do a small task which is every Thursday a msgbox pop up for users to remind them doing some task .. how ?
Dear gents ,
Um trying to do a small task which is every Thursday a msgbox pop up for users to remind them doing some task .. how ?
Need more info I think.
Do you have an initial form that users start on?
Is the database split?
Have a table to show when the last "warning msg" was shown
then basically
if today is a Thursday and no warning has been given today then
msgbox "please remember to do this today"
update the field in a local table to say the message was given
return to main program
First thanks for fast reply,Need more info I think.
Do you have an initial form that users start on?
Is the database split?
Have a table to show when the last "warning msg" was shown
then basically
if today is a Thursday and no warning has been given today then
msgbox "please remember to do this today"
update the field in a local table to say the message was given
return to main program
Do i need a field in a table to save the last warning msg ?
If so then why ?
I just need to tell them don't forget to do that task .
Or can i do it on the start up form for each user ?
But if the user saw it he shouldn't see it again
Tblmessage
ID as autonumber
MsgDate as datetime
MsgSeen as Boolean
You're just recording when the last message was seen and the OK button was pressed (so you know they saw the msg)
Unless of course the user only starts the program once a day???