Results 1 to 2 of 2

modified Date & Modified BY

  1. #1
    bronson_mech is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    94

    modified Date & Modified BY

    Hello frndz.........



    i need a help i need to Capture Modified By Whom & Modified Date If someone Modified the Existing Details right Now i my database is capturing person who enter the details..........

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,339
    you'd have to provide a field in all your tables (assuming you're tracking only the most recent update) and with any update/add function append the username (which you say you're already capturing) and the date (and/or time) of the event.

    You can capture the date with the date() function
    you can capture the date/time with the now() function

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

Similar Threads

  1. Last Modified date on a form with subforms
    By mindbender in forum Access
    Replies: 14
    Last Post: 05-06-2013, 02:06 PM
  2. Replies: 5
    Last Post: 12-18-2012, 02:37 PM
  3. Front end on shared drive, modified date?!
    By redbull in forum Access
    Replies: 3
    Last Post: 09-13-2012, 10:32 AM
  4. Modified Date
    By PatCollins in forum Import/Export Data
    Replies: 3
    Last Post: 04-24-2012, 01:13 PM
  5. Replies: 1
    Last Post: 09-20-2007, 02:56 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
  •  
Tech Forums: Microsoft Office Forums