How to capture time of record edit 2

[tlove161]

I have a field in my table that is called LastEdit. The default value is =Now(). It assigns a date/time when the record is first created.

I want it to capture a new time and replace the old time whenever I edit a field in that record. Right now it does not update the date/time field when I make an edit.

What do I need to do so that I can capture the time when I make an edit to a field in a record? Thanks.

 

[mgolla]

Are you editing directly from the table or are you using a form?


HTH
Mike

Dooobie...Doobie......Dooo

 

[tlove161]

I am using a form to enter the data. Thanks

 

[mgolla]

Ok, since you are using a form you can simply add some code to the form that will set the value of that field to the current date/time after updating any field on the form.

Here is how:

1) Make sure to have a field that uses LastEdit as its control source. Make it hidden if you don't want the users to see it.

2) Add this code to the after update event of the form

Private Sub Form_AfterUpdate()

    Me.LastEdit = Now()

End Sub

Now whenever any field on the record is modified it will automatically change the LastEdit field to Now().

HTH
Mike

Dooobie...Doobie......Dooo

 

[tlove161]

mgolla-

I added the code and stuff to the form. But now when I do make an edit on the form, I can't navigate to the next record and when closing the form I get a warning saying Access can't save the record. Now what?

 

[mgolla]

What happens when you try to navigate?

HTH
Mike

Dooobie...Doobie......Dooo

Beware the penguins

 

[tlove161]

mgolla-

I click the little arrow and nothing happens. I can navigate thru until I make an edit. Thanks

 

[RoyVidar]

Hi!

Try moving it to the forms before update event in stead

Roy-Vidar

 

[mgolla]

Try moving it to the Before Update event:

Private Sub Form_BeforeUpdate(Cancel As Integer)

    Me.LastEdit = Now()

End Sub

HTH
Mike

Dooobie...Doobie......Dooo

Beware the penguins

 

[tlove161]

mgolla and RoyVidar-

Thanks! That fixed it.