Search results

Ok the problem is When more than one instance form is opened, the records entered on the subform must be separate from the other instance form. In addition, if I use a query, this is difficult for the reason that I have complex codes that are not compatible with the query. Even if i try to deal...

Ok now this problem has been solved But the problem remained the subform How can each new instance have a separate table

I will try to work with this code Trust me, there is no solution. I am sure because every number I used cannot be used <> because they are separate numbers

Yes, I will choose the second solution, but how do, I do not know about query definition

Indeed, it is so complicated that I cannot make it again :ROFLMAO: ,This is related to the invoice accounting entry But the idea of sending the form name every time I request a query is pretty How can I find out the name of each form that I open How can I pass it to the parameter in query

Ok because this Form is for entering invoices It can itself be sales Or sales return Or purchases... Therefore, I will need to open the same form more than once at the same time And I have a purpose of being on the same form

When opening the form on the method of opening multiple instances of a form When you open the query, it does not recognize the form name

No, it is not possible to add 5000 records at the same time, but this form is designed so that the user does not add a new record every time he wants to add information As if he was adding in a textbox when saving the invoice, it insert only not null records to the main table

OK is the same parameter, but how does the parameter know from which interface to take the value?

Ok, as for the sub-form, it is linked to a table and of course when you open another form of the form it inserts the records into the same sub-form that is attached to the table

In addition, when opening the form automatically, add about 5,000 blank records to the subform so that the user can add inside it so that he does not need to add a new record when adding information. Of course, when saving the invoice, it insert only the full records on the main table

I have a form for entering an invoice, but in a very professional way But what I want is to open this form multiple times at the same time This form contains Subform. When I Create multiple instances of a form, it is inserted in the same Subform. Is there a solution to this problem? In addition...

Wow, you are a perfect person If I had wanted to create such a code, I would have wanted for several months This is if you knew how to make it

It's still a nice name

MajP, thank you for this code It is a nice It will benefit me a lot It seems that it took a great effort from you, thank you

Yes, it helps and helps a lot. It is a small code, but a very strong code, which is exactly what I want to thank you very much. I will try to integrate it with my own program🌹

Thank you Jemma But what I want is not limited to this hierarchical form In the account statement if you want more than one account in one statement There is an account in the accounting software that collects several accounts together, so it is possible to call this account 6 and this account...

Wow That would be very nice

The top account for the accounts could not be determined Because it is possible for the user to choose Account 11 and request his children It is not a requirement that the higher account be specified In addition, as I said recently, it is possible for the father's account to be completely...

Anyway for the solution What I want exactly is the result that is in the picture. If it only works on the same table, we will Insert it to another table But what I want is for the result to be on another table