Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Capturing a date when a record has been modified

    I'm new to programming in Access. We have a database that multiple users can access on a shared drive. I would like to capture for one of the files the date in which a record was last modified. I have quite a few forms and querys that allow users to change certain information in each record. Is there some global code I can use to accomplish this?



    Bruce

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    I'm no expert, but would this work? I am assuming that you have a date/time field in your table to track changes that I am calling last_modified.

    Private Sub Form_BeforeUpdate(Cancel As Integer)
    Me!last_modified = Now()
    End Sub

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

Similar Threads

  1. Deleting Record Contents, not complete record...
    By Charles Waters in forum Access
    Replies: 2
    Last Post: 06-24-2008, 12:00 PM
  2. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM
  3. Replies: 1
    Last Post: 12-09-2005, 10:29 PM

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