Time Management

[Spac3Monkey]

Hi All

Hope you can help. I need to monitor the time in which it takes my team to complete certain tasks. I am currently doing this using an excel spreadsheet at the end of each day to record estimated times on certain tasks...its not working

What I want is a database that everybody can have open on their screen and every 30 minutes it pops up and the user has to select 2 options

Firstly they must select from a drop down box to show the area they are working on

e.g. Accounts, Backing Data or Emailing Communications

There will then be another drop down box of sub-areas

e.g. SOA, Acccounts Payable, invoice backing data, credit backing data

The last box will be a drop down field of their names

Once they have selected this the pop-up goes away but stores the time that it popped up in a table so I can report on it

Any way this or something similar can be done?

Thanks
Craig

 

[pbaldy]

It can certainly be done. Based on your description, you'll use things like the timer event of a form, cascading combo boxes:

http://www.baldyweb.com/CascadingCombo.htm

and one or more of the date/time functions: Now(), Date() and Time().