Copy file based on check box in MS Access Table
Posted on 2012-04-13
I need to copy files from Folder A to Folder B, but I only want to copy files based on whether or not a specific attribute exists in a table. I have a table (Table 1) that contains two attribute fields: "File Name" and "Replace" (the "Replace" field is a Yes/No (check-box) field). I would like to loop through the records in the table, and copy each file listed in the table, (based on on the file name), where the "Replace" attribute is checked.
I don't know if this makes any sense, or if it's even possible, but I figure that I doesn't hurt to ask.
Thank you in advance.