Control limitations

[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.

 

[PieterLinden via AccessMonster.com]

Sounds like a non-normalized design. Each 15 minute increment is the
smallest chunk you need to record information about, so would that not be the
lowest child on the relationships? If you build that first, you can drop it
into a Person/Date form... but if you're trying to do this as if it were a
spreadsheet, you need to rethink your design. Before you even start the
interface, try adding a few records to your tables and getting the correct
query results. If you don't, you run the risk of coming up with an interface
that appears to work, but underlying table structures that do not allow you
to effectively query the data you have collected.

 

[Noodnutt @ Work]

Thx for your reply Pieter

I was kinda hoping to make it Point/Click with the layout, seems it won't
be, so it's back to the drawingboard.

Thx again.