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