Restricting the number of records that can be created by date

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I am trying to set up a scheduling database system, in
which I must restrict the number of events (records) by a
different amount for each day of the week.

For Example:
Monday: schedule 70 calls
Tuesday: schedule 85 calls
Wednesday: schedule 45 calls

What validation rules of expression would work for this.

Thanks
Keith
 
I am trying to set up a scheduling database system, in
which I must restrict the number of events (records) by a
different amount for each day of the week.

For Example:
Monday: schedule 70 calls
Tuesday: schedule 85 calls
Wednesday: schedule 45 calls

What validation rules of expression would work for this.
Click to expand...

A table validation rule isn't going to work here, I don't think!
You'll need to force all your data entry to be done from a Form and
use VBA code in the Form's BeforeInsert event to count records, and
set the sub's Cancel operand to True if there are already the max
number of allowed records.
 
Back
Top