ActiveX controls Browse for Folder Dialog

[marc]

Hi,

I have 2 activex controls on my form that I need to open up a common
dialog box and select/browse files, then populate two text fields.

The first one I have working:

The first activex is set up to open up the Select File Dialog box.
The properties of the activex are as follows:
OLE Class CommonDialog
Class MSCOMDLG.COMMONDIALOG

Code:
acxDialog.ShowOpen
txtDataFileLocation.SetFocus
txtDataFileLocation.Text = acxDialog.FileName

What I can't figure out is what needs to happen for the Browse for
folder Dialog box to appear with the second activeX control named
acxSaveLoc.

I have looked all over for the method/classes and can not find it when
using an Active X control

I assume I keep the OLE Class the same and have to change
acxSaveLoc.ShowOpen to something other than ShowOpen, but I can't find
it!

Any help would be greatly appreciated!
Marc Welty

"Two Pretzals were walking the street and one was a(salted)...."

[pietlinden]

don't bother with ActiveX controls. They're a PITA to register etc,
and you don't need it.

http://www.mvps.org/access/api/api0002.htm

[pietlinden]

Try either BrowseFolderAPI or OpenFileAPI at mvps.org/access

[marc]

pi********@hotmail.com wrote:

Try either BrowseFolderAPI or OpenFileAPI at mvps.org/access

This will work, but I would prefer not putting copyrighted code into my
application. Not that I don't want to give credit to where credit is
due, but it is set up based off of ActiveX controls, and that is what
we use. We have worked around all the problems associated with them, so
if anyone knows the code that would just open the browse for folder
dialog box described above, I would really appreciate it.

Im guessing a different OLE Class, and one method on the active x woudl
do it, just like .ShowOpen.

Thanks in advance!

Marcos

What do you call chess that is not yours? "Not"cho cheese!

[marc]

pi********@hotmail.com wrote:

Try either BrowseFolderAPI or OpenFileAPI at mvps.org/access

This will work, but I would prefer not putting copyrighted code into my
application. Not that I don't want to give credit to where credit is
due, but it is set up based off of ActiveX controls, and that is what
we use. We have worked around all the problems associated with them, so
if anyone knows the code that would just open the browse for folder
dialog box described above, I would really appreciate it.

Im guessing a different OLE Class, and one method on the active x woudl
do it, just like .ShowOpen.

Thanks in advance!

Marcos

What do you call chess that is not yours? "Not"cho cheese!