Prev: How do I format a field based on the value
Next: Update box with combo box
From: Noodnutt on 24 May 2010 18:55
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.



From: PieterLinden via AccessMonster.com on 24 May 2010 19:06
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1

From: Noodnutt on 24 May 2010 19:42
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.


"PieterLinden via AccessMonster.com" <u49887(a)uwe> wrote in message
news:a880fef18b146(a)uwe...
> 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.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1
>



 | 
Pages: 1
Prev: How do I format a field based on the value
Next: Update box with combo box