document database

[Mbakker71]

Hello,

i work by a company and they ask me to create a database where they can upload there documents. but now i've a problem because i want to make a folder stucture. but what is the smartes idea to create a select folder system. for exemple i click on C:/ you see the folders and documents that are in that folder.

sorry for my bad english!

bey,


martijn

[GAtkins]

http://www.citrix.com/products/sharefile/overview.html

no affiliation....

[Mbakker71]

it 've to be in access

[June7]

Can use VBA to open file/folder picker dialog.

Bing: Access VBA file dialog

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[Mbakker71]

that is not the problem i want someting that when the user click on disk C for excample that the folders are visible in de c disk en when the user click on a folder that then de files and folders are showing that are in that folder

merry christmass!

martijn

[orange]

martijn,

June7 has shown you the technique to work with folders from Access. You can get as fancy as you need with your form or user interface, but this sort of code will be "behind the scene". My advice for you is to write down a description of all the pieces/processes you will need.

Your comment

when the user click on disk C for excample that the folders are visible in de c disk en when the user click on a folder that then de files and folders are showing that are in that folder

is what we would call the view from 30,000 feet.

Here's a data model that may give some ideas.

You need some details.

What folders? What files? What users? Are subjects important? How about dates? And revisions? What is the real purpose of the database/application?
Good luck, and

vrolijk kerstfeest

[June7]

Martin, you are describing the Windows file explorer. If you want to do file/folder search from within Access, that requires code to open the file/folder picker dialog.

[Mbakker71]

I want something that people Find there documents. For exempel by Windows when you click in the c drive Windows shows all the documents and folders. I want something like that in a form

[June7]

I have never seen anything like that in an Access form.

There is something called a listview control in Visual Basic but I've never figured it out. http://www.freevbcode.com/ShowCode.asp?ID=7554

Here is code for Excel http://www.cpearson.com/Excel/FolderTree.aspx

If you want users to be able to dynamically navigate to a folder/file, use the file dialog. http://www.ammara.com/access_image_f...er_dialog.html