Hi to all of you,
I am trying to create a holiday cottage booking system using VB.net front end (CGI) and MS Access for the database. I am at struggling to come up with a system that will check and prevent double bookings.
Bookings can only be made from Saturday to Saturdays. So I need to a database table that is populated with Saturday dates and when a date is selected by the user the query should check against the selected property to see if the week starting with this date is available or not. If the booking is then accepted, data in the table needs to be changed to "not available" and the record updated etc.
The date checking as me baffled at the moment!!!!
How can I populate in field in the database with Saturdays only? I could enter them by hand, say for the current 12 months, but for next year and so on ?
This has to be done from VB.net via SQL, not from Access forms.
Any tips would be greatly appreciated.
Thanx in advance,
Glyn