using access to rename image files

  • Thread starter Thread starter sarath26uk via AccessMonster.com
  • Start date Start date
S

sarath26uk via AccessMonster.com

I have around 1500 products with pictures and they both share the same name.
The are associated with each other using this product code.Now i have to
update the codes of these 1500 products, i want to rename the pictures too at
the same time. It will be hectic to rename them one after the one, is it
possible to automate them?
 
sarath26uk said:
I have around 1500 products with pictures and they both share the same name.
The are associated with each other using this product code.Now i have to
update the codes of these 1500 products, i want to rename the pictures too at
the same time. It will be hectic to rename them one after the one, is it
possible to automate them?
Click to expand...


If you have a reliable way to translate from the old name to
the new name, then use a sub procedure with the Name
statement to rename the files. The Dir function can be used
to find all the files in a folder if that's what your
arrangement looks like.
 
Yes in a table i have the old codes and the new codes , can you explain to me
little bit more how to go ahead and do this. all the images are in old codes
now, in a folder, i need to rename them with the new codes...
 
sarath26uk said:
Yes in a table i have the old codes and the new codes , can you explain to me
little bit more how to go ahead and do this. all the images are in old codes
now, in a folder, i need to rename them with the new codes...
Click to expand...


I don't understand what you need help with. Just loop
through the records in the table (using a recordset) and use
the Name statement to rename the files.

Be sure to back up the folder with the files in case
something goes wrong.
 
Back
Top