Search results

Hello, When I open my VBA editor from an accdb file and when I have a link with an accda add-in file, if I modify my add-in file, I can't save it, even if I close the accdb file first. I have to copy/paste, close everything and reopen the add-in to be able to save ! Do you have a function or a...

Hello, I would like to increase the undo capability of the VBA editor. Is this possible? Have a nice day :)

Hello, I have a problem calling a procedure from an add-in to a main file. Sub InsererTeteTitreModule() Dim sCheminProjet As String sCheminProjet = TrouverTag() If sCheminProjet <> "" Then Application.Run sCheminProjet & "InsererEnTeteTitreModule"...

Hello, I created a toolbar in my VBA editor, it has 3 buttons, including one to send an MSGBOX box (Coucou) which works from any module. Another button to insert a module header when I click on this button, the function runs, does its job, but after the buttons are disabled! I suspect the...

Hello, It's a strange question, I can easily do it another way, but I'm curious and want to know if it's possible to do it my way. When I type in execution mode :DoCmd.OpenForm "_f_Principal", acDesign Or, when in a module, I have : Sub commande3() DoCmd.OpenForm "_f_Principal", acDesign End Sub...

Hello, I want, in my buttons, center text in image and have picture who stay in left. If I put blank space before, it's no use ! How I can do that ? Thanks to answer.

Hello, I want to list Add-In Manager dialog box and know is some elements are activate. After, Activate and desactivate, here for VBA MZ-Tools . Thanks to help

Hello and Happy Holidays. I have an error 2516 telling me : Access cannot find the module "Form_formulaire2". The code should not be correct, but I don't know how to correct it. You have to click on Error in Form 2, then Déboguer. The error is on line 55. Precision, the subform is not a...

Hello, I am helped with: http://access.mvps.org/accessfr/apis/api0029.htm And I made my code : Sub lister() Dim x As Long Dim y As Long Dim sSelection As String Dim sSelection1 As String sSelection1 = "" y = 0 On Error GoTo fin For x = 1 To...

Hello, I have create a query, name "Requête2" : SELECT DISTINCT tblVariables.NomBase FROM tblVariables; And In my vba code, I write : Dim lCompte As Long lCompte = DCount("*", "Requête2") This code is right, and it give me the number of different NomBase. Can I do the same with just vba code ?

Hello, I have a form with two combobox. The combobox, lst_NomBase SELECT DISTINCT [NomBase] FROM tblVariables UNION SELECT " Tous" AS NomBase FROM tblVariables ORDER BY tblVariables.[NomBase]; Private Sub lst_NomBase_AfterUpdate() Dim sNewvar As Variant If Me.lst_NomBase = "...

Hello, I have two options to list module name : The first list only the current module of the database, the second can list module outside of the database open. Is there a solution to list the current module or an exterior module with the same code. Public Sub listSubFuncVBA10(PathBase As...

Hello, in a module NumForm, I try to send a combinaison of keys to another module or a form, my form here is form_f_equilibrage . The code is +^M (Smart Indent) to indent a module. It is possible to do that ? Thank for your help Sub essaiBoucle1() Dim wshshell As Object Dim...

Hello, I have this code who is good, but I don't know how to modify to go directy to my form (strNomModule) and modify this "For Each oComponent In Application.VBE.ActiveVBProject.VBComponents" Function RechercheIntituleModForm(ByVal sSearchTerm As String, strNomModule As String) Dim...

Hello Ihave this error, expected table : : my code : Function fnDmwListAllModulesDeroulantes(lComptageModules As String) As String ' Liste les tables dans le fichier "t_ListeDeroulante dans t_OperationSauvegarde_SuperPatrickCourant_28/02/2002 'On Error GoTo errHandler...

Hello, I hope that during a click on the combo box "Conseiller", only those concerning the name in "Dénomination" be selected. The content of Conseiller : SELECT t_BANQUE.ID_BanquePK, [Nom] & " " & [Prenom] AS NomPrenom, t_BANQUE.Denomination FROM t_BANQUE RIGHT JOIN t_Conseiller ON...

Hello, Is it possible to have the description of a monitor? Or at least just the name of the monitor. Thank you for your help

Hello, It's still me and I'm sorry. I want to focus a form that has already been expanded using the Mendip Data Systems code. I saw that there were "Gettopoffset / Getleftoffset" functions to focus the forms. But of course, after 50 tests I'm still so bad and I cannot do there. Could you help...

Hello, I want to adapt a form to my different screens. I can adapt the controls but not the screens. I join a zip file. Only the form f_operation interests me. I tried the code on the drop-down list box: "Lst_ChoixEcran". The opening form is "_f_Navigation". Nothing happens to change the...

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...