Read a Directory

[Guest]

Good day,

Can anyone help me do the following?

I would like to have an Access Program read the Directory on a drive and the
contents of a folder through a list box.

Then on Dbl click to open the file.

Drive = Prive
Folder = Packaging
contents are in PDF format

Much appreciated

 

[Allen Browne]

See:
List files
at:
http://allenbrowne.com/ser-59.html

The article explains how to set up a list box to show the files.
And you can optionally filter list subfolders as well, and filter to just
PDFs.

To open the selected file in the DblClick event of the listbox, use:
FollowHyperlink Me.lstFileList

 

[Guest]

Works Perfectly,

Thanks Allen

See:
List files
at:
http://allenbrowne.com/ser-59.html

The article explains how to set up a list box to show the files.
And you can optionally filter list subfolders as well, and filter to just
PDFs.

To open the selected file in the DblClick event of the listbox, use:
FollowHyperlink Me.lstFileList