Tracking how much time I spend on a db

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

I'd like to track the time I spend working on the a db
(I'm just inputting data now) for billing.

I've seen word record how much time has been spent
working on a document but I think it records how long
it's open.

I've been using journal entries in outlook which have a
timer on them and would like to build something similiar
in my db so I can track my time. Any suggestions?
 
I've been using journal entries in outlook which have a
timer on them and would like to build something similiar
in my db so I can track my time. Any suggestions?
Click to expand...

You can have Outlook automatically journal any use of Access. In
Outlook, select Tools... Options... Preferences... Journal Options and
check "Also record files from Microsoft Access". In each database (if
you have different databases for different clients) you can select
File... Database Properties... Summary and put the client name in the
Company box; it will show up in the journal as Company.
 
ian said:
I'd like to track the time I spend working on the a db
(I'm just inputting data now) for billing.
Click to expand...

No idea as to how Outlook works but an option would be to add some
audit trails which would include the date/time of any
additions/updates.

There's a simple example at
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

Audit Trail - Log changes at the record level at:
http://users.bigpond.net.au/abrowne1/AppAudit.html
The article addresses edits, inserts, and deletes for a form and
subform.

Modules: Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm
The History Table routine is designed to write history records that
track the changes made to fields in one or more tables.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top