[AccessD] File Date Time

Bill Benson bensonforums at gmail.com
Thu Jul 27 02:24:49 CDT 2017


Does this date get retained when making a round trip to the cloud? I have
found many of my image archives screwed with through this process.

On Wed, Jul 26, 2017 at 3:03 PM, Rocky Smolin <rockysmolin at bchacc.com>
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
>


More information about the AccessD mailing list