Results 1 to 3 of 3
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672

    VBA to check if Data Has Changed


    Is there a way to have VBA check the table to see if the data has changed? For example, if the table today contains
    First Name Last Name ItemPurchased WarrantyPurchased SalePrice
    Mike Mike Oven No 400
    Jay Jay Freezer Yes 2200
    Rich Rich Hair Dryer No 60

    But tomorrow the table reads:
    First Name Last Name ItemPurchased WarrantyPurchased SalePrice
    Mike Mike Oven No 400
    Jay Jay Freezer Yes 2200
    Rich Rich Hair Dryer Yes 120

    Could you programmatically detect that change? There is no form, so I can't use an afterupdate() Event which is what I was hoping for.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Would need to have audit log table and code. Here is one example: http://allenbrowne.com/AppAudit.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672
    Quote Originally Posted by June7 View Post
    Would need to have audit log table and code. Here is one example: http://allenbrowne.com/AppAudit.html
    Looks like this will do! As always thanks for the help @June7

Please reply to this thread with any new information or opinions.

Similar Threads

  1. The Data Has Been Changed Error
    By sdbsadmin in forum SQL Server
    Replies: 2
    Last Post: 07-12-2013, 08:16 AM
  2. Runtime error 7878 Data has been changed
    By jle0003 in forum Forms
    Replies: 2
    Last Post: 10-22-2012, 10:06 PM
  3. text box to see changed data for a given field
    By fabiobarreto10 in forum Forms
    Replies: 12
    Last Post: 01-12-2012, 04:26 PM
  4. Find out changed data
    By Papote in forum Programming
    Replies: 1
    Last Post: 04-27-2009, 08:19 PM
  5. Replies: 4
    Last Post: 04-01-2009, 11:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums