Best way to schedule sessions as conference?

[Katie Howard]

I'm looking for recommendations on the best way to proceed. I currently have a database with a few hundred presetation submissions and I send out the database to about a dozen or so people within our company for them to review, rank, and add comments about these sessions. I then end up with a subset that we want to accept and I need to schedule each one (so session 112 is on Monday at 2:30pm; session 54 on Wednesday at 10:30am, etc.)

I had set up a scheduling form so I can see at-a-glance when each one is set for (like the image I have attached) The form contains a lot of combo boxes (and each one does conditional formatting based on the session I select) - and I really like how it works; but I've run into a problem. If I add any more combo boxes I keep getting an error about how Access is unable to open any more databases and it doesn't display all the data.

I need to add approximately 100 more sessions, so I clearly need to find a different way to do this as it seems that there's a limit on the number of combo boxes you can have on a form.

Does anyone have any recommendations as to what would work well for this? Thank you in advance!

[zmbd]

Katie,

Wow... that's alot of comboboxes... looks like you're trying to build a calendar showing every day and every hour for a ton of classes?

I think the reason you haven't a nibble is that there's not enough bait on the hook. :)
Read this first: How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!

Ok, now that you've read that you should understand why we need to understand the design of your database and the urgency of your need. We do not need actual data especially if it is of a confidential nature. However, we do need to have at least the tables and their relationships and the queries.

The design is imperative... without it, there is no way to help you with the issue other than to give the generic suggestion that you should consider a form/subform, tabbed form, or a form based on a crosstab query.

The only other suggestion, for your sanity, is that you might consider a front-end/back-end design so that you would only need to distribute the front-end once (unless there are design changes)... that supposes though, that the people have access to the network where the back-end would be located.

My last suggestion... have you looked at Outlook-2010? If using an enterprise server, it has the ability to track location resources, meetings, and people... in anycase, you can setup meetings and assign people to them, etc... Once again, this supposes that everyone will be able to have access to the server... well, you could send the appoinments out via email attchment... but I digress from the topic.

-z