?
Solved

How do you change the File/Date timestamp on a file using VBA?

Posted on 2007-08-10
1
Medium Priority
?
286 Views
Last Modified: 2013-11-27
My VBA code is retrieving imaages from a digital camera.
When the images get copied, the files have todays date/time.
I need them to be the date they were taken which I happen to know.

How do you change the File/Date timestamp on a file?
0
Comment
Question by:aesmike
1 Comment
 
LVL 19

Accepted Solution

by:
Limbeck earned 2000 total points
ID: 19668383
hi, please look at this page for an explanation/examples. it is written for excel but will work in msaccess as well.

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question