FileDateTime

[BrianK]

I would like to establish a Date/Time text box in my form
that references an Excel file. It suggested to use the
FileDateTime function. I created a text box and put this
command FileDateTime(pathname\file.xls) into the Control
Source but Access will not accept this. Any suggestions?

 

[Wayne Morgan]

I just gave it a try and it worked fine. The following should be in the
Control Source of the textbox

=FileDateTime("pathname\file.xls")

If that doesn't work, try it in the Immediate Window (Ctrl+G) and see what
happens

?FileDateTime("pathname\file.xls")

If it still doesn't work, then you probably have a References problem. Check
this for more information.

http://members.iinet.net.au/~allenbrowne/ser-38.html