Search results

  1. C

    Solved Node level path

    Yes! exactly. Thank you so much.
  2. C

    Solved Node level path

    @MajP Me again :rolleyes: What am I doing wrong here? Public Sub UpdateSortAndLevel() 10 On Error GoTo Err_Handler Dim i As Variant Dim LevelSort As Integer Dim strSql As String Dim nd...
  3. C

    Matching vba recordset to form recordset

    Whoa... @arnelgp!!!! You did my work for me and it works like a charm. Thank you so much. When I compare code I run it side by side in a spreadsheet. How does everyone else do this? Surely there's some secret here.
  4. C

    Matching vba recordset to form recordset

    This is a filing system. Numerical items are culled, "inUse" is unchecked and the record no longer shows in the list. When a new item is added, it uses the first culled number or is added at the end of the list. It has worked for years but I recently upgraded to Majp's treeview and I'm...
  5. C

    Matching vba recordset to form recordset

    eh... it's a subform, so it's limited records. I want to find any empty records and fill them in. I know you don't approve but the DocNo is not the ID. It is only a numerical list within certain bounds. I'll go back and rethink it. I wanted to do it from a module because it gets called from 2...
  6. C

    Matching vba recordset to form recordset

    I have the following code: Public Sub AddItem(ID As Long, strITPath As String) Dim rst As DAO.Recordset Dim strSql As String Dim lngDocNo As Integer Dim bkmrk As Variant strSql = "SELECT * from tblItems WHERE flocID = " &...
  7. C

    Solved Treeview address

    YEEES!!! Nailed it! This is exactly what I wanted.:ROFLMAO: Thank you so much!
  8. C

    Solved Treeview address

    So... it's not in the treeview... Dlookup(the location table, NodeLevel?, ParentID)?
  9. C

    Solved Treeview address

    @MajP Do you have a sub called "GetLevelIdentifier"? as in: ParentLevelIdentifier = GetLevelIdentifier(tvw.getNodePK(ParentNode), "LO")
  10. C

    Solved Treeview address

    Exactly. I just don't get how to get there. The LOPath is NOT what I want but what your sub is returning after I messed with it.:rolleyes: I need to turn node texts to numbers.
  11. C

    Solved Treeview address

    @MajP Because I'm looking for an address and the nodetext is very lengthy, I changed the NodeText to NodeLevel. That's not right either. What I'm looking for, and I think it's in E2E... sort of Each item has a DocNo that will be the ending number. But the LOPath of the locations should be: Top...
  12. C

    Solved Treeview nodes error

    Treeview loads and doesn't bark when it unloads. All is well!
  13. C

    Solved Treeview nodes error

    Nevermind... fixed with your update
  14. C

    Solved Treeview nodes error

    You've done a lot for me. Thanks. Do you notice that your ItemGenie also stalls at sortandlevel when it's closed?
  15. C

    Solved Treeview nodes error

    When this thing starts working I'll be doing the drinking.
  16. C

    Solved Treeview nodes error

    ID: "Item-" & [ItemID]
  17. C

    Solved Treeview nodes error

  18. C

    Solved Treeview nodes error

    my primary key is autonumber so it is numeric . Debug says theNode.key is "Location-7" and theNode.Tag is "". So getNodePK = Replace(theNode.Key, theNode.Tag, "") returns Location-7. I've tried to trace theNode.tag back... it's not a property, it's not a constant, where is it set?
  19. C

    Solved Treeview nodes error

    Public Function getNodePK(theNode As Node) As String getNodePK = Replace(theNode.Key, theNode.Tag, "") End Function I always have trouble here too. Can never find theNode.Tag so calls it a type mismatch. Is there a way just to return the ID? Well the type mismatch ends up here: PK =...
  20. C

    Solved Treeview nodes error

    Well! there ya go! I worked and worked to keep from asking (always my fault!) and now you're taking the blame!!! I am so on this!
Back
Top Bottom