Access database - help please

  PA28 16:19 18 Feb 08
Locked

My son is trying to design a booking system for time slots completely in Access as part of a college project. We are having trouble in making the availability of a slot conditional on it not having been booked already.

We have designed a booking form which offers timeslots in the form of a combo list box. We are able to apply validation to eliminate multiple bookings, however we would like the booking form to only offer available time slots (and not to display those already booked). Any ideas how this can be achieved please?

  fishmad pete 17:54 18 Feb 08

I don't know if the following link will be any good to you but it seems to cover a similar topic
click here

  PA28 18:36 18 Feb 08

Many thanks - we'll try that. When my son's torn his hair out we'll let you know how we (he) got on!

  Curio 18:52 18 Feb 08

Possibly some info here
click here

  PA28 20:49 18 Feb 08

Thanks guys. Fishmad pete - that link has really given him something to work on - which he is. Many thanks.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…