ListBox

[DS]

I want to populate a listbox with a list of files from two directories. How
would I do this? The Directories are
C:\PROSERV\BU and C:\PRORED

Any help appreciated.
Thanks
DS

 

[Daniel Pineault]

I'm assuming you mean based on the file listing within these directories.

Make sure that the listbox's Record Source Type is set to 'Value List'

Then using the function found at (other out there, Google to find more)

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000027#DirList

you can then build a semi-colon seperated string which you will then use to
populate the listbox's RowSource.

Simple Example:
Me.ListBoxName.RowSource = "Value 1;Value 2;Value 3"
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

 

[Daniel Pineault]

I remebered having seen a tip on this previously and I finally remembered
where. Take a look at:

http://allenbrowne.com/func-02.html

For another possible solution.
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.