title: how can I display a last modified time on ms access form
body: <p>I have an MS Access (2010) form with a bunch of linked tabled to XLSX files (both stored locally). On the main form is a built in auto update feature which essentially copies any new versions of the front end and XLSX files from a central server locally (auto generated daily). Is it possible to add the date modified/last write time stamp from the local XLSX file on the main form?</p>
  
  <p>I've tried:</p>
  
  <ol>
  <li><p><code>="Last Modified: " &amp; DLookUp("[DateUpdate]","MSysObjects","[Name] = '***tablename***'")</code> as a control source however this doesn't give the data i need.</p></li>
  <li><p>I can get the desired result in powershell by the command <code>(Get-ItemProperty -Path $source).LastWriteTime.tostring("dd MMM yyyy HH:mm")</code> ,though I have no idea how I can tie in the result into an access form. Any ideas?</p></li>
  </ol>
  
  <p>Noteworthy: <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/ms724926%28v=vs.85%29.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/windows/desktop/ms724926%28v=vs.85%29.aspx</a> (C++ is foreign to me and not even sure it applies to this question)</p>