Database revision date

[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

 

[Duane Hookom]

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.

 

[Robert Wagner]

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