View Single Post
  #1  
Old May 24th, 2010, 11:55 PM posted to microsoft.public.access.forms
Noodnutt @ Work
external usenet poster
 
Posts: 9
Default Control limitations

G'day all

Using Acc2003 in 2K format, as work has not taken the step up to 2007 yet.

Is there a way to bypass the maximum "Controls on/in a form" limitation.


Background:

Essentially, I am attempting to create a "Fatigue Management" DB which
records all driver activities during each 24 hour period over a seven day
period.

The particular form I am attempting to generate requires a substantial
amount of input as it is based over a 24 hour period broken into 15 minute
increments.


Each 15 minute incremented bracket contains the following control:

1 x Option frame with 2 options (Rest or Work)
2 x Labels which change colour depending on selection
6 x Lines for seperation
1 x control source field

Multiply this by 24 hours and there is lots, so far I have got to 7 hours
and I have hit the wall, and the above still does not include the actual
time calculation fields which will have to be done via 2 seperate subforms
due to this control limitation issue.

I look forward to any suggestions

TIA
Mark.