[AccessD] Drew - TreeView help again, please

I got the MSDN installation CD's with VB 6 and the Developers version of
Office.  I use the 3 CD's that came with the dev edition of Office 2000.
I can put them up somewhere for you to download if you'd like....

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Monday, April 27, 2009 7:45 AM
To: Access Developers discussion and problem solving
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
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.