Get Last modified date on folder through Access VBA 1

[Tadynn]

Hi all,

Does anyone know how to create a form within access 2k that will show me the last modified date on a folder?

Let's say that my folder is called: c:\Testing

Thanks in advance,

Tadynn

 

[PHV]

Have you tried something like this ?
FileDateTime("c:\Testing")

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Tadynn]

Hi PHV

Excuse my arrogance, I've written it in like this and obviously it's wrong.

Private Sub Form_Load()
Me.Var.Value = FileDateTime("c:\Testing\")

End Sub

var is the name of my text box that I would like to display the timestamp in.

Can you please tell me the correct way to use the filedatetime function?

Rgrds, Tadynn

 

[PHV]

Just like my previous post, get rid of the trailing backslash in the folder pathname.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244