Welcome to SPN

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

Sign Up Now!

Time stamp for modifying a record

Discussion in 'Information Technology' started by ibeetb, Jul 28, 2006.

  1. ibeetb

    ibeetb
    Expand Collapse
    Guest

    I know of a timestamp for adding a new record to a table but is there some
    way I can add a timestamp each time I modifty a record? Either in the table
    design or in VBA would be fine

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    World Uganda marks 100 years of Sikh presence by issuing 4 postage stamps Breaking News Feb 11, 2014
    India Sibal releases postage stamp on Hari Singh Nalwa Breaking News May 1, 2013
    Sikh Foundation An Interview with Master Sikh Stamp Collector: Paramjeet Singh Sikh Organisations Jul 24, 2011
    India Stamp out honour killings ruthlessly: Supreme Court Breaking News Apr 19, 2011
    Sikh Foundation A Sikh Stamp that was Cancelled (Sikh Foundation) Sikh Organisations Apr 5, 2011

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Sure, just add a field and then build code into your forms that updates that
    field before a change is written. I think it is the "before update" event
    that you want.

    --
    Rick B



    "ibeetb" <tb20169@aol.com> wrote in message
    news:%237STCC$jGHA.3572@TK2MSFTNGP04.phx.gbl...
    >I know of a timestamp for adding a new record to a table but is there some
    >way I can add a timestamp each time I modifty a record? Either in the table
    >design or in VBA would be fine
    >
    > Thanks
    >
     
  4. schasteen

    schasteen
    Expand Collapse
    Guest

    The only way I know of would be to create a form to modify your data
    (perfered method of editing data instead of directly working with the table),
    then in the forms before update event add
    Me![YourFieldName] = Now


    "ibeetb" wrote:

    > I know of a timestamp for adding a new record to a table but is there some
    > way I can add a timestamp each time I modifty a record? Either in the table
    > design or in VBA would be fine
    >
    > Thanks
    >
    >
    >
     
  5. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    yet another reason that MDB is obsolete.

    use Access Data Projects and SQL Server.

    it is 100 times better in the short term and the long term.

    your users will thank you


    schasteen wrote:
    > The only way I know of would be to create a form to modify your data
    > (perfered method of editing data instead of directly working with the table),
    > then in the forms before update event add
    > Me![YourFieldName] = Now
    >
    >
    > "ibeetb" wrote:
    >
    > > I know of a timestamp for adding a new record to a table but is there some
    > > way I can add a timestamp each time I modifty a record? Either in the table
    > > design or in VBA would be fine
    > >
    > > Thanks
    > >
    > >
    > >
     

Share This Page