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

Logging Record Changes

P: n/a
I am developing an inventory database. The warehouse operator has an
"Edit Inventory" form where he makes changes to incoming quantities.
He can pull up a line item, and enter how many just came in the door,
which will in turn update the total quantity.

I need to be able to log each of those transactions, so that I can run
a report showing all inbound activity. Or for a given line item, I
could run a report showing all the inbound transactions for a given
period of time. What's the best way to capture this info?

Oct 9 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Have you looked at Allen Browne's Audit Tracking? It's fantastic -
easy to use and clear instructions.

http://allenbrowne.com/AppAudit.html

Sara

igendreau wrote:
I am developing an inventory database. The warehouse operator has an
"Edit Inventory" form where he makes changes to incoming quantities.
He can pull up a line item, and enter how many just came in the door,
which will in turn update the total quantity.

I need to be able to log each of those transactions, so that I can run
a report showing all inbound activity. Or for a given line item, I
could run a report showing all the inbound transactions for a given
period of time. What's the best way to capture this info?
Oct 9 '06 #2

P: n/a
I see Allen recently updated the code for this? (July 2006). I've been
using the old code for a while, does anyone know what functionality is
changed/added up updating to the new code? i didn't want to go through
all of my forms and change it if it wasn't necessary at this point.
The old code seemed to work good.

sara wrote:
Have you looked at Allen Browne's Audit Tracking? It's fantastic -
easy to use and clear instructions.

http://allenbrowne.com/AppAudit.html

Sara

igendreau wrote:
I am developing an inventory database. The warehouse operator has an
"Edit Inventory" form where he makes changes to incoming quantities.
He can pull up a line item, and enter how many just came in the door,
which will in turn update the total quantity.

I need to be able to log each of those transactions, so that I can run
a report showing all inbound activity. Or for a given line item, I
could run a report showing all the inbound transactions for a given
period of time. What's the best way to capture this info?
Nov 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.