[AccessD] File Date Time

Rocky Smolin rockysmolin at bchacc.com
Wed Jul 26 20:12:58 CDT 2017


Nice!  I managed to wrestle the info out using FSO. 

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Wednesday, July 26, 2017 1:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] File Date Time

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-inf
ormation-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
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list