MajP's latest activity
-
MajP replied to the thread Field has no value.It appears the flow is going in the opposite direction. My guess is the main form selects a location and the the sub form is in use... -
MajP replied to the thread Field has no value.So that does sound like a timing issue, and do events would be my first guess to. Often the fixes for timing issues are unexplainable...
-
MajP replied to the thread Field has no value.If I read this correctly it does not have to do with the treeview but has to do with reading the ID of the current record in the subform...
-
MajP replied to the thread Solved Continuous Form and Color Code.Example Post in thread 'Programatically change color on continous form conditional formatting'...
-
MajP replied to the thread Solved Continuous Form and Color Code.You can either use conditional formatting or the On Paint event of the detail section.
-
MajP replied to the thread Element not found.I think I would not do that. That seems indirect if the tree and the form get out of synch you can be deleting the wrong node. You are...
-
MajP replied to the thread Element not found.And to explain the error tvw.Nodes.Remove (ItemNode) 'is the sames as tvw.Nodes.Remove (ItemNode.defaultProperty) 'is the same as...
-
MajP replied to the thread Element not found.As @cheekybuddha describes the default property of a node is the text property so if you do debug.print tvw.nodes("somekey") it should...
-
MajP replied to the thread Element not found.The way I am able to relate the treeview and the tables and the nodes to the records is as follows: 1. I create the Key from an...
-
MajP replied to the thread How to query db with memory array data?.II may have read it wrong focusing on pulling data from the table and the array I was thinking that the array might be a multi...
-
MajP replied to the thread How to query db with memory array data?.As far as I can tell the OP is not talking about creating a filter, but joining data So they are likely limited to a temp table.
-
MajP replied to the thread Solved How to Update a recordset without a loop?.Yes UPDATE your_table SET column_to_update = 'New_value' WHERE id IN ( SELECT TOP 30 id FROM your_table WHERE userFK =...
-
MajP replied to the thread Solved How to Update a recordset without a loop?.It is not reading the PKs of the table it is reading the PKs of the records in the forms recordset. This can be a filtered or queried...
-
MajP replied to the thread Solved How to Update a recordset without a loop?.One more thing. Even without any of these other methods, simply try turning echo off and then back on. Here is the double safe...
-
MajP replied to the thread Solved How to Update a recordset without a loop?.Lets say you open a form and the user then applies filters and modifies it. One thing I do often do in that case especially if they...