IF you use the TreeView Control (v 6.0) be sure to include the following references otherwise you will get the runtime error 13 - Type mismatch. This error is misleading because the mismatched type is buried inside one of the references and not in the code that you may have written.
The references:
Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsoft Office 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
*Microsoft Jet and Replication Objects 2.5 Library
Microsoft Windows Common Controls 6.0 (SP3)
* The Microsoft Jet and Replication Objects 2.1 Library will also work, but if you have the 2.5 Library use it.
I hope this helps someone else it would have saved me hours of debugging code that was correct.
Steve B-)
The references:
Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsoft Office 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
*Microsoft Jet and Replication Objects 2.5 Library
Microsoft Windows Common Controls 6.0 (SP3)
* The Microsoft Jet and Replication Objects 2.1 Library will also work, but if you have the 2.5 Library use it.
I hope this helps someone else it would have saved me hours of debugging code that was correct.
Steve B-)