[AccessD] Drew - TreeView help again, please

Hi William,

Hmm, that's too bad, because the properties dialog box certainly left me 
wondering.  Clicking Help only has made me wonder more.  Still, if 
you're willing to send me a copy, I will appreciate it.  Thanks.

Tina

William Hindman wrote:
> 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
>>
>>     
>
>
>