Table to track update dates and times

  • Thread starter Thread starter Linda RQ
  • Start date Start date
L

Linda RQ

Hi Everyone,

Access 2003. I need to know what dates and times my database was updated.
I can go in and look but I forget sometimes. Is there a way to have access
enter a date and time stamp when new records are entered?

Thanks,
Linda
 
Linda,
I use 2 date fields in my table. [DOC] = Date of creation, and DOLE =
Date of last Edit.
Then I add those fields on to my data entry form.
Whenever I create a new record, DOC is updated to that date and time
(Now).
Later if that record is edited, DOLE is updated with the current date and
time.
Using the Form BeforeUpdate event...

Private Sub MyForm_BeforeUpdate(Cancel As Integer)
If IsNull([DOC]) Then
[DOC] = Now()
Else
[DOLE] = Now()
End If
End Sub
--
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."
 
So this keeps track of when each record is updated? I just need to know
when the database was updated. Perhaps this is something to do outsite of
access. The manual way I do it is to look at the database file from
explorer and I jot down the date and time of the last update in an excel
spreadsheet. The problem is, I sometimes forget to do it. I need to make
sure the database is updated 2 times a day.

Thanks,
Linda


Al Campagna said:
Linda,
I use 2 date fields in my table. [DOC] = Date of creation, and DOLE =
Date of last Edit.
Then I add those fields on to my data entry form.
Whenever I create a new record, DOC is updated to that date and time
(Now).
Later if that record is edited, DOLE is updated with the current date
and time.
Using the Form BeforeUpdate event...

Private Sub MyForm_BeforeUpdate(Cancel As Integer)
If IsNull([DOC]) Then
[DOC] = Now()
Else
[DOLE] = Now()
End If
End Sub
--
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."

Linda RQ said:
Hi Everyone,

Access 2003. I need to know what dates and times my database was
updated. I can go in and look but I forget sometimes. Is there a way to
have access enter a date and time stamp when new records are entered?

Thanks,
Linda
Click to expand...
Click to expand...
 
Linda,
Regarding the database, that would be indicated by the .mdb file
modification date itself... outside of Access.
But... that date changes any time the mdb is opened and closed... even
without making any modifications.

Also, what do you consider a "modification". Some change in data in a
particular table, or any change in any table at all.

I would think that it would be possible to create a table called tblDOLM
(DateOfLastModification) within your database, and use the AfterUpdate event
of whatever form you're interested in watching for a modification, and
append a new DOLM datetime value to that table. That would just involve a
Update query against tblDOLM using Now() or Today().
You would have to add that code on every form, that the modification of
sdame constitutes a "modification."
--
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."

Linda RQ said:
So this keeps track of when each record is updated? I just need to know
when the database was updated. Perhaps this is something to do outsite of
access. The manual way I do it is to look at the database file from
explorer and I jot down the date and time of the last update in an excel
spreadsheet. The problem is, I sometimes forget to do it. I need to make
sure the database is updated 2 times a day.

Thanks,
Linda


Al Campagna said:
Linda,
I use 2 date fields in my table. [DOC] = Date of creation, and DOLE =
Date of last Edit.
Then I add those fields on to my data entry form.
Whenever I create a new record, DOC is updated to that date and time
(Now).
Later if that record is edited, DOLE is updated with the current date
and time.
Using the Form BeforeUpdate event...

Private Sub MyForm_BeforeUpdate(Cancel As Integer)
If IsNull([DOC]) Then
[DOC] = Now()
Else
[DOLE] = Now()
End If
End Sub
--
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."

Linda RQ said:
Hi Everyone,

Access 2003. I need to know what dates and times my database was
updated. I can go in and look but I forget sometimes. Is there a way to
have access enter a date and time stamp when new records are entered?

Thanks,
Linda
Click to expand...
Click to expand...
Click to expand...
 
Thanks.


Al Campagna said:
Linda,
Regarding the database, that would be indicated by the .mdb file
modification date itself... outside of Access.
But... that date changes any time the mdb is opened and closed... even
without making any modifications.

Also, what do you consider a "modification". Some change in data in a
particular table, or any change in any table at all.

I would think that it would be possible to create a table called tblDOLM
(DateOfLastModification) within your database, and use the AfterUpdate
event of whatever form you're interested in watching for a modification,
and append a new DOLM datetime value to that table. That would just
involve a Update query against tblDOLM using Now() or Today().
You would have to add that code on every form, that the modification of
sdame constitutes a "modification."
--
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."

Linda RQ said:
So this keeps track of when each record is updated? I just need to know
when the database was updated. Perhaps this is something to do outsite
of access. The manual way I do it is to look at the database file from
explorer and I jot down the date and time of the last update in an excel
spreadsheet. The problem is, I sometimes forget to do it. I need to make
sure the database is updated 2 times a day.

Thanks,
Linda


Al Campagna said:
Linda,
I use 2 date fields in my table. [DOC] = Date of creation, and DOLE =
Date of last Edit.
Then I add those fields on to my data entry form.
Whenever I create a new record, DOC is updated to that date and time
(Now).
Later if that record is edited, DOLE is updated with the current date
and time.
Using the Form BeforeUpdate event...

Private Sub MyForm_BeforeUpdate(Cancel As Integer)
If IsNull([DOC]) Then
[DOC] = Now()
Else
[DOLE] = Now()
End If
End Sub
--
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."

Hi Everyone,

Access 2003. I need to know what dates and times my database was
updated. I can go in and look but I forget sometimes. Is there a way
to have access enter a date and time stamp when new records are
entered?

Thanks,
Linda
Click to expand...
Click to expand...
Click to expand...
 
Back
Top