J
Joshua Powell
I am a relatively inexperienced Access 2002 user but I am determined!
I am building an application for use in planning an event where many
workshops will be going over the period of two days, 6 hours a day, in
12 different rooms in a large building.
I already have set up a table for contacts (ie prospective workshop
instructors), and a table for information on the workshops, and
beautiful forms for use in maintaining the data.
Now I want to build a form that looks like a glorified excel
spreadsheet with columns being each room, and the rows being times
between 12PM and 6PM in half hour increments and each cell filled with
the names of the workshops.
The benefit of this being that putting these events inside these
time/room slots will then add that information to the forms for the
workshops, and any of our multiple people working on this program can
keep updated on how the workshop coordinating is going.
Essentially, a person could just do this on paper or excel and when
the schedule is finished just put the times / rooms info into the
tables I've already created, but where is the fun and beauty in that?
I hope I've accurately described my project, and I hope this sort of
project is old hat to some of the pro's that post to this group.
Thanks!
I am building an application for use in planning an event where many
workshops will be going over the period of two days, 6 hours a day, in
12 different rooms in a large building.
I already have set up a table for contacts (ie prospective workshop
instructors), and a table for information on the workshops, and
beautiful forms for use in maintaining the data.
Now I want to build a form that looks like a glorified excel
spreadsheet with columns being each room, and the rows being times
between 12PM and 6PM in half hour increments and each cell filled with
the names of the workshops.
The benefit of this being that putting these events inside these
time/room slots will then add that information to the forms for the
workshops, and any of our multiple people working on this program can
keep updated on how the workshop coordinating is going.
Essentially, a person could just do this on paper or excel and when
the schedule is finished just put the times / rooms info into the
tables I've already created, but where is the fun and beauty in that?
I hope I've accurately described my project, and I hope this sort of
project is old hat to some of the pro's that post to this group.
Thanks!