Form ideas - best way?

  • Thread starter Thread starter andre
  • Start date Start date
A

andre

Hello,
I am trying to do a small people scheduling db, and am stumped on the
best way to show the times already booked, and would like to hear any
ideas the group might have.
I want to have a form that has a type of grid: people's names on the
left side - vertical, and times of day across the top - horizontal. I
would like to use a text box to indicate the time someone is booked
i.e. 2.5cm = 1 hour.
13:00 14:00 15:00
jim xxxxx xxxxxx
sally xxxxxxxxx
gene xxxxx xxxxxxxxx

i.e. jim has two appointments of one hour, sally 1 for 1.5 hours, and
gene two appointments one for one hour and the second for 1.5 hours

Am I better to have the text boxes already populated the form, but
hidden and just make them visible as I need them? Should I create the
form and boxes including sizes/times when the form opens, using the
hidden design time feature, then make the form visible after all of
the boxes and positions and sizes have been created, then make the
form visible in preview mode?
Problem with having the boxes already created and then making them
visible is that I don't know how many people will have a schedule for
that day 10 or 50?
Any other way people in the group would do this? Will I run into a
problem with 500 text boxes on a form?
Any thoughts, pitfalls, previous examples, etc. would be greatly
appreciated.
I hope I've been clear on what I'm trying to do, if not I'll try
again.
Thanks,
Andre
 
This is just something for you to think about. I haven't tried it...

You could use a crosstab query and build a table with 30 minute intervals
during the day. That table would only need one field with values 6:30 am;
7:00 am; 7:30 am; etc.

Use the intervals as your column headers and the names as the row headers.

A schedule table with the name and interval would be the other table.
 
This is just something for you to think about. I haven't tried it...

You could use a crosstab query and build a table with 30 minute
intervals during the day. That table would only need one field with
values 6:30 am; 7:00 am; 7:30 am; etc.

Use the intervals as your column headers and the names as the row
headers.

A schedule table with the name and interval would be the other table.
Click to expand...

Hi Bill,
The table side is ok, it's the form side I'm having a real problem with,
which will be used to both view and enter scheduled times.

I guess a picture is worth a thousand words, so here is a link to what I
would like to do, but don't know the best way to do it:
http://www.retaininternational.com/products/screenshots/retainresource_sc
reenshot_01.htm

I imagine this would all be done with text boxes, and the thing that's
stumping me is the best way to create these text boxes? Have a couple of
hundred on the form, but invisible and just show the ones I need?
But what if I need more?
Do I create them using vba code, on the fly, by opening a form in design
mode, hidden, then make visible when the coding is finished and I have all
of the boxes in place?
What if I hit the maximum nubmer of controls?
I will destroy the form each time it's closed, but will I still have bloat?
Any help on the best way to achieve what's in the above link would be very
greatly appreciated!!
Andre
 
Back
Top