Automatically find local documents?

[unluckytoe]

Hello Everyone:

Does anyone know of a sample DB or know a way to select a drive (for instance we'll say the C:\) from a DB and it scans for all the documents and their full paths?

I'm currently using a wonderful sample DB that will allow me to type/copy-paste a documents path, which I don't mind however we have a large growing library of documents and I think that automating this task would be better.

I have attached the DB that I'm currently using, and I thank you all for reading and any help that you can provide.

Brian

PS I'm using Access 2007 on Windows XP

 

[Poppa Smurf]

An updated version of your database is attached.

I have added a text box to your Add Document Tab. Click on the three dots to the side of the text box to open the search window. After locating the file, highlight the file and the filename will be displayed in the text box.

I have not changed any existing code, a few modules have been added to perform the search function.

The code behind the three dots can be changed if you are looking for a specific file name e.g. Spreadsheets strFilter = ahtAddFilterItem(strFilter, "Spreadsheet Files (*.xls", "*.XLS"). Addiitonal file extensions can be added if required.

 

[ghudson]

Searching the forum is a great way to find and discover the answers to your questions. Browse [Find a directory or file]

 

[smig]

I took the Brousing sample and it seems exactly what I need

my only question - how do I set the default (starting) folder for browsing. basicely I want to point to the "My Documents" folder.
can I use systm names (%MyDocuments%) ?