By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,089 Members | 1,039 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,089 IT Pros & Developers. It's quick & easy.

Help - Date Tracking

P: n/a
Hi

I'm developing a database with access and I was ask to include in the report
the date of issue. But if the date of issue was change It should be
included in the footnote area the issue date that was originally was written
and by who. And as if it was changed several times it should be included as
well.

How can I include this historical tracking in the report?

Any help I would really appreciate it.

Thanks,
Ely

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Access cannot do this for you, but if all editing is done in forms you can
use the form events to write an audit trail, recording inserts, edits, and
deletes, with date/time and user.

You will need to be comfortable with VBA and have an understanding of the
form events to achieve this. Details in article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Evelyn Pabón" <ep****@coqui.net> wrote in message
news:AD**************@fe39.usenetserver.com...

I'm developing a database with access and I was ask to include in the report the date of issue. But if the date of issue was change It should be
included in the footnote area the issue date that was originally was written and by who. And as if it was changed several times it should be included as well.

How can I include this historical tracking in the report?

Nov 13 '05 #2

P: n/a
Do you want to create a table that keeps track of the report history?
Another thing you can do is create a report history field that you
constantly add to when ever someone changes the record.
"Evelyn Pabón" <ep****@coqui.net> wrote in message
news:AD**************@fe39.usenetserver.com...
Hi

I'm developing a database with access and I was ask to include in the report the date of issue. But if the date of issue was change It should be
included in the footnote area the issue date that was originally was written and by who. And as if it was changed several times it should be included as well.

How can I include this historical tracking in the report?

Any help I would really appreciate it.

Thanks,
Ely

Nov 13 '05 #3

P: n/a
"Evelyn Pabón" <ep****@coqui.net> wrote in message news:<AD**************@fe39.usenetserver.com>...
Hi

I'm developing a database with access and I was ask to include in the report
the date of issue. But if the date of issue was change It should be
included in the footnote area the issue date that was originally was written
and by who. And as if it was changed several times it should be included as
well.

How can I include this historical tracking in the report?

Any help I would really appreciate it.

Thanks,
Ely


This should be posted in the Access NG only. There's an example of
this at Allen Browne's website. Look for Audit trail...

http://members.iinet.net.au/~allenbrowne/AppAudit.html
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.