Importing Files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello - I need help!

I have an access application in which I am importing various files from
various departments. Usually I manually check the created or modified dates
on the imcoming files. However, I was in a hurry one day and didn't check
the dates and one of the files was from the day before. This caused me a lot
of problems.

Is there a file property that I can check for to see if the modified file
date is today's date? If there is how do I code to stop the imports. I know
this is a "rookie" mistake but I am a rookie at this stuff - my first
application - please help.
 
VBA has a built in FileDateTime function that returns the last modified
date/time.

The syntax to use it is FileDateTime(pathtofile), as in
FileDateTime("G:\Folder\File.ext")
 
Douglas J. Steele said:
VBA has a built in FileDateTime function that returns the last modified
date/time.

The syntax to use it is FileDateTime(pathtofile), as in
FileDateTime("G:\Folder\File.ext")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






Thank you - this will help a lot
Click to expand...
 
Back
Top