option buttons

  • Thread starter Thread starter steviegoodrich
  • Start date Start date
S

steviegoodrich

I am trying to design a database for conference room bookings, to be used on
our LAN.
The database will be accessed by approx 20 people and there are twelve
conference rooms in total.
I have limited experience whith Acces 97.

I thought of using 12 option buttons to select the conference room required.
How can i set it up so that you can only choose one option (the way you see
it it windows dialogue boxes)

I will also need a way to prevent the same room being booked at the same
time by different people

Also a quick way to check availability

the fields are
date req
name
conf 1
conf 2 etc up to 12
time from
time to
how many people
booked by

I'm not asking anyone to do it for me, just a few pointers in the right
direction would be great.

without vba if poss

thanks in advance
Steve
 
Steve,

Regarding the option buttons, you should not have 12 separate fields
Conf1, 2 etc, just have one field Conf. On your form, use an Option
Group bound to the Conf field, and then you add your 12 option buttons
to the option group. You will see that each option button in the option
group has a number assigned to its Option Value property, and this
number will end up being the value of the data entered into the Conf
field when that option button is selected.

Regarding preventing double-booking, one approach would be to make a
query, which uses in its criteria the values of the Conf, DateReq,
TimeFrom, and TimeTo fields currently being entered on the form (using
syntax such as [Forms]![NameOfForm]![Conf]). Then, on the form's Before
Update event, use some check whether this query returns any records (you
could use the DCount function for this), and if it does, cancel the
record update, and display a messagebox to the user that this room is
already booked for part of the time they require.

You will also be able to use a query as the basis of a form or report,
to show a summary list of all existing bookings for any/each room.
Showing "availability" is a bit trickier, as this means showing
timeslots where the room is not already booked, and I think this would
probably require a system of fixed timeslots to be listed in another
table for referencing available times.
 
Steve

Many thanks for all your advice, not sure I understand it all but it's given
me a great starting point to work from which is what I wanted. much
appreciated.

Think I clicked on wrong button and emailed you direct - Sorry

Steve

Steve Schapel said:
Steve,

Regarding the option buttons, you should not have 12 separate fields
Conf1, 2 etc, just have one field Conf. On your form, use an Option
Group bound to the Conf field, and then you add your 12 option buttons
to the option group. You will see that each option button in the option
group has a number assigned to its Option Value property, and this
number will end up being the value of the data entered into the Conf
field when that option button is selected.

Regarding preventing double-booking, one approach would be to make a
query, which uses in its criteria the values of the Conf, DateReq,
TimeFrom, and TimeTo fields currently being entered on the form (using
syntax such as [Forms]![NameOfForm]![Conf]). Then, on the form's Before
Update event, use some check whether this query returns any records (you
could use the DCount function for this), and if it does, cancel the
record update, and display a messagebox to the user that this room is
already booked for part of the time they require.

You will also be able to use a query as the basis of a form or report,
to show a summary list of all existing bookings for any/each room.
Showing "availability" is a bit trickier, as this means showing
timeslots where the room is not already booked, and I think this would
probably require a system of fixed timeslots to be listed in another
table for referencing available times.

--
Steve Schapel, Microsoft Access MVP

I am trying to design a database for conference room bookings, to be used on
our LAN.
The database will be accessed by approx 20 people and there are twelve
conference rooms in total.
I have limited experience whith Acces 97.

I thought of using 12 option buttons to select the conference room required.
How can i set it up so that you can only choose one option (the way you see
it it windows dialogue boxes)

I will also need a way to prevent the same room being booked at the same
time by different people

Also a quick way to check availability

the fields are
date req
name
conf 1
conf 2 etc up to 12
time from
time to
how many people
booked by

I'm not asking anyone to do it for me, just a few pointers in the right
direction would be great.

without vba if poss

thanks in advance
Steve
Click to expand...
Click to expand...
 
Back
Top