Search results

Haha I heard this proverb before and I felt it was right for the confusion we are in

Ummm The news today with money tomorrow for free:ROFLMAO:

I did not notice this matter It was modified before misfortune occurred, which I had not anticipated

Yes Because these accounts are called accounting, the qualitative account It collects accounts from various accounting account trees

Ok, anything that brings me to this Result

In addition, it is possible that the father’s account does not include the son’s numbers The code should go down the ladder step by step

I guess it won't do this Because the table could be like this I think this has something to do with recursion

Hello all I want to know the children of an account in the account tree I have attached a picture on the topic I have a table and I want to extract from it the children of a specific account. Is there a way through the vba or sql? Thanx

My friend @gemma-the-husky , I did not understand what you mean, but in the end this is an example that I set for you and it is not an actual account tree, but this was just a quick example of the amount of data I have

Wow, Mr. @arnelgp , a wonderful job in a crazy way, this is just what I was dreaming about. Thank you very very much, you are a genius. I thank everyone for their interest, and a special thanks to Mr. @MajP . I also took advantage of the code that You designed for other things, and thank you for...

Mr. @MajP Thank you for the effort you made, a wonderful job. This code did the addition process within five seconds. I think this is the fastest possible speed. I hope it will be faster, but it seems that this is not possible.

This is a simple example of the topic, but there may be more than one tree belonging to a main account, and each calculates the sum of its children

I thank everyone for their interest, my dear brothers. This is actually a tree of accounts for an accounting program. I will attach an illustration

Or if the update is faster, you can consider the data table as the same as the accounts table

Yes, I want to update the accounts table, but in order to make it easier for you, let's assume that I want to put them in a temporary table. How will the code be in this case

Mr.arnelgp solution takes a minute and 20 seconds

Or through the tree view, as you said, it does not matter. I want the fastest way, in any way, A method for updating all accounts through the data

Ok, I am sorry, I may want a solution to my problem, and I do not know how to explain in a clear way Now you say if I only want to update a table (and this is what I just want to update) programmatically and it only takes two seconds on the amount of data that I have, how is this ,thank you so much

It is impossible that there is no solution to this problem. In any way, I want to activate this query update accounts without disrupting the user Is it reasonable that not all Access programmers have a solution?

It also took 20 seconds, I have an idea whether it is possible to make this query on another data base and run the query from another database so that the user can work and work the query on another database in this case the user will not wait 20 seconds until it finishes and completes its work