Entering data for a manual process.

[athyeh]

Hi Folks,



Need ideas. I need to create a form that users can use to track productivity of a manual process (no access to computers). What needs to be tracked:

• Items processed every hour
• Out of Inventory Time

My initial idea (which I implemented) was to just create a textbox per hour range starting from 6 AM - 7 AM all the way through 11:00 PM - 12 AM. This did the trick for data-entry but withdrawing any kind of query or report is nigh-impossible, given that there are just too many fields for Access to process.

So I need ideas, on how to design a user-friendly form that can track how many items Suzie did over her day, by hour.

Thanks!

[June7]

Normalized structure would be a record for each time entry.

The more user-friendly, the more code.

[athyeh]

I am thinking a long the same lines so four fields: Operator, Production, Out of Inventory Time, Time of Production

Records will look like:

Operator Production OIT TOP
Suzie 54 36 6 AM - 7 AM

To eliminate input error going to have to use drop-downs for Operator and TOP, but my knee-jerk reaction is that drop-down's slow data-entry?

Also thoughts for TOP should I use labels (6:00 AM - 7:00 AM) or some kind of numeric system?

[June7]

Could have some sort of login process or code that recognizes the user from their network login (I do that) and automate filling in the Operator field.

Could have current date/time automatically record with DefaultValue of Now() then calculate the time period later.

That leaves Production and OIT fields for user entry.

As I said, the more user-friendly, the more code.

[athyeh]

Thank you for the ideas. Created the form with drop-downs and fields described above. Thread solved.