Access 2010 - undefined filedatetime function error 3085

Question

I just upgraded from Access 2003 to Access 2010.  When using the FileDateTime function, I receive an error message "undefined function 'FileDateTime' in expression".  I use this function to get the last modified date of an external text file.

I found no missing references.

Does anyone have a solution or workaround?

Answer 1

In recent versions of Access, you can't use FileDateTime directly in an expression.

You could create a custom function to act as "wrapper":

Function GetFileDateTime(FileName As String) As Date

    GetFileDateTime = FileDateTime(FileName)

End Function

and use it like this in an expression:

=GetFileDateTime("C:\Access\MyDatabase.mdb")

Alternatively, you can fill a text box using code, for example:

Me.txtFileDate =  FileDateTime("C:\Access\MyDatabase.mdb")

Answer 2

You could use this version:

Function GetFileDateTime(FileName As String) As Variant

    On Error GoTo ErrHandler

    GetFileDateTime = FileDateTime(FileName)

    Exit Function

ErrHandler:

    ' Something went wrong, return Null

    GetFileDateTime = Null

End Function

Answer 3

Perfect!!  Thank you.

Answer 4

The code works great as long as there is a file to be found.  

However, I get a 'run-time error 53 file not found' when the target file does not exist.   Could you suggest code to exit the function and/or return to the field a null value?  Thank you.