Opening a Directory

[harrisw]

I'm trying to display the contents of a directory( as windows does) when a button is clicked.

Any one help?

 

[Nero]

Use the 'Microsoft Common Dialog Control' which you can find in the 'More Controls' button on the toolbox menu.

Kev

 

[harrisw]

More

I've added the control to the form but how do I get the dialog box to open

In VB its dlgbox.showopen but I don't have the show open option in access 97.

 

[Nero]

In A2k it is :-
Me.Cmdl01.InitDir = "Drive Letter"
Me.Cmdl01.Filter = "*.jpg|*.jpg"
Me.Cmdl01.ShowOpen

I'm not sure if it is the same in 97.

Check your library references in Tools>References.
Make sure you have the ActiveX Data Objects 2.1 ticked.
Kev.

 

[ghudson]

You should check out these API's...

API: BrowseFolder Dialog
http://www.mvps.org/access/api/api0002.htm

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm

HTH

 

[harrisw]

Dialog box

I've put a tick in the acvtive x 2.1 but still don't have the option for .showopen to display the form.

Anything else I can try?

 

[harrisw]

dialog box

I managed to get it to display but when I double click a word doc etc they don't open

 

[harrisw]

1 more. How can you disable the items on the dialog box ie filter, and the buttons on the top right.