Recent content by MajP

Same here. I cannot get an error.

Can you provide the backend?

According to chat -2147352567 error is actually a bug with NZ But my question is how can the subform have records and have record with a null ID. The only way I can think that is possible if it is on a new record. So I would have it move to the first record in the subform if it is null. So...

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 items in the selected location. The user selects a location and if that location does not have any items the location node is selected. If the location has in use...

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. Like changing to focus or simply putting in a debug.print. Often figuring out where to put the dovents is also tricky What is the real error? My guess is when...

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 So the question is why would the subFrmItem.itemID return no value? Well that code should never work because a subform control does not have a field. The form...

Example Post in thread 'Programatically change color on continous form conditional formatting' https://www.access-programmers.co.uk/forums/threads/programatically-change-color-on-continous-form-conditional-formatting.323250/post-1827631

You can either use conditional formatting or the On Paint event of the detail section.

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 guranteed to be deleting the current record of the form the way you have it. Instead I would make these more generic. You should handle all the form operations...

And to explain the error tvw.Nodes.Remove (ItemNode) 'is the sames as tvw.Nodes.Remove (ItemNode.defaultProperty) 'is the same as tvw.Nodes.Remove ("Joint Account Papers") ' No node with a Key 'joint account papers'

As @cheekybuddha describes the default property of a node is the text property so if you do debug.print tvw.nodes("somekey") it should print the text of the node. So if that is the case and it is printing out the text then it is finding the node. Sorry, I did not read the full message carefully...

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 "Identifier" which tells me what table it came from concatenated to the real ID. So if I have more than one table like a location table and an item table and I would...

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 dimensional array where it stores the ProductCode and some other information and the table only stores the ProductCode. And you want to join these and pull in other...

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.

Yes UPDATE your_table SET column_to_update = 'New_value' WHERE id IN ( SELECT TOP 30 id FROM your_table WHERE userFK = 'specific_user_id' ORDER BY ID DESC );