If you like my Listfiles tool, please donate so I can keep on developing.
thank you

watch! 2015 Microsoft MVP Virtual Conference on Channel 9 (MSDN) for Access
53 minute presentation

"Have you ever wanted to find out generic properties about a file, such as the duration length of an MP3 file, or the date a JPEG picture file was taken on a digital camera?" -Wayne

Even though I have not incorporated it yet, you can get this amazing capability from Wayne on EverythingAccess in the Access Tutorials section.

Access Basics Video Tutorials Learn VBA ListFiles Database Random Picker Error Handling Reference Database Whistles & Bells Help Examples Crystal's Analyzer Code Documenter

ListFiles Database
by and modified by Crystal

Recursive File listing modified from code witten by Allen Browne .
Browser code originally written by Stephan Lebans .
GetComputerName written by Dev Ashish .
and, coming ... sometime ...

an updated version to get and set additional file information, written by the remarkable Wayne Phillips , who exposes hard-to-figure-out stuff :)

Accessing detailed file information provided by the Operating System
by Wayne Phillips
support for Windows XP, Vista, and Windows 7

Download (208 K)  

Reads file name and file attribute information into a database -- can be done for one directory or a directory tree. NEEDS references to:

  • Microsoft Scripting Runtime (because all the information that can be obtained from the FSO object is also recorded)
  • Microsoft DAO # Object Library
    Microsoft Office # Access Database Engine Object Library
This sample database can be distributed freely. If you are selling an application and wish to incorporate code or ideas, you will need to obtain written permission from all the authors.

The main benefit of this database is the data that it generates about the files stored on your computer. Any other objects such as queries and forms are probably not needed by the program unless they start with usys, which marks them as user system objects.

Best to Compile before you run. Look at Relationship diagram and Field Descriptions in each Table Design.


"May I hint you to check the underlying query for your form named "f_Showfiles". I've missed the path informations, but adding the table "Dirs" resolves that problem."

— Jens Schilling, Microsoft MVP, Access

Thank you for pointing this out, Jens ... guess I left some of my half-baked ideas in there... I never finished that form -- had great plans for it ;) Feel free to modify or just delete the f_Showfiles form

I have gotten emails from a few people complaining that I left forms in there that don't work ... I could take them out ... then you'd have more to do if you want to build one yourself. Rather than looking at unfinished stuff as something bad, look at it as a start

Now I have brilliant code written by Wayne Phillips that gets additional file properties that are exposed by Windows such as the Date and Time a picture was taken, or the Length of an MP3 file ... so I will update this database to include these new treasures (smile) ... sometime!

Free Book on Access: Access Basics

Free Tutorials: Video Tutorials

for information on private programming and training, or if you have comments and ideas, I'd love to hear from you

Copyright © 2009-2012 Crystal Long | Last updated Nov 2012 |