Document managment

[Homegrown]

I'm using an access database to generate reports. It could be up to 400 at a time. It's quite time consuming to manually put the documents in the right folders when they are completed so I was wondering if there is a better way of doing this.

I'm open to suggestions from start to finish; but in my mind it would work something like this:

The user generates the reports based on a query and these are then saved to the reports folder. I then run a macro that will look in a target folder which I define, then place the documents in the appropriate sub folder based on the Name.

The names of the documents would vary but they would always have the folder Name before the last part. EG. Name Plan OR Name Manuel.

Hopefully I've explained it well enough to get some feedback or ideas.

Thanks! Andy,

[SamT]

Andy, I am moving this thread to the Access Folder, where it will get more views by our Access experts.

[GeorgeRobB]

I am not ceertain what your problem really is. What is the format of your report?

[HiTechCoach]

Andy,

Did you get this resolved?

[Homegrown]

Sorry guys I didn't get any emails saying you responded! No its not resolved, I want to have access move documents into the right folder if this is possible. before going into any detail. Is this possible?

[HiTechCoach]

Yes, it is possible to do what yu need with Access VBA code..

FWIW: I create document management systems in Access.

Why not have Access save the documents to the final destination folder from the start so they do not have tro be moved later.?

[Homegrown]

Yes, it is possible to do what yu need with Access VBA code..

FWIW: I create document management systems in Access.

Why not have Access save the documents to the final destination folder from the start so they do not have tro be moved later.?


I would love for it to do that. There are many features I would like to implement. I don't have the time to make the progress I want to on this. (I'm getting there slowly).