Access as event timer?

[Jennifer Murphy]

How would I go about writing a front end for Access so I could use it to keep track of the time I spend on various tasks? The database part would have tables for the clients, the tasks, etc. The UI would run constantly with a little window where I could select a client and a task and start a timer. When I stop it, it would create a log entry which I could then tally at the end of the month.

I'm sure this is possible, but I'd like pointers as to where to start looking & studying.

Thanks

[June7]

Options:

1. Go to new record on form, click button to execute code to save that current date/time into StartTime field of table. Click another button to save current date/time into EndTime field of table. Run query that calculates difference between the two fields.

2. Each click of buttons creates a new record. Run query that calculates the difference between records (this is a trickier query).