Display File Date Modified

[Marv]

Hi,

How do I display the File Date Modified of the mdb file in a Report.

Thanks for your help.

Marv Trott

 

[Douglas J. Steele]

FileDateTime(CurrentDb.Name)

If you want a text box with that in it, you can set the text box's
ControlSource to =FileDateTime(CurrentDb.Name). Alternatively, you can set
the ControlSource to something like ="The file was last modified " &
FileDateTime(CurrentDb.Name)

 

[Marv]

Hi,

To clarify my question:

When I use this expresion [=CurrentProject.FullName] in a text Box how can I
also show the Date the file was last modified?

This is the information that is displayed in the Database Properties Window

Thanks,

Marv

 

[Douglas J. Steele]

Was there something wrong with the answer I gave you six hours before you
posted this follow up?

Use the VBA FileDateTime function.

=FileDateTime(CurrentProject.FullName)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi,

To clarify my question:

When I use this expresion [=CurrentProject.FullName] in a text Box how can
I also show the Date the file was last modified?

This is the information that is displayed in the Database Properties
Window

Thanks,

Marv

Hi,

How do I display the File Date Modified of the mdb file in a Report.

Thanks for your help.

Marv Trott

 

[Marv]

Doug,

Your answer was correct. I'm sorry about the second post which I made before
I saw your answer.

Thanks for your help.

Marv

Was there something wrong with the answer I gave you six hours before you
posted this follow up?

Use the VBA FileDateTime function.

=FileDateTime(CurrentProject.FullName)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi,

To clarify my question:

When I use this expresion [=CurrentProject.FullName] in a text Box how
can I also show the Date the file was last modified?

This is the information that is displayed in the Database Properties
Window

Thanks,

Marv

Hi,

How do I display the File Date Modified of the mdb file in a Report.

Thanks for your help.

Marv Trott