[AccessD] Drew - TreeView help again, please

Tina

...if you are referring to the help file for the MSComCtl.ocx (which 
contains the treeview) I can e you a copy ...but you are going to be 
disappointed in its contents ...not much more than what you see in the 
object properties.

William

--------------------------------------------------
From: "Tina Norris Fields" <tinanfields at torchlake.com>
Sent: Monday, April 27, 2009 8:44 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Drew - TreeView help again, please

> By chance, I was in the treeview control object properties dialog box
> and found the 'checkboxes' option not enabled.  I clicked to enable it
> and the 'Element not found' error message has disappeared.  However, I
> attempted to use the Help facility from that dialog box and got the
> message 'The MSDN collection does not exist.  Please reinstall MSDN,'
> which I would gladly do, but I don't know where to find it.  The
> discussions I have found on this topic refer mainly to Visual Studio,
> which I am not using (to the best of my knowledge).  Do you know where I
> can find MSDN?  Until this message, I considered that the acronym for
> Microsoft Developers Network.  I did some frustrating searching
> yesterday online and did not find what I need.  Any thoughts?  Thanks.
> T
>
> Tina Norris Fields wrote:
>> Drew and Gustav,
>>
>> Drew - yes Mirosoft ActiveX Data Objects 2.5 is available and I have now
>> referenced it.
>> Gustav - I did have a misspelling, which I have now fixed.
>>
>> Both - now the error I receive is much farther down the code.  It is in
>> the section for clicking any nodes - using my field and table names, it
>> looks like this (line numbers added for ease in discussing):
>> -----------------------------------
>>  1-  Set rs = New ADODB.Recordset
>>  2-    ' Click the nodes to be selected
>>  3-    strSQL = "SELECT tblAffiliateSkillsInventory.SkillsCode,
>> tblAffiliateSkillsInventory.Level FROM tblAffiliateSkillsInventory WHERE
>> MEMID=" & intMemID
>>  4-    rs.Open strSQL, CurrentProject.Connection, adOpenKeyset,
>> adLockReadOnly
>>  5-    If rs.EOF = False Then rs.MoveFirst
>>  6-    Do Until rs.EOF = True
>>  7-        tvw.Nodes("ID:" & rs.Fields(0).Value & ":" &
>> rs.Fields(1).Value).Checked = True
>>  8-        tvw.Nodes("ID:" & rs.Fields(0).Value).Checked = True
>>  9-        ' Expand the node to see the level
>> 10-        tvw.Nodes("ID:" & rs.Fields(0).Value).Expanded = True
>> 11-        rs.MoveNext
>> 12-    Loop
>> ----------------------------------
>>
>> The line that gives the error is line 7.  The run-time error is 35601
>> Element not found.  The tool-tip shows
>> tvw.Nodes(ID:" & rs.Fields(0).Value & ":" & rs.Fields...<element not 
>> found>
>>
>> I'm wondering what to do next.  Thanks for all your help.
>>
>> T
>>
>> Drew Wutka wrote:
>>
>>> Hmmm, is Microsoft ActiveX Data Objects 2.5 available?
>>>
>>> Drew
>>>
>>> -----Original Message-----
>>> From: accessd-bounces at databaseadvisors.com
>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
>>> Fields
>>> Sent: Friday, April 24, 2009 8:40 AM
>>> To: Access Developers discussion and problem solving
>>> Subject: Re: [AccessD] Drew - TreeView help again, please
>>>
>>> Hi Drew,
>>>
>>> I have these references checked, in this order
>>> :
>>> Visual Basic For Applications
>>> Microsoft Access 11.0 Object Library
>>> OLE Automation
>>> Microsoft DAO 3.6 Object Library
>>> Microsoft ActiveX Data Objects 2.1 Library
>>> Microsoft Windows Common Controls 6.0 (SP4)
>>> Microsoft Visual Basic for Applications Extensibility 5.3
>>> Microsoft ADO Ext. 2.8 for DDL and Security
>>>
>>> Am I missing something here?  Thanks,
>>> T
>>>
>>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>