Drew Wutka
DWUTKA at Marlow.com
Sun Jul 13 12:52:54 CDT 2008
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.