Results 1 to 10 of 10
  1. #1
    nurul is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    37

    how to make alert message or pop up message using access 2007?

    hye,

    i want to make alert message that will be pop up when the return date for borrowing book is one day before the date. and the alert message will also can show the information about the borrower.

    the alert message will be something like this. Tomorrow one borrower need to return the book. click ok to view the data.

    can access 2007 do this kind of alert message..?
    can anyone teach me how to do it..

    i really do not know how to this.?

    your help is much appreciate..

    thank you in advance.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    So you want the db to look at data in table and find records where the due date is tomorrow? Build a form or a report to display data. Open the form or report every morning. The form/report can have filter to show only those records that meet criteria OR show all records and use Conditional Formatting of textboxes to highlight red where the data meets criteria.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    nurul is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    37
    hye June7 for your reply..

    actually i want to make a pop up message that when i open the switchboard, it will tell me there are someone need to return the book tomorrow, if i click yes at pop up message, if will pop up the reminder form about the who is gonna need to return the book. i have try to do this, but my pop up form do not only show the result but it will show all the data in my table.
    and i also do not have pop up message that tell me there are someone need to return the book. it just will pop up the form if it fulfill the date requirement but unfortunately, it will show you the whole data in my table not the exact result alone..

    can you help me to solve this problem..

    thank you in advance.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Code in switchboard form Open event like:

    If DCount("ID","table","DueDate=#" & Date() + 1 & "#") > 0 Then
    If MsgBox("Books are due tomorrow. Do you want to review?", vbYesNo) = vbYes Then
    DoCmd.OpenForm "formname"
    End If
    End If
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    nurul is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    37
    thank you June7...
    it works right now..
    but can i ask you 1 more things, how can i add the reminders message will also come up when the return date is same with the today date..
    means i want the reminders will pop up when one day before and the exact date..

    can you help me on this?

    thank you in advance..

  6. #6
    nurul is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    37
    i have try this
    If DCount("ID","table","DueDate=#" & Date() + 1 & "#") => 0 Then

    it's true?i just add => only

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Try:

    If DCount("ID","table","DueDate BETWEEN #" & Date() & "# AND #" & Date() + 1 & "#") > 0 Then
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    nurul is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    37
    Thank You June7,

    it work perfectly then..
    thank again
    your help is much appreciate..

  9. #9
    nurul is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    37
    hey June7,

    i need your help one more time..

    my problem right now is if i want to make reminder using outlook email, can this be done..
    it is same like the problem before but if i want to have email notification for due date..

    can this be done using access 2007?

    thank you in advance.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Access Warning Message
    By marksnwv in forum Access
    Replies: 1
    Last Post: 06-01-2012, 01:46 PM
  2. Sending message within access
    By winterh in forum Access
    Replies: 2
    Last Post: 04-01-2012, 03:47 PM
  3. Make Table Warning Message
    By cassidym in forum Queries
    Replies: 1
    Last Post: 03-16-2011, 10:12 AM
  4. Alert Message Code Problem
    By 10 Gauge in forum Forms
    Replies: 1
    Last Post: 03-15-2011, 12:17 PM
  5. Access warning message
    By John Southern in forum Access
    Replies: 2
    Last Post: 05-28-2010, 06:01 AM

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