Exploring Files through Treeview or Windows API 1

[SiJP]

I've gone through the laborious task of creating a varety of controls and code to emulate the windows style file dialog you get when opening a file. It works by using a list box for the directories and a list box for files.. Its not the most elegant way of doing things, but like I said: it works.

The next challenge is to painfully delete this form. The challenge after that is to find a way of utilising the Windows dialog box, within my database in place of the form I've created. There are two reasons for needing to do this. a) the client and b) personal achievement

I believe this can be done by utilising the actual windows dialog box or downloading a TreeView Plug in. I have done some research into this and found some code written by Ken Gatz (

http://www.mvps.org/access/api/api0001.htm)

which calls the Windows api - I'm overwhelmed by the code which is outside of my knowledge to debug (as errors are produced using Acc 2K).

If anyone can suggest some resources, websites or just give some helpful suggestions for this I would be grateful.

TIA

 

[GHolden]

I would suggest that you look into the Microsoft Common Dialog Control. This is an ActiveX control that is exactly the same as the Windows Open file box.

Once the control is added to the form you can activate it by simply using..

DialogControlName.ShowOpen

Check to see if you have this control on your machine by clicking on the more controls button when you have a form in design view.

Hope this helps.

There are two ways to write error-free programs; only the third one works.

 

[SiJP]

I might come back for some more help regarding this in the near future, but thanks for your direction - certainly a starting point!

 

[GHolden]

No problem, I'm not sure the help is all that good on that control. If you need help using it just re-post.

There are two ways to write error-free programs; only the third one works.

 

[FranzSurbier]

Hi,

Just search for Treeview in the forums cause I made an example in the vba-access forum... I just don't know how to link there...

cu,