I got the VBA script that I wrote to work completely well, with the help of Merle and George (THANK YOU!).
Now I have to try to figure out how to get rid of the extra field ("Transferred") in my database and add some error handling in the code. Because once it goes through it puts a check...