Re: A Field To Record Exactly When A Record Was Updated

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Rick (anonymous_at_discussions.microsoft.com)
Date: 04/15/04 

Date: Thu, 15 Apr 2004 14:59:08 -0500

Do you have a field in your table named "timestamp"?

Rick

"Steve" <anonymous@discussions.microsoft.com> wrote in message
news:1d21201c42322$feda34f0$a301280a@phx.gbl...
I've just tried to modify the event procedure and it
does not work - I get a compile error on Timestamp. I
think the problem is replacing "Me with somekind of
absolute reference.

>-----Original Message-----
>I use the following in my forms...
>
>Private Sub Form_BeforeUpdate(Cancel As Integer)
> If Me.Dirty Then
> Me.Timestamp = Format(CurrentUser, ">") & " " & Date
& " " & Time
> End If
>End Sub
>
>
>
>
>"Steve" <anonymous@discussions.microsoft.com> wrote in
message
>news:1a50f01c42319$b5e784e0$a601280a@phx.gbl...
>I am developing an application for a group of user's, and
>there is a requirement that a field be included in every
>table, that is able to record exactly when each record is
>updated or created (New Record)- this field might be
>called [UpdatedOn] for example. Question, how am I able
>to acheive this goal and the answer must be able to be
>used in several forms in the same database. I have tried
>using - Me.UpdatedOn = Now() - but this only seems to
>work on one form in database, does anybody know of a way
>to modify the event procedure to reference other forms in
>the same database ie Forms!frmPrimarySubForm[UpdatedOn =
>Now() or something similar. Thank you all for your time
>and effort.
>
>
>
>.
>

Relevant Pages