Scheduling woes

[melwheels]

I'm trying to create a form to simplify a somewhat complex scheduling
task.

I have individuals attending tests that take place at a given date and
session (AM or PM). For each individual/test, I have to assign both a
room and a supervisor. I want to create a pick list for the rooms,
and a pick list for the supervisors. Each room or supervisors can
only be used once per session (exception described below). I want the
pick list to display only available rooms, and only available
supervisors. So if the room or supervisor have already been scheduled
for that date/session, they don't appear in the list.

To complicate things, there is one room that can be used more than
once (called ET). If the ET room is used, then the supervisor
assigned to that room for that date/session can still appear in the
list, but only if the ET room is selected for that date/session.
Clear as mud, yes? :-/

I'm working from a table, which I'm not able to change, as it is part
of a bigger application used in other places. This means that the
"magic" has to happen either at a query and/or form level.

I fear I'm not making much sense, but I hope you can help me.

Thanks

Melanie

 

[Guest]

I hope that other consultants can help you using MS Access for this. I am
proficient in Ms Access but have consicerable amount of experience in
resource scheduling. a supervisor and a room are considered a resource.
Have you considered using MS Project or Primavera. There are many other
scheduling tools out there that may suit this better than Access. The
advantage of these tools are the graphical reports that can be produced.

Good Luck

 

[melwheels]

I hope that other consultants can help you using MS Access for this. I am
proficient in Ms Access but have consicerable amount of experience in
resource scheduling. a supervisor and a room are considered a resource.
Have you considered using MS Project or Primavera. There are many other
scheduling tools out there that may suit this better than Access. The
advantage of these tools are the graphical reports that can be produced.

Thanks Eric,

Unfortunately, the scheduling aspect is but a small part of the
function we need for this, and everything is locked into Access, so we
can't switch to other applications.

That said, I think I found my answer, mostly. Thanks