Results 1 to 4 of 4
  1. #1
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134

    Show msgbox on specific date

    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 ?

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    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

  3. #3
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134
    Quote Originally Posted by andy49 View Post
    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,
    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

  4. #4
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    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???

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Show Valuees from Subform in MsgBox
    By Ossos in forum Access
    Replies: 9
    Last Post: 10-09-2016, 06:54 AM
  2. Replies: 2
    Last Post: 10-13-2015, 10:03 AM
  3. Replies: 4
    Last Post: 11-20-2014, 01:05 PM
  4. Subreport will not show specific data
    By mitchy1111 in forum Reports
    Replies: 1
    Last Post: 05-18-2011, 07:36 AM
  5. Text Box to show specific record
    By chu3w in forum Forms
    Replies: 1
    Last Post: 04-01-2010, 12:23 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums