[AccessD] Drew - TreeView help again, please

Drew Wutka DWUTKA at Marlow.com
Tue Apr 28 11:07:56 CDT 2009


Okay, here are the links.  Please let me know when you are done
downloading them, the server they are on is going offline soon.   (Also
6 pm EST we are going to have an interruption in our T1, so download
them as soon as you can).

http://70.253.148.163/MSDNDisc1.iso

http://70.253.148.163/MSDNDisc2.iso

http://70.253.148.163/MSDNDisc3.iso

These are .iso images (CD-Rom images), you can either burn them to a CD,
or personally, I use MagicIso (a freeware program) that lets you 'mount'
an .iso image as a 'virtual' CD-Rom.

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 5:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Drew - TreeView help again, please

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
>>>
>>>     
>>>       
-- 
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.





More information about the AccessD mailing list