returning file info from folder

[apples76]

I have see nsomewhere on the internet that it is possible to produce a record set from information of files within a folder..

ie file name date modified/created etc.

could someboy please point me in the right direction as i need to check alot of files in a short time.


Thanks.

ps... i'm only a beginner so as much help as possible would be greatly appreciated.



Cheers

 

[modest]

Do a search on File System Object. From that you can use Access's VBA's intellisense to gather a whole bunch of information.

Once you set up your fso, it's just looping through folders and files and loading the attributes into a recordset.