I am going to need help with this one for sure. Short version is we have two job folders at the office, one for completed jobs, and one for active ones. I currently am tracking them via manual entry, but ideally once a day, id like to have access check to see if one job moved from active to completed and update the link in the table. The jobs are also their own folder.
So Active_Folder -> Job1_Folder -> Job1_Data
As an example
How I go about doing this I am unsure, maybe using Dir() of each job folder to see if it exists and then if they dont exist in one, check in the other? I might have to do that both ways though, since sometimes we re-activate old jobs. There's also ~2000 or so currently
If you have any idea where I could start, please let me know.
Thank you,