Help!! Try to create grid type switchboard for meeting rooms reservations

[steve1040]

All,
I'd like to create a switchboard that allows us to see room status.

[steve1040]

On Nov 21, 6:53 am, steve1040 <sjo...@swbell.net> wrote:
> All,
> I'd like to create a switchboard that allows us to see room status.

Sorry I hit *enter* by accident

I'd like to create a grid with

Column A = the day of week, Date ( Example: Mon - Jan 1, 2009) for the
next 30 days
Row 1 = Meeting Room Number (There are 25 total)

The goal
There will be a clickable button or cell for each room for the next 30
days
If the room is available , Can click on it and bring up our
reservation form

I was thinking a form full of command buttons but how do I insure the
dates are dynamic?

[Roger]

so you want a grid of 30 rows (day of the week) by 25 columns (room
number) ?
that's 750 controls, pushing the ms-access limit

what about a grid of 5 rows (week of the month) by 5 columns (day of
the week) using text boxes - to create a calendar

box1.controlsource = a sunday date
box2.controlsource = box1 + 1
box3.controlsource = box2 + 1
etc

then when you double click on a date, it shows you a continuous form
with the room number / status

[paii, Ron]

If your table is something like the following
tblRoomSch
RoomNumber
SchDate

Use a crosstab query on RoomNumber using IN (1,2,3 ....25) as the form
source. This will give you 25 rooms as columns and unlimited rows of days
with a mark in each column show days where the room is booked. Booking a
room could be done with a double click event on the Row/Column of choice.

"steve1040" <sjo...@swbell.net> wrote in message
news:437e3644-4118-4be7...@a31g2000yqn.googlegroups.com...