M Milon Oct 15, 2007 #1 How I can take Pictures in MS-Access and save with file name, date and hour? thanks.
G Guest Oct 15, 2007 #2 I'm assuming you wish to extract the filename and creation date & time from a list of file in an access database? If so, try FileDateTime() or Dim oFSO As Object Dim oF As Object Set oFSO = CreateObject("Scripting.FileSystemObject") Set oF = oFSO.GetFile("D:\My folder\File.TXT") Debug.Print F.DateCreated Set oF = Nothing Set oFSO = Nothing You can also find VB example that you could use/modify at http://vbnet.mvps.org/index.html?code/fileapi/filedatetime.htm
I'm assuming you wish to extract the filename and creation date & time from a list of file in an access database? If so, try FileDateTime() or Dim oFSO As Object Dim oF As Object Set oFSO = CreateObject("Scripting.FileSystemObject") Set oF = oFSO.GetFile("D:\My folder\File.TXT") Debug.Print F.DateCreated Set oF = Nothing Set oFSO = Nothing You can also find VB example that you could use/modify at http://vbnet.mvps.org/index.html?code/fileapi/filedatetime.htm