[AccessD] Drew - TreeView help again, please

Tina Norris Fields tinanfields at torchlake.com
Mon Apr 27 17:48:27 CDT 2009


I would appreciate that, Drew.
T

Drew Wutka wrote:
> 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
>>>
>>>     
>>>       



More information about the AccessD mailing list