Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    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
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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
  •