Question regarding list boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StuJol - 12 Mar 2007 06:30 GMT

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?

Reply to this Message

Allen Browne - 12 Mar 2007 06:51 GMT

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)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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?

Reply to this Message