Multiselect Comdlg box

[Ronnieatwarton]

How can I get a common dialog box to open and allow selection of multiple mdb files in Access 97???

 

[hneal98]

When you say common dialog box, do you mean the actual control called the common dialog box or do you mean just a dialog box?

 

[Ronnieatwarton]

Sorry, yeh using the comdlg32.ocx control.
I want to select a number of mdb files. These will then be used to open a table from each and append to a table consisting of all records.
I have a list box at the moment and it works, but would like to slick it up a bit.

 

[hneal98]

To my knowledge, there is no way to do multiselect in Access 2002, which is what I currently have. I am not sure about the later versions. Chances are, if you don't see that option, it probably does not exist.

If the files have some kind of consistency, like when receiving EDI files, they might have the first few characters of the name all the same like EDI820, and then have some different digits for the last part of the file name for the date, like 050420, so the name is like this EDI820050420.txt, then you could set up code to read them in, but other than that, perhaps someone else will have an idea.

Sorry I could not be of more help. The other option would be to use VB6 or greater as the front end and use Access as the backend only.

 

[ZmrAbdulla]

At mvps.org downloads there is file called CommDlg Preview a different attempt to mimic explorer window. May be useful to you.

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.