I have a Access 2000 app and have a form which lists the contents of several folders like below
Set folderObject = FSO.GetFolder(RefFolder)
Set filesObject = folderObject.Files
For Each File In filesObject
Me.DocumentList = Me.DocumentList & File.Name & " " & File.DateCreated & vbNewLine
I want to (also) get this listing into a Report for printing. What is the correct approach here? Should I do it all within a query? I would like the various FILE parameters as seperate fields ideally.