Results 1 to 5 of 5
  1. #1
    Bdowns is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    28

    Add Date/Time created as well as Date/Time last Modified

    I made a macro that records the date and time that each record was last modified when data is entered using a form. I also want access to record keep the original date and time when the record was created. Any ideas on how to do this?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Make the default value of a "DateTimeAdded" field Now().
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You will need an additional field in your table. You would set the default value for that field to the current date/time using the now() function. You would not include a control on any of your forms that are bound to that field.

    oops, I see Paul beat me again.

  4. #4
    Bdowns is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    28
    Thank you both pbaldy and jzwp11!

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problemo!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Breaking out the time from date/time
    By detaylor1242 in forum Programming
    Replies: 1
    Last Post: 02-19-2013, 08:10 PM
  2. Replies: 5
    Last Post: 12-18-2012, 02:37 PM
  3. Replies: 12
    Last Post: 02-22-2011, 03:39 PM
  4. View Created date and time for key in Registry
    By startop10 in forum Programming
    Replies: 2
    Last Post: 01-21-2011, 01:52 PM
  5. Replies: 6
    Last Post: 01-04-2011, 05:43 PM

Tags for this Thread

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