Recent content by ClaraBarton

  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.
See more
Back
Top Bottom