L
Lee T.
Ms. Annie,
If you are on a form and every time someone uses the
form and modifies the data in anyway, you can capture that
as well. On the form's text box (or whatever you are
editing) you can set the after update to change the
CHANGE_DATE field on that record. Here is what I do...
Private Sub <your textbox or ??? here >()
Me!ModDate = Date ' where ModDate is the filed in
the database I used for capture
End Sub
I am only interested in the date, not in the who or the
time. If you want the time, just use "=now" instead.
If you are using a bulk update via a query, you will need
to make sure that the CHANGEDATE or MODDATE or ??? is set
as well. I also have an ENTRYDATE which on the table has
it's default value set to DATE so that when a new record
is added, it will have the DATE (or NOW if you wish)
DATE/TIME stamp on it.
Lee T.
If you are on a form and every time someone uses the
form and modifies the data in anyway, you can capture that
as well. On the form's text box (or whatever you are
editing) you can set the after update to change the
CHANGE_DATE field on that record. Here is what I do...
Private Sub <your textbox or ??? here >()
Me!ModDate = Date ' where ModDate is the filed in
the database I used for capture
End Sub
I am only interested in the date, not in the who or the
time. If you want the time, just use "=now" instead.
If you are using a bulk update via a query, you will need
to make sure that the CHANGEDATE or MODDATE or ??? is set
as well. I also have an ENTRYDATE which on the table has
it's default value set to DATE so that when a new record
is added, it will have the DATE (or NOW if you wish)
DATE/TIME stamp on it.
Lee T.