My boss has given me a scanning project where I am scanning many pages worth
of information.  However, each page needs to be its own seperate scan.
After doing a giant batch scan, I am saving each scan under their
identifiable ID number.  However, I also need to add the general ID number
to the file name.

So, I have created a query (that each scan is based off of in the first
place) that shows the name of each scan file as named during the seperation
process.  But, I am needing to change that name to the new name.  In the
query there is a field of OldName and NewName.  Is there a script that I can
program into a button that will allow the name to change from the old to the
new?

One batch scan can yield 20-30 individual scans.  Do the renaming by hand
would be a pain.  Not to mention massive carpal tunnel.

Is there anything that can be used to assist in this.

Jason Lopez