Search results

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.

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:

still returns Joint account papers

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

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

Ahhh!! Thank you so much!

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

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

@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 =...

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

Of Course! Why couldn't I think of that? Thank you! I tried setting the recordset from the table and then bookmarking the .last modified before requerying the form but I couldn't get a valid bookmark that way. Why is that?

What I need to know is how can I grab the record ID right after the ExecuteSQL.. whether it's a new record or an update of a previous record.

No, that's an ID that connects it as a subform. It's a parent ID and there are many subrecords. The record ID is created on the INSERT or it's located on the UPDATE

I know how to get the ID (DMax) of a new record but I fill in (Update) unused records that aren't in the form recordset until the checkbox inuse is positive. I'm stumped as to how to get the ID if it isn't a new record. These records aren't included in the forms recordset until the table is...

Be sure your sins will find you out! UPDATE tblItems SET ITPath = '1 > 11 > 2', Item = '(New)', InUse = True WHERE flocID = 12 and DocNo = 1;

Now I've done a complete circle and am back where I started. :rolleyes: strSql = StringFormatSQL("UPDATE tblItems" & _ " SET ITPath = {0}," & _ " Item = '(New)'," & _ " InUse = True" & _...

Aargh! "1 > 3" ! and "(New)" ! Well... getting closer strSql = StringFormatSQL("UPDATE tblItems" & _ " SET ITPath = """ & strITPath & """," & _ " Item = " & """(New)""" & "," & _ " InUse = True" & _...

Ah! I KNEW you'd know! Thanks! So Here's my update : strSql = StringFormatSQL("UPDATE tblItems" & _ " SET " & StringFormat("ITPath = {0}", strITPath) & "," & _ " Item = " & "(New)" & "," & _ " InUse =...

When a variable is a string, the following adds quotes to it: strSql = StringFormatSQL("UPDATE tblItems" & _ " SET ITPath={0}," & _ " Item={1}," & _ " InUse={2}" & _ "...

Yes! exactly. Thank you so much.