I have a hyperlink field in a table. I want to be able to COPY the referenced hyperlinked file to a NEW Folder, and leave the old folder and file intact. I can update the hyperlink reference in the table once it is moved to a new folder. This is not a one time move. It will occur many times per day. I have a field in my current table that indicates whether the item has been moved already.
I would like to run a query that indicates those items that have not been copied to the new folder, then run some code that would allow the files to be copied all at once. They are all moving to a single folder, so there is no guesswork:
Any help to make this as easy as possible would be appreciated