Tina Norris Fields
tinanfields at torchlake.com
Mon Apr 27 07:44:43 CDT 2009
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
>>
>>