I work in a QA Department and am responsible for thousands of documents. We are going through a System renovation and I'm looking for some help.
I have an access database that lists all the documents produced by my shop that we have just started using.
What we are looking to do is to do is to apply the same to previous created files.
Where I need help with is I need the ability to import the file locations of all the digital files in a directory and then, through the use of a form, apply the new category and naming conventions, then upon saving the form, moving the file to the new location and renaming it to the specified name format.
I hope that makes sense. I can attach a mostly blank database for what I currently have if that will help any.
Thanks!
I have an access database that lists all the documents produced by my shop that we have just started using.
What we are looking to do is to do is to apply the same to previous created files.
Where I need help with is I need the ability to import the file locations of all the digital files in a directory and then, through the use of a form, apply the new category and naming conventions, then upon saving the form, moving the file to the new location and renaming it to the specified name format.
I hope that makes sense. I can attach a mostly blank database for what I currently have if that will help any.
Thanks!