Hi,
I am building a database to check out and check in equipment as a log (like a lending library). One aspect is to reserve equipment days, weeks, months in advance. I have the system set up to do this.
My issues is when the user wants to reserve some equipment they fill out a from with Job Number, Check Out Date, Due Date, Contact. Which is then added to a table called Reservations. This table is filtered against the equipment and any reservations already booked are displayed in a subform.
I want the Check Out Date to have a validation so that you can not select a date which lies between any of the Check Out Date (3 days before) and Due Dates (1 day after) in the reservations table.
I can get it to use the first record in the table to validate the entry by using the Validation property on the text box (see below).....
Not Between [Reservations subform].[Form]![Checked Out Date]-3 And [Reservations subform].[Form]![Due Date]+1
....How can i get it to use all the records so effectively the equipment can not be booked out once it is already reserved as shown in the validation text above.
Many thanks for any help :banghead:
I am building a database to check out and check in equipment as a log (like a lending library). One aspect is to reserve equipment days, weeks, months in advance. I have the system set up to do this.
My issues is when the user wants to reserve some equipment they fill out a from with Job Number, Check Out Date, Due Date, Contact. Which is then added to a table called Reservations. This table is filtered against the equipment and any reservations already booked are displayed in a subform.
I want the Check Out Date to have a validation so that you can not select a date which lies between any of the Check Out Date (3 days before) and Due Dates (1 day after) in the reservations table.
I can get it to use the first record in the table to validate the entry by using the Validation property on the text box (see below).....
Not Between [Reservations subform].[Form]![Checked Out Date]-3 And [Reservations subform].[Form]![Due Date]+1
....How can i get it to use all the records so effectively the equipment can not be booked out once it is already reserved as shown in the validation text above.
Many thanks for any help :banghead: