File Date Function

[Jackie]

Is there an Access or VB function that shows the date of a file (external to the Access .mdb)? I would like to capture the date of a file that was downloaded from another system and imported into Access.

 

[DougP]

Not sure I follow exactly<br>
Are you wanting the know the Date of an Access file or some other file?<br>
Did you look at the &quot;Dir&quot; function?<br>
The file was imported into Access and is a table now use the &quot;TableDef&quot; function. <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[Jackie]

I'm wanting to know the date of a .txt file that is stored on a server or harddrive.

 

[Lehtoant]

<br>
Use function:<br>
FileDateTime(&quot;PathAndFilename&quot<br>
<br>
You can use this in VBA code or directly as Control Source of a form/report field. <br>
<br>
Good luck,<br>
Al