Pause Date/Time in a repots and in form

[Denver]

I have my database using Access 2003, every friday i make my backups for my
database.

I want to freeze or pause the time and date on reports or on some of my
database forms with time and dates for my backup files. Let say my last
backup was last Friday May 22,2009 Time 16:30:10 I want my database when I
open my backup today the date and time will be same to appear (May 22,2009
16:30:10) in reports or forms . Would it be possible? Can anyone help me on
what code be exactly to write or do I need a module for this? If I need a
module what code do i need to write exactly?

thanks for any help

 

[Douglas J. Steele]

You could use the FileDateTime function to return the Last Modified Date for
the backup file, but note that should the backup file have been opened in
Access for any reason, the datestamp on it will have changed.

If you're doing the backup from within Access, you may be best off storing
the Date/Time of backup in a table.