dirlistbox ActiveX in VBA for Access97

[Viking1]

I am using VBA in Access 97, and would like to have some additional ActiveX controls, namely the DirlistBox, PathListBox, and the CommonControls Objects. I can't find these anywhere, and would surely like to use their functions in my application.

[Orpheus]

You need to provide a reference witin your Access project to the ActiveX controls that you wish to use. I cannot remember where in Access/97 this was, but in Access/2000 you open a form in design view, and then select "Tools", "ActiveX Controls" from the menu. You should then be able to use any ActiveX contrl loaded and registered on your system.

However, beware: if you are building an Access application that you plan to distribute, you must also distibute the ActiveX controls used and any dependancies that they may have. Similarly, these controls and dependancies must be registered on the target system before they will work.
There is also the issue of copyright and distribution rights ......