Coding Thread, VBA Code to copy all form updates to one form in Coding and Web Development; Afternoon,
I am looking for some VBA code for an access database which will copy all data entries from all ...
24th January 2010, 02:24 PM #1
VBA Code to copy all form updates to one form
I am looking for some VBA code for an access database which will copy all data entries from all forms to one form as a kind of summary each time something has been updated in a given field, ideally, adding a date and time stamp of when it was amended and by whom.
Any pointers would be much appreciated!
27th January 2010, 07:39 PM #2
- Rep Power
Originally Posted by acrobson
What your describing is the UI/presentation of an Audit trail
So when any of your forms update(CRUD) the DB your code should write an entry to an Audit trail table and updates to this table should trigger an event which refreshes the Audit trail form
(can't remember if Access can fire events on Table updates - you'll have to look it up)
27th January 2010, 08:04 PM #3
Originally Posted by mrwITch
I shall look into that.
By darbyshire in forum Web Development
Last Post: 17th November 2009, 07:53 PM
By Avalon in forum EduGeek Joomla 1.5 Package
Last Post: 5th November 2009, 01:35 PM
By Quackers in forum Office Software
Last Post: 27th March 2009, 11:08 AM
By tannajay in forum Coding
Last Post: 1st May 2008, 02:23 PM
By Halfmad in forum Web Development
Last Post: 2nd May 2007, 01:16 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)