Keeping up with changes made to Table

[cw4ranger]

I have a DB with one (1)Table I call "Property". I basically maintain an Inventory of property, (CPU's. Printers, Monitors, etc) each piece of equipment has a serial number, and a Bar Code number. Besides serial number and barcode number, I track the location of each piece of equipment (building number, and room number) our tech support guys occasionnaly move equipment from room to room or from one building to another. I have reports based on querys that show where the equipment is by room and buillding no. I know I can open the table or create a form to change the location, but what I have not been able to figure out is how to create a report that shows or reflect the move: i.e. "Barcode No: A000123 and Ser No: 54321 CPU:MBI, was moved from room No:291 to room number 292. Any sugestions? Respectfully Lou.

 

[pdldavis]

Hi, it sounds like you may only need to add a new field to your table so you have two tables like [currentLocation], [newLocation]and build a new report to reflect the contents of this two fields. I'd add a couple date fields too if you haven't all ready.
Hope that helps.

 

[MichaelRed]

A REAL stretch would be to maintain a "transaction log" on the table. To do so in Me. A, you would need to FORCE all changes to occur through a form, and then figure out how to implement the functionallity shown in faq700-184. The first is sither a matter of self-dicipline (if YOU are the only one using this db) or implementing the Ms. A. Security and allowing access to the table ONLY through the form if it is accessible to a group.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over