Reading Date

[Martin Wilson]

Hello,

I would like to read the date and time a file on the
networks was created and print it out on an Access
report. Can anyone assist me with this task?

Thanks,

Martin Wilson

 

[Douglas J. Steele]

Created, or last modified? Last Modified, use the built-in FileDateTime
function:

FileDateTime("C:\My Files\File.abc")

If you really want the Created date, even if it's subsequently been
modified, your best bet is to use API calls. Take a look at what Randy Birch
has at http://vbnet.mvps.org/code/fileapi/filedatetime.htm and see whether
you can use it. (Obligatory warning: Randy's site is aimed at VB
programmers. Due to differences in the forms models between Access and VB,
the code samples sometimes don't always transfer across seamlessly. In this
particular case, though, I don't think there should be any issues.)