RE: FileDateTime function error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The function does exist in 2007. It is one of two things. It is either a
VBA reference problem or your syntax is incorrect.

I just did a test using 2007. Here is the results:

?filedatetime("c:\access\bagoftricks\tricks.mdb")
3/30/2009 11:21:30 AM

--
Dave Hargis, Microsoft Access MVP


"Jim" wrote:

I found the syntax below from a 2006 post but I'm getting an Undefined
Function error when I try to use it in Access 2007. Can someone tell me what
reference I'm missing? I don't see anything marked "missing" in my
references. Thanks!

The function FileDateTime() will return when the file was created or last
modified.

Syntax : FileDateTime("File Path")


http://www.microsoft.com/office/community/en-us/default.mspx?query=filedatetime&dg=microsoft.public.access.externaldata&cat=en-us-office-access&lang=en&cr=US&pt=327f343d-f0d6-4e07-aa53-9656edb98ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us
.

Relevant Pages

  • Re: Track_No in sub form
    ... Evi's response would be correct. ... Reference, so Access doesn't know what an NZ function is. ... instructuions from Evi or Doug to locate the missing reference. ... Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • Re: How to set default date format in Access 07
    ... If the code compiles then there is probably no problem at all in unchecking/claering the missing reference. ... It the code does not compile, then you either have to track down the missing library or locate the code that is broken. ... Doug Steele, Microsoft Access MVP ... Do I put the =Dateas the default value in the control on the ...
    (microsoft.public.access.gettingstarted)
  • Re: import multiple text files into Access 2003(different file names)
    ... I can export this reference from the 97 computer and register it in the ... Problems like this are often caused by a missing reference in the VBA ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • Re: Named regexp variables, an extension proposal.
    ... John Machin wrote: ... reference the literal contents of groups appearing after the variable ... Regex syntax is over-rich already. ... complete parser for Verilog, I want to take an easier 'good enough' ...
    (comp.lang.python)
  • Re: Interesting article: In the Beginning: An RDBMS history
    ... First a frame of reference. ... Human Communication. ... syntax: grammars, forms, interview-style talks. ... To me to book "Pragmatics of Human Communication", ...
    (comp.databases.theory)