Forms List Box

[coleman01]

is it possible to have a file list box in access - i.e. that lists all files in a specified folder. I know this is possible in VB6 but i need to do it in access 2000.

 

[ghudson]

How hard did you search? Browse [Find a directory or file]

 

[coleman01]

Access Forms

Hi,

I dont want a file open/save dialog. I need a combo box that lists files within a folder if that makes sense?

Exactly like filelistbox's in VB6.

 

[coleman01]

Access Lists

I found something in that previous post I am going to try. Will re-post if I get stuck.

Many many thanks.

 

[ghudson]

Hi,

I dont want a file open/save dialog. I need a combo box that lists files within a folder if that makes sense?

Exactly like filelistbox's in VB6.

If you had bothered to open the sample in the link I offered then you would have discovered that the fScanDirSelectFileFromCombo form in the Browsing.mdb sample does exactly what you are looking for. The Browsing.mdb sample displays various ways to find, view, import, export and open files.

 

[scottfarcus]

Can it display a list of the folders in the directory as well?

 

[ghudson]

If you are asking if you can call a function to allow the user to "browse" and select a directory...Yes, my sample will show you how to do it.

 

[scottfarcus]

g,

fScanDirSelectFileFromCombo displays the *files* inside the drive or directory. I would like it to also display the *folders* inside the drive or directory. I don't believe it can be done, but thought I'd ask.

Thanks!