View Single Post
  #3  
Old December 28th, 2009, 01:29 PM posted to microsoft.public.access.tablesdbdesign
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default How do I save the date a record was last modified in Access 2003

Anne,
In addition Allen's correct reply...
On my website below, I have a sample 97 and 2003 file called
Record Statistics
They each demostrate how to capture the DOC (Date of Creation) and
the DOLE (Date of Last Edit) for each record.

They also demostrate how to display the current record number and the
current recordset count. If you were looking at the 1st record of a total
of
100 records...
1 of 100 of 100
If you were to filter out 10 records...
1 of 90 of 100
--
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."

If you filtered out
"Anne" wrote in message
...
How do I save the date a record was last modified in Access 2003?

I know a little about Access databases, and need help with a database I
designed. Any comment will be appreciated.

Anne