Recent content by EndIfTrue

Thank you, sir! I couldn't be more grateful for all of your help! With this batch of code, we have turned two weeks of work into 20 minutes. +rep! For the sake of continuity, here is my final code. I just had to add the "set OrdID" reference to make it work.

The files have to be migrated into the org's system of record, which requires them to be in basic files/folders before upload. It lacks the capability of receiving inputs from Access Hence why I'm in this predicament :o

I think we're close! However, the bolded/underlined line above returned the error "Item not found in this collection". Interesting (Side note: the original code does "work," it just doesn't put the items into ITEM# folders as needed)

The last point is correct: I'm trying to remove existing attachments from the database. the goal is to move them *out* of Access and into regular folders, still categorized, so that I may upload them from there into an enterprise application

Essentially, I'm trying to create folders for the attachments to go into. I'm pretty new to Access and VBA and working on a tight deadline :o

Hello all, So, I happen to be moving ~5000 documents for a project. Each one has been inserted into Microsoft Access under a column, "Attachments". Then each has been associated with a label under the column "Item#". The objective is to write code that creates folders for each Item#, then...