By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Rename files from VBA based on a query - v2

P: 1
https://bytes.com/topic/access/answe...ba-based-query

Can you please post the final results of the above thread.
I have similar problems in trying to take a lot of JPG files and rename them into another folder based on the query.

I have employees photoID that is currently saved according to their full name, I would like to rename the photo with their employee number. They are all JPG files.

Please help.

I tried the above link and this does not work. Please post the final results of how they got this to work.
Apr 30 '17 #1
Share this Question
Share on Google+
2 Replies


weaknessforcats
Expert Mod 5K+
P: 9,197
Just use the system rename() function.

Is there something complex here I don't see?
Apr 30 '17 #2

weaknessforcats
Expert Mod 5K+
P: 9,197
BTW: If you do this on a Windows machine, the directory slashes are
\ instead of / as on Linux. The \ is the escape sequence control in C so be sure to use \\ in your code. The \\ resolves to \ which is exactly correct for Windows.
Apr 30 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.