[AccessD] File Attributes

Couldn't agree more.  I rarely use other people's code like that, but
that module was so well put together, there was just no point in
recreating it in my own style!

In case anyone is interested, here's a link to the site that has the
code:

http://www.cpearson.com/excel/FileTimes.htm

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lembit Soobik
Sent: Sunday, July 13, 2008 6:39 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] File Attributes

Thank you, Drew,
that's a great piece of code with comments that explain everything. I
didnt 
know that file date/times are stored in GMT, but displayed in local
time.

Lembit

----- Original Message ----- 
From: "Drew Wutka" <DWUTKA at marlow.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Sunday, July 13, 2008 2:24 AM
Subject: Re: [AccessD] File Attributes


>I sent you a solution off list.
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lembit
Soobik
> Sent: Saturday, July 12, 2008 3:40 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] File Attributes
>
> Hi all,
> In Access 2002 I want to modify the date/time created/modified of a
lot
> of
> files.
> There are properties like .DateLastModified in the
> Scripting.FileSystemObject.
> However they are all read-only.
> Is there a way how to modify these dates in Access 2002?
>
> I need this for changing the time of digital photos by 1 or 2 hours
due
> to
> timezone changes.
>
> thank you
> Lembit
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> The information contained in this transmission is intended only for
the 
> person or entity to which it is addressed and may contain II-VI 
> Proprietary and/or II-VI Business Sensitive material. If you are not
the 
> intended recipient, please contact the sender immediately and destroy
the 
> material in its entirety, whether electronic or hard copy. You are 
> notified that any review, retransmission, copying, disclosure, 
> dissemination, or other use of, or taking of any action in reliance
upon 
> this information by persons or entities other than the intended
recipient 
> is prohibited.
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 270.4.10/1549 - Release Date: 
> 12.07.2008 16:31
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.