Overdue popup message for Date Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 fields in a table (Rental Start Date & Rental Return Date, along with TransactionType - RENTAL or RETURN

Each time I enter a new record, I put in the Start Date and the Return Date for an item, along with whether the item was RENTED or RETURNED

Is it possible to have Access display a POP-UP message that informs the user if a particular item goes beyond a scheduled Return date

For example, Bill rents an item starting on May 5, 2004, 5:00 PM and plans to return it on May 10 @ 5:00 PM (5 Days). If he doesn't return the item by then (i.e. RETURN) then a POP up saying that this item has yet to be returned

Not sure if this is possible, but any feedback would be welcome

Thank you,
 
Assuming that you don't want to page through every record every day,
you will need code which runs when you open the database that runs a
query selecting for records where RETURNED is False and ReturnDate <
Now(). If the query returns any records, a popup form with further
information can be displayed.
 
Back
Top