How Do I Populate Combo Box With Folder Names? (a2k (9.0.6926) SP-3 Jet 4.

Topic

New Reply

Thanks for the attached code from the following
Re: Help With Populate Combo Box? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
post 617,498 re: 617,494 from Support4John

I have a disk directory file structure as follows:

C:PropertiesStreetsAdams St 123
C:PropertiesStreetsAdams St 123Adams St 123H.tif
C:PropertiesStreetsAdams St 123Adams St 123V.tif
C:PropertiesStreetsAdams St 123Adams St 123V2.tif
C:PropertiesStreetsAdams St 123Adams St 123V3.tif

C:PropertiesStreetsAdams St 234
C:PropertiesStreetsAdams St 234Adams St 234H.tif
C:PropertiesStreetsAdams St 234Adams St 234H2.tif
C:PropertiesStreetsAdams St 234Adams St 234V.tif

C:PropertiesStreetsAdams St 345
C:PropertiesStreetsAdams St 345Adams St 345.doc
C:PropertiesStreetsAdams St 345Adams St 345H.tif

… 100’ of Streets A-Z:

When I open a form I want to populate a combo box with directory names as follows:

Adams St 123
Adams St 234
Adams St 345

I then want to select a street and drill down to the file contents of the folder with Explorer and use Explorer to open and manipulate the file.

What would I have to change using concepts in the attached demo to populate a combo box with directories?

Thanks, John

PS: I could not search out an Image Manager to handle something like this.

Reply | Quote

Replies

Why not simply open an instance of of Windows Explorer on C:PropertiesStreets?
The user can easily open a subfolder directly in Windows Explorer instead of having to go through a combo box *and* Windows Explorer.

For example:

Shell “explorer.exe /e, C:PropertiesStreets”, vbNormalFocus

Reply | Quote

Hans

I will give it a try.

Thank you for that.

John

Reply | Quote