Database revision date

  • Thread starter Thread starter Robert Wagner
  • Start date Start date
R

Robert Wagner

Working in Access 97, I want to add a textbox to a report that shows the
latest revision date for the database (including addition of new data).
I assume that I use the FileDateTime function. But what do I use for
the argument?

TIA >>> Robert
 
I would not use the file date/time for that. You would need to create a more
comprehensive specification and then program this into your forms and code.
 
Never mind, I got it. In the code for the section (footer) where I
wanted it, it's

txtFileDate=(FileDateTime(CurrentDb().Name))

Oddly, I couldn't just enter

=(FileDateTime(CurrentDb().Name)) as the txtFileDate's Control Source.

I had to set it in code.

Robert
 
Back
Top