Home All Groups Group Topic Archive Search About
Author
15 Oct 2007 3:47 AM
Milon
How I can take Pictures in MS-Access and save with file name, date and hour?
thanks.

Author
15 Oct 2007 11:41 AM
Daniel
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
--
Hope this helps,

Daniel P


Show quote
"Milon" wrote:

> How I can take Pictures in MS-Access and save with file name, date and hour?
> thanks.
>
>
>

AddThis Social Bookmark Button