Hi,
So here's my dilemma. A few years ago a I created a Db that we use to perform inventories with. A big part of our business is making sure that our counters are keeping up the pace. On average we need a team of two people (One counting, one entering into program) to count 100 lines or records per hour. That's 1.67 records per minute.
On the main data entry form I have a text box that shows their current record count, which obviously increases by with each record that they add. The QTY of the actual items doesn't matter, just the number of records or lines, which is what the box shows.
Now for my problem. I have to come up with a way to indicate to the user (Counter) if they are keeping pace with the 100 line per hour average or if they are falling behind. Ultimately I'd love to be able to show a bar graph and a few controls that show, "Time to enter last item was 3 minutes" or something similar, as well as their average lines or records per hour based on their current pace, etc.. Something like "You are below the average" or better yet, I could just have the line count box turn yellow or red when they fall beneath the 100 per hour average and green when they are meeting or exceeding that average.
After working on this for 2 days I am now back to a blank page and am stuck. My last idea was to calculate the time between the previous record entry and the last or most current entry and do some calculations based on that but my brain is fried. I've been googling and hacking code for 2 days and gotten nowhere with this. Yes, I am new to Access and VBA. I haven't done anything with is since I spent 4 months creating our inventory database program.
Does that sound like the right way to go about this or does anyone have any other ideas on how I might be able to accomplish my goal? Any suggestions would be greatly appreciated. Thanks in advance!
So here's my dilemma. A few years ago a I created a Db that we use to perform inventories with. A big part of our business is making sure that our counters are keeping up the pace. On average we need a team of two people (One counting, one entering into program) to count 100 lines or records per hour. That's 1.67 records per minute.
On the main data entry form I have a text box that shows their current record count, which obviously increases by with each record that they add. The QTY of the actual items doesn't matter, just the number of records or lines, which is what the box shows.
Now for my problem. I have to come up with a way to indicate to the user (Counter) if they are keeping pace with the 100 line per hour average or if they are falling behind. Ultimately I'd love to be able to show a bar graph and a few controls that show, "Time to enter last item was 3 minutes" or something similar, as well as their average lines or records per hour based on their current pace, etc.. Something like "You are below the average" or better yet, I could just have the line count box turn yellow or red when they fall beneath the 100 per hour average and green when they are meeting or exceeding that average.
After working on this for 2 days I am now back to a blank page and am stuck. My last idea was to calculate the time between the previous record entry and the last or most current entry and do some calculations based on that but my brain is fried. I've been googling and hacking code for 2 days and gotten nowhere with this. Yes, I am new to Access and VBA. I haven't done anything with is since I spent 4 months creating our inventory database program.
Does that sound like the right way to go about this or does anyone have any other ideas on how I might be able to accomplish my goal? Any suggestions would be greatly appreciated. Thanks in advance!
Last edited: