Last Modification Date on a field

[Fie]

I need to record the date of last modification on a field.

How can I do this ?

Access 2000

Fie

 

[Arvin Meyer]

I use the Before Update event to update the field used for the timestamp
(aircode):

Sub txtMyField_BeforeUpdate(Cancel As Integer)
Me.txtTimeStamp = Now
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Fie]

So var I've figured it out, however it doesn't save it to table, and doesn't
show it on the form when I refresh the form.

Fie

 

[Arvin Meyer]

You need to add the timestamp field to the table (datatype date/time) and a
textbox to the form bound to that field. In this case I named that textbox
txtTimeStamp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Fie]

This doesn't work, any ideas ??

Fie

I use the Before Update event to update the field used for the timestamp
(aircode):

Sub txtMyField_BeforeUpdate(Cancel As Integer)
Me.txtTimeStamp = Now
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Van T. Dinh]

I hope you are aware that this only works if you perform edit on a Form???

 

[Fie]

Yes I am

I hope you are aware that this only works if you perform edit on a Form???

 

[Van T. Dinh]

Describe you Table / your Form and how you implement the code.

You are not giving much info. for anyone to guess what you did wrongly as
Arvin's suggestion definitely works.

 

[Fie]

The date that needs monitoring of the last modification is being filled by
the input date function in the date picker I found on
http://www.mvps.org/access/forms/frm0057.htm
My best guess it that it has something to do with that ...

code on click event calander button :
Me.txtEndDate.Value = InputDate("Select End Date")

code in before update on the monitored date
is as Arvin suggested

Hope this helps you more
thanks

Fie