How to limit number of bookings help!! (1 Viewer)

C

CH3

New member

Local time

Today, 03:15

Joined

Jan 10, 2019

Messages

1

• Jan 10, 2019

• #1

I need to limit the number of bookings on a certain day to 6 in a database that I am developing in Access. The field is called BookingDate. Any ideas?

 

P

plog

Banishment Pending

Local time

Yesterday, 21:15

Joined

May 11, 2011

Messages

11,638

• Jan 10, 2019

• #2

Probably have to do this through logic on a form. You provide more specifics about your situation and database, I can provide more specifics about a solution.

 

bastanu

AWF VIP

Local time

Yesterday, 19:15

Joined

Apr 13, 2010

Messages

1,402

• Jan 10, 2019

• #3

In the BeforeUpdate event of the BookingDate control do a check of current bookings for the day using a dcount and display message and cancel if already 6.

Cheers,
Vlad