+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    acrobson's Avatar
    Join Date
    May 2007
    Location
    Tyne & Wear
    Posts
    519
    Thank Post
    5
    Thanked 6 Times in 6 Posts
    Rep Power
    17

    VBA Code to copy all form updates to one form

    Afternoon,

    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!

  2. #2

    Join Date
    Feb 2009
    Posts
    45
    Thank Post
    1
    Thanked 5 Times in 5 Posts
    Rep Power
    11
    Quote Originally Posted by acrobson View Post
    Afternoon,

    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!

    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)

  3. #3
    acrobson's Avatar
    Join Date
    May 2007
    Location
    Tyne & Wear
    Posts
    519
    Thank Post
    5
    Thanked 6 Times in 6 Posts
    Rep Power
    17
    Quote Originally Posted by mrwITch View Post
    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)
    Okay, cheers!

    I shall look into that.

SHARE:
+ Post New Thread

Similar Threads

  1. Email Form
    By darbyshire in forum Web Development
    Replies: 4
    Last Post: 17th November 2009, 06:53 PM
  2. contact us form
    By Avalon in forum EduGeek Joomla 1.5 Package
    Replies: 4
    Last Post: 5th November 2009, 12:35 PM
  3. Application form
    By Quackers in forum Office Software
    Replies: 3
    Last Post: 27th March 2009, 10:08 AM
  4. Feedback form
    By tannajay in forum Coding
    Replies: 7
    Last Post: 1st May 2008, 01:23 PM
  5. Web form
    By Halfmad in forum Web Development
    Replies: 12
    Last Post: 2nd May 2007, 12:16 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •