Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Anaheim, California, USA
    Thanked 2 Times in 2 Posts

    OnDelete (2003/SR2)

    I have a DB that keeps track of employees vacations. We allow a maximum of 4 people off per day. Some days, such as the day before Thanksgiving or the day after Christmas, we get requests for more than that. We have a process that we go through and if there are more requests than 4 some people are denied. What I would like to do is to set up a table to keep track of the days denied, by employee ID and date, and then, if someone cancels their vacation request for one of the coveted dates, when the date is deleted, Access checks to see if their are any of the denied dates that match. If so, it would pop up a message box after the delete, telling whoever entered it that there were other people that wanted that same date. Does anyone have any code that would do that? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: OnDelete (2003/SR2)

    This is a rather general question. It would be easier to help you if you provided specific information, and preferably posted a stripped down copy of your database. See <post#=401925>post 401925</post#> for instructions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts