Static data in Forms

[szag via AccessMonster.com]

I have always struggled with creating static data points in a form. I need to
create a form where by managers have to add hours for different tasks their
employees peform, almost like a weekly time sheet. Where I struggle is if
there are 5 different types of data tasks under a field we call "TaskID" how
do I get all 5 to show on the screen at once - when there is no data at the
beginning of a week. If this helps:

TaskID Week1 Hours Week2 Hours

Forecasting/Planning
Month Close
Account Reconciliation
P&L Reporting
Time off
TOTAL

 

[NetworkTrade]

there's a bunch of ways.....

have each task be a field in the table

have the tasks be dropdown comboboxes....

 

[szag via AccessMonster.com]

Thanks.

Sounds like you are leaning towards what I thought I might have to do. If I
need every task to show no matter the situation I need to make a field out of
each task. A combo box would not work if I needed every task to show each
time a someone went into the form. Sound right?

there's a bunch of ways.....

have each task be a field in the table

have the tasks be dropdown comboboxes....

I have always struggled with creating static data points in a form. I need to
create a form where by managers have to add hours for different tasks their

[quoted text clipped - 11 lines]

Time off
TOTAL

 

[NetworkTrade]

well - if there are only ~5 categories and generally time is made in
each...sure a field each is fine....

if it were 50 categories....and only ~5 have time applied per week...then
you would want to go to the dropdown/combobox approach.... they pick the
category then apply the time - it is no biggie....

it sounds like to you that one big aspect is that the categories "show all
the time" - which helps tilt it to the first approach; but selecting from a
dropdown really isn't that much different. One would think your users could
adapt either way....


--
NTC

Thanks.

Sounds like you are leaning towards what I thought I might have to do. If I
need every task to show no matter the situation I need to make a field out of
each task. A combo box would not work if I needed every task to show each
time a someone went into the form. Sound right?

there's a bunch of ways.....

have each task be a field in the table

have the tasks be dropdown comboboxes....

I have always struggled with creating static data points in a form. I need to
create a form where by managers have to add hours for different tasks their

[quoted text clipped - 11 lines]

Time off
TOTAL