Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    > >
    > >
    > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page