Roger's Download Samples - DirectoryList.mdb (intermediate)

Print Page | Close Window

DirectoryList.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=353
Printed Date: 16 Apr 2024 at 2:06am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: DirectoryList.mdb (intermediate)

Posted By: Roger Carlson
Subject: DirectoryList.mdb (intermediate)
Date Posted: 01 Aug 2008 at 5:13am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - 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): uploads/5/DirectoryList97.zip - DirectoryList97.zip
Access 2000 ADO (62 KB): uploads/5/DirectoryList2k.zip - DirectoryList2k.zip

-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<