N
Noodnutt @ Work
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.
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.