DirectoryList.mdb (intermediate)

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Please consider donating $1 per sample downloaded, find out why here. 

DirectoryList.mdb
This sample shows how to "role your own" directory/file list.
It uses the Shell() function to run a DOS DIR command and pipe it to a text file. Then imports the text file into a table. It does it first with the Directories under a drive and then with the file under the directory.
See the code behind the form for details.
Also check out the Modules for other applications of this technique.

Download
Access 97 (43 KB): DirectoryList97.zip 
Access 2000 ADO (62 KB): DirectoryList2k.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Roger Carlson Members Profile Send Private Message Find Members Posts Add to Buddy List Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261	Post Options Post Reply Quote Roger Carlson Report Post Thanks(0) Quote Reply Topic: DirectoryList.mdb (intermediate) Posted: 01 Aug 2008 at 5:13am
	Please consider donating $1 per sample downloaded, find out why here. DirectoryList.mdb This sample shows how to "role your own" directory/file list. It uses the Shell() function to run a DOS DIR command and pipe it to a text file. Then imports the text file into a table. It does it first with the Directories under a drive and then with the file under the directory. See the code behind the form for details. Also check out the Modules for other applications of this technique. Download Access 97 (43 KB): DirectoryList97.zip Access 2000 ADO (62 KB): DirectoryList2k.zip
	Consider donating $1 per sample downloaded, find out why here.<

Sponsored Links