[AccessD] File Date Time

[Stuart McLachlan]

Do you want to know WHERE it was taken as well?.

Here's Access code which will let you read all of the EXIF data in a jpeg, including creation 
date, camera details and GPS co-ordinates if the camera has that info available :)

http://www.everythingaccess.com/tutorials.asp?ID=Accessing-detailed-file-information-provid
ed-by-the-Operating-System

He uses a really clever technique to access the data.  In effect he creates a native code DLL 
in memory from a text string!

' * The purpose of this module is to allow easy access to the detailed file   *
' * properties that are exposed by the Operating System (2000/XP and above),  *
' * commonly referred to as "shell property handlers".                        *
' *                                                                           *
' * For example, using these properties you can determine the duration length *
' * of an audio file (MP3, etc), or extended data like JPEG EXIF properties.  *
' *                                                                           *
' * This module is a Virtual-COM module that creates native-code x86 COM      *
' * objects in memory.  This is the equivalent of having a small seperate     *
' * DLL, but without adding any extra dependencies to your project.           *



On 26 Jul 2017 at 12:03, Rocky Smolin wrote:

> Well I found the solution in file system object. The 12th property is
> the date the picture was taken, not the date it was created in the
> folder.  So then I had to manipulate that because of the unprintable
> characters in it.  
> 
> Any short story long, I've got the pictures in chronological sequence
> of date TAKEN and renamed them all with a sequence number so that the
> file names sort in date picture TAKEN.
> 
> And I have a brand new skill I'll probably never use again. :)
> 
> R
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Dan Waters Sent: Wednesday, July 26, 2017 11:22 AM To: Access
> Developers discussion and problem solving Subject: Re: [AccessD] File
> Date Time
> 
> In the folder that holds these picture files, on the top row of column
> headers, right-click on Date Modified and select Date Created.  Check
> to see if those dates are different to begin with.  If not then
> getting that date in code won't help anyway.
> 
> IIRC there is something about Create Date of a file that causes it to
> change when you'd expect that it wouldn't.
> 
> Dan
> 
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
> 
> From: Rocky Smolin<mailto:rockysmolin at bchacc.com>
> Sent: Wednesday, July 26, 2017 13:07
> To: 'Access Developers discussion and problem
> solving'<mailto:accessd at databaseadvisors.com>; 'Off
> Topic'<mailto:dba-ot at databaseadvisors.com>
> Subject: [AccessD] File Date Time
> 
> Dear List:
> 
> 
> 
> Still working with renaming a folder full of pictures.  As Stuart
> suggested I'm creating a table of photos I the folder with names and
> date.  But I'm using
> 
> 
> 
>   strFileName = Dir$(strFolder & strFileSpec)
> 
>   While strFileName <> ""
> 
>        rs.AddNew
> 
>        rs!fldPhotosFileName = strFileName
> 
>        rs!fldPhotosFileDate = FileDateTime(strFolder & strFileName)
> 
>        rs.Update
> 
>        lngCount = lngCount + 1
> 
>       strFileName = Dir$
> 
>   Wend
> 
>   rs.Close
> 
>   Set rs = Nothing
> 
> 
> 
> but FileDateTime as described in the msdn page is the tie the file was
> created or last modified.  I need the creation date as some of them
> have been modified but I need to rename them in create date sequence.
> 
> 
> 
> Is there a way to get just Create Date?
> 
> 
> 
> MTIA
> 
> 
> 
> Rocky
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>