Display File Date Modified

  • Thread starter Thread starter Marv
  • Start date Start date
M

Marv

Hi,

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

Thanks for your help.

Marv Trott
 
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)
 
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
 
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)


Marv said:
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

Marv said:
Hi,

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

Thanks for your help.

Marv Trott
Click to expand...
Click to expand...
 
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
Douglas J. Steele said:
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)


Marv said:
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

Marv said:
Hi,

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

Thanks for your help.

Marv Trott
Click to expand...
Click to expand...
Click to expand...
 
Back
Top