Search results

Thanks very much arnelgp, Private Sub Form_Open(Cancel As Integer) ' Me.ContrôleNavigation0.Tabs(3).SetFocus ' Call fSendKeys("{ENTER}", True) DoCmd.BrowseTo ObjectType:=acBrowseToForm, _ ObjectName:="f_Operation", _...

Thank you arnelgp , I just noticed that when copying the module, there was a deterioration of 2 lines, I repaired this problem and everything works properly there is no more modification of the Num lock key. Excuse me for my mistake and thank you for your wise advice Private Sub...

Thanks arnelgp, I try it, I am sorry, but it freeze !

Thanks arnelgp for your answer, There is a problem : Hello missinglinq, If I do not put this command, the desired tab does not open. Sendkeys "{NUMLOCK}", True is not working

Hello, I read the subject: "https://www.access-programmers.co.uk/forums/threads/activating-a-tab-in-a-navigation-subform.316476/". I have a problem with the opening of my form, the desired tab is activated. : The problem comes from Sendkeys, he activates the Num Lock key or disables it...

Thanks arnelpgp, all is good. A last thing, can you explain me : [Tempvars]![tvarLongCompteFK]

Thanks You very much to you two. Pat Hartman, I will try later your solution. Arnelgp, your solution is very good, just a little problem : Compte: FindBracket([Categorie]) And I don't find any function in french about FindBracket. If was to replace : DansChaîne(1;[Categorie];"[") ??? I...

Hello, I have a form that works perfectly: "f Operation". I'm trying to create a navigation form: "_f_Navigation", I can't do it. If I remove the condition from the "r_OperationSansCumul" query, the navigation form will start, but the account choice field will no longer work...

Thanks Aenelgp for your help, again it was perfect and exactly what I wanted. Happy New Year to you 🙂

I'm looking tomorrow, thank you and have a good New Year's Eve.

There was an error in the "f_Courant" form. I modify the queries, indeed I had changed a table name and this name did not follow in all the queries. I compact and repair. I reposted the new file. Thank you for your remark.

Hello jdraw When I want to change the category I have the message : Maybe we have to break the links ? Then, I want the link to take place and the subcategory to appear with the corresponding links (see f_SousCat) Here, nothing appears ! And that the modification is only in the table t_Courant

Hello, Despite the help of arnelgp, I still have just as much problem with dropdowns (not the ones where it occurred). I would like to modify a record in the f_CurrentNouveau form, but that the t_Categorie and t_SubCat tables are not modified (just to draw). I would like to create a record of...

Thank you both very much for your invaluable help. (y) I answer after a certain delay because I try to understand the process, even for a few lines of code I spend a lot of time. I saw, among other things, that there was a query created, a modified text zone as well as the linked columns and the...

Hello, arnelgp made me a great code for, when I select a name in a list, On another list, the selection only gives me part of the corresponding list. (see code of t_SousCat). I want to do the same thing with the t_CompleteNouveau form but I'm doing it wrong and I can't. Could you redo this part...

Thank you arnelgp, that's exactly what I wanted, you guessed my wishes. Now do I need to create a new topic to check for duplicates in the subcategory (linked with the corresponding category). thank you cabete for your example.

Thanks to you two. I am picky and I apologize, I want a mixed of 2. Starting from that of arnelgp as a base, I want that by clicking in the lst_Categories list, the lst_CategoriesSousCat list is updated like that of theDBguy. I copied the code, but it doesn't work. Private Sub...

Thanks theDBguy but it does not.

Hello, Can we sort the drop-down list: lst_CategoriesSousCat in alphabetical order Thank you for your precious help.