Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SWAndruski

    how to make treeview toplevel display as an alphabetical index

    I've got this working. Here's the code for anyone interested: Private Sub Form_Load() Dim alpha As Long alpha = 65 ArtistTree.Nodes.Clear 'Populate root level with Capital Letter Alphabet Do While alpha <= 90 ArtistTree.Nodes.Add , , Chr(alpha), Chr(alpha), "Folder" alpha = alpha + 1...
  2. SWAndruski

    how to make treeview toplevel display as an alphabetical index

    Sounds like the SQL statement is the way to go. I may also look at a parameterized query using the QueryDef command. These are supposed to be more efficient, and since I only need to change the WHERE clause in each iteration it may be easier to code. I'll be working on this over the weekend...
  3. SWAndruski

    how to make treeview toplevel display as an alphabetical index

    gol4, Thanks for the hint. I'll try that tonight. Every example I've found does it the way I have in my code, but it's worth a try. If this works then it may be easier to use an SQL statement in the OpenRecordset line and put the filter in as a WHERE clause. Intuitively I thought it would...
  4. SWAndruski

    pb of relation root-child in a treeview

    Nathalie, For the child nodes the following format is used: tvTreeView.Nodes.Add ParentNode, tvwChild, key, ChildNodeText The first parameter is a reference to the parent node that these child nodes will be added under. Without that, all of the nodes are "root" nodes. I think that this is...
  5. SWAndruski

    how to make treeview toplevel display as an alphabetical index

    Brian, I don't know if you've solved this yet, but I've got code that fills the root level of a tree control with alphabetical headings. The problem is that filtering the recordset doesn't seem to work. I was putting this together piece by piece and got this far to make sure that the "A" root...

Part and Inventory Search

Back
Top