Question regarding list boxes

[Guest]

Using Access 2003, is it possible to display all files in a folder inside a
list box? so if i had a folder with 10 pdf files in it, the list box would
display all the files? or do i have to type the name of each pdf file into
the list box manually?

 

[Allen Browne]

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

To list all the PDF files in C:\MyFiles, in a list box named List0 on Form1,
the code would be:

Call ListFiles("C:\MyFiles", "*.pdf", False, Forms!Form1!List0)