Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Date and Time

Discussion in 'Information Technology' started by Newbie to Access, Jul 28, 2006.

Tags:
  1. Newbie to Access

    Newbie to Access
    Expand Collapse
    Guest

    How do you add a field to create a date and time stamp of all edits to a
    record?
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    This is a very common question. Do a search and read the previous posts on
    the topic. Look for the keywords "timestamp" or "audit trail".

    --
    Rick B



    "Newbie to Access" <Newbie to Access@discussions.microsoft.com> wrote in
    message news:6593E791-E31D-4822-BD71-69D528F57AFD@microsoft.com...
    > How do you add a field to create a date and time stamp of all edits to a
    > record?
    >
     
  4. xRoachx

    xRoachx
    Expand Collapse
    Guest

    Open the table in design view. Add a Date/Time field called dtmModDate, or
    whatever you want to call it...

    In the form that is used to edit the record you can add the following in the
    AfterUpdate event:

    dtmModDate = Now()

    "Newbie to Access" wrote:

    > How do you add a field to create a date and time stamp of all edits to a
    > record?
    >
     

Share This Page