Filing suggestions 1

[Domino2]

At present,users put word documents manually into directories they have created on the networked hard drive.
I am trying to build a front end database which will ask them questions about the document they want to file, and the front end application will file the document.

Anyone done a similar operation, and can point me in the right direction. Do I create different directories for subjects of documents? or can I put them all in one directory and somehow have a link between the database record and the document. Thought I would ask the question before walking in quicksand. Thanks

 

[smedvid]

I would seriously look at the buy versus build approach. I know that there must be some tools for this filing; and additionally may even compress the files in the process to use less disk space. Good luck!

Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[MajP]

I have done some small scale things. I think it depends on how big and complex. I have code for the following. I have a db of "Studies" performed by analyst. Basically it is a project management db. Each Study (project) has multiple documents associated with it. The backend database resides on the network and each user has a front end on their local machines. I use only one document folder on the backend, but with a little more code I could place each Study's documents in their own folder. But I would only need that if you also want to access the documents manually and not using the database. It would be difficult manually to try to find something in a single folder.
Each study has a "document library" form. From there you can access, view, add, or delete a document from the network folder.

When you want to add it pops open a file dialog, you browse for a document, and it copies it into the network document folder. I sometimes will add the primary key of the related study to the document name (but not necessary) Then it adds the hyperlink to the document, and it appears in the list of documents for that study. You then can click on the hyperlink and open the document. If you delete a document, it deletes the record and the file out of the folder.

Pretty basic but works fine for a few hundred programs and a few thousand documents. I have this code if you want. I normally due not build management or administrative databases. My work is usually technical or engineering. So other people may have a better idea or opinions.

 

[Domino2]

Thanks Steve, but I need to put in added bits which may be difficult with commercially made product.

Thanks Majp, any starters on code very much appreciated. I will have to find a way to create "Mystery" folder names to stop people manually filing documents outside the program. If only users were sensible!!

 

[MajP]

This should get you started:

http://www.4shared.com/file/102212594/5ec458f1/File_Data.html

There is not a lot of bells and whistles, but you can view, add, delete with just button clicks.

 

[Domino2]

Many thanks Majp, thats perfect. I never thought of using URL's and adding the id number into the URL is excellent. That gives me a good start, thanks again.

 

[Domino2]

I did a compile on the code and it halts on the line
Set glblRsSearch = rs saying the variable was not defined. I tried declaring it as a string and a variant but could not rectify it. Any ideas, thanks

 

[PHV]

Probably a DAO.Recordset

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MajP]

This is code from a much bigger project. That is some left over functionality. I can not even remember what it does. Actually for your purposes just delete the frmAllDocuments and the subFrmAllDocuments. This was just another view of the documents library. Everything you need is in the modules and the frmDocuments and subFrmDocuments.

 

[Domino2]

Many thanks Majp, thought that might be the case. Thanks PHV, I did try DAO Recordset without success, but now know the reason its unwated.