Results 1 to 2 of 2
  1. #1
    dgrimes is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    11

    Message Box that appears according to the information in a query

    Hello,

    I have a query and report that I need to create a macro for. The report shows all employees that have overdue temporary badges and is sorted by the due date field. I need a Message Box to appear when the the database is opened and there is data in the "Date Due" field. I cannot get this to work and it keeps telling me I have the syntax wrong.

    qryBadgesOverdue
    rptTempBadgesOverdue
    DateDue Field with any data needs to trigger the message box

    Please help if possible!



    Thank you!

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    i would make an autoexec macro that runs code in a module. That code would use a dlookup to see if the data matches criteria. If it does, i would then Messagebox and alert the user.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-05-2015, 03:51 PM
  2. Replies: 7
    Last Post: 07-31-2014, 05:14 PM
  3. Replies: 3
    Last Post: 06-10-2014, 11:50 AM
  4. Replies: 1
    Last Post: 03-18-2014, 04:07 AM
  5. Information message on current event
    By justauser in forum Forms
    Replies: 5
    Last Post: 02-07-2012, 12:15 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