Time stamp for modifying a record

#1 (**permalink**) 28-Jul-2006, 08:21 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11436-time-stamp-for-modifying-a-record.html

*

#2 (**permalink**) 28-Jul-2006, 08:21 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11436

--
Rick B

"ibeetb" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11436
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
>

#3 (**permalink**) 28-Jul-2006, 08:21 AM

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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11436
"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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11436
>
> Thanks
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:21 AM

yet another reason that MDB is obsolete.

use Access Data Projects and SQL Server.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11436

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11436
> >
> > Thanks
> >
> >
> >