How do I save the date a record was last modified in Access 2003
in [Tables]
|
Prev: auto number
Next: Blank Field in Form
From: Anne on 28 Dec 2009 04:36 How do I save the date a record was last modified in Access 2003? I know a little about Access databases, and need help with a database I designed. Any comment will be appreciated. Anne
From: Allen Browne on 28 Dec 2009 07:01 Use the BeforeUpdate event of the *form* where the records are edited, e.g.: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.[WhateverYourFieldIsCalled] = Now() End Sub -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Anne" <Anne(a)discussions.microsoft.com> wrote in message news:43E0A676-273A-4E94-8974-D0C20C8B8687(a)microsoft.com... > How do I save the date a record was last modified in Access 2003? > > I know a little about Access databases, and need help with a database I > designed. Any comment will be appreciated. > > Anne
From: Al Campagna on 28 Dec 2009 08:29 Anne, In addition Allen's correct reply... On my website below, I have a sample 97 and 2003 file called Record Statistics They each demostrate how to capture the DOC (Date of Creation) and the DOLE (Date of Last Edit) for each record. They also demostrate how to display the current record number and the current recordset count. If you were looking at the 1st record of a total of 100 records... 1 of 100 of 100 If you were to filter out 10 records... 1 of 90 of 100 -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." If you filtered out "Anne" <Anne(a)discussions.microsoft.com> wrote in message news:43E0A676-273A-4E94-8974-D0C20C8B8687(a)microsoft.com... > How do I save the date a record was last modified in Access 2003? > > I know a little about Access databases, and need help with a database I > designed. Any comment will be appreciated. > > Anne
From: David W. Fenton on 28 Dec 2009 16:31 "Allen Browne" <AllenBrowne(a)SeeSig.Invalid> wrote in news:eBZawV7hKHA.5608(a)TK2MSFTNGP05.phx.gbl: > Use the BeforeUpdate event of the *form* where the records are > edited, e.g.: > Private Sub Form_BeforeUpdate(Cancel As Integer) > Me.[WhateverYourFieldIsCalled] = Now() > End Sub Keep in mind that Now() returns a full date/time value with both date and time. I generally only record the date when records are updated (which is generally sufficient for the purposes in my apps), using Date() instead of Now(). If the time were important, I'd probably put it in a separate column, because it makes querying on date ranges simpler. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
From: David W. Fenton on 28 Dec 2009 16:31
"Al Campagna" <newsgroups(a)comcast.net> wrote in news:uPnQ9G8hKHA.5520(a)TK2MSFTNGP06.phx.gbl: > They each demostrate how to capture the DOC (Date of Creation) > and > the DOLE (Date of Last Edit) for each record. Date of Creation requires only a default value, no? -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |