Search results

  1. C

    Field has no value

    Oh Rats! You guys! now it works!:sneaky: :rolleyes: I'm going shopping.
  2. C

    Field has no value

    click on an item. (brown). it immediately goes to If IsNull(subFrmItem.ItemID) Then and stops. It is not null. It just stops. It cannot have a null ID. Does not have a null idea. Just thinks it does.
  3. C

    Field has no value

    I'm sorry. I thought I did! :rolleyes:
  4. C

    Field has no value

    Well that works.... but it stalls on the first line and I have to push it on. Would you like to look at it? Click Detail and then select an item
  5. C

    Field has no value

    I thought I could have the flow go both ways. The Location subform has all the locations as a recordset and the Detail subform has a recordset of records under the selected location. Mostly it works but the tree loses it's connection on the above situation. So I got this brilliant idea: Public...
  6. C

    Field has no value

    I put both do Events and Set Focus and it seems to be working. If I put only set focus it says you can't go to the specified record. Thank you very much for your time.
  7. C

    Field has no value

    AAARRRGGGHHHH! I Knew That! But wait... I screamed too soon On open of the main form I have: Set subFrmItem = Me!ItemDetail.Form Most of the time it actually does work. But jumping to make the form visible seems to show no valid ID. It immediately works after it complains
  8. C

    Field has no value

    @MajP
  9. C

    Field has no value

    On a treeview click I use this for matching the subform to the clickednode: Public Sub MatchNode() Dim strKey As String Dim ID As Long Dim Children As Integer Children = DCount("*", "tblItems", "flocID = " & Me.txtLocID & " And InUse = True") If...
  10. C

    Element not found

    Gotcha! Thanks
  11. C

    Element not found

    Thanks guys! On to my next problem... The smallest things can bring everything to a screaming halt! 😜 Actually, now that I check more carefully, it looks as though the item is always a selected node so I may go that route.
  12. C

    Element not found

    Although I didn't know there was a difference... You guys harp and harp DEBUG DEBUG DEBUG. I would not attempt a question here without DEBUGGING! :rolleyes:
  13. C

    Element not found

    still returns Joint account papers
  14. C

    Element not found

    IT and LO are my identifiers. So it seems like the string should be "IT57" but instead nodes returns the text name "Joint account papers". I was very confused by this but decided it was a Nodes value. So Set ItemNode = tvw.Nodes("IT" & Me.ItemID) the ("IT" & Me.ItemID) returns IT57 but...
  15. C

    Element not found

    @MajP I'm sorry but I can only work on this a little at a time so it's dragging out... Item details (add, edit, remove, etc) are on a subform and the treeview is on the mainform. I don't delete items as such but only clear fields so that the DocNo stays and is used as items new are added or...
  16. C

    Treeview initialize

    Ahhh!! Thank you so much!
  17. C

    Treeview initialize

    at the top of frmDetail: Public WithEvents tvw As TreeviewForm 'Private WithEvents subFrmItem As Access.Form 'Private WithEvents subFrmLoc As Access.Form Public FAYTitems As FindAsYouTypeCombo
  18. C

    Treeview initialize

    yes it's frmDetail. Now I'm not clear on what you're saying... this is the main form code: Public Sub InitTree() Dim nd As Node Dim strQry As String ' Debug.Print NodeQuery If Me.TVWSort = 1 Then strQry = "qryNumeric" Else: strQry =...
  19. C

    Treeview initialize

    @MajP I need to update the branch after adding an item: Public Sub UpdateBranch() Dim tvw As TreeviewForm Dim ParentNode As Node Dim newNode As Node Dim SelectedNode As Node Dim Key As String Set tvw =...
  20. C

    Solved Position form to added record

    Oh! The things I don't know! Actually just strCriteria works. Thank you so much.
Back
Top Bottom