giswest
asked on
Copy file based on check box in MS Access Table
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awsome response and solution, as usual! I had not even considered filtering the records when defining the recordset. I'll definitely store this one in memory banks for future reference.
Have a good weekend.