Search results

  1. Superpat

    List Add-In Manager dialog box and activate or desactivate

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

    Solved Code in subform which does not behave as in a form

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

    List all resolutions of a "secondary" screen

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

    Solved Replace query by vba code, with dcount

    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 ?
  5. Superpat

    Solved Synchronize 2 Combox

    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 = "...
  6. Superpat

    Solved List module name

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

    Solved Try to transmit a combination of keys to a module by sendkeys

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

    Solved Can I go directly to the module

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

    Solved Error expected table

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

    Combo box, criteria selection

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

    Solved Indicate Monitor Name

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

    Solved Centers a form

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

    Solved Resize Navigation Form

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

    Solved Activating a tab in a navigation, problem SendKeys

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

    Solved Problems with navigation form

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

    Solved Edit or create, problem with my drop-down lists

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

    Selection in the drop-down list corresponding to criterion (2)

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

    Selection in the drop-down list corresponding to criterion

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

    Hello

    I am retired, I live in France 🇫🇷 at Paris and in Dordogne. I try to done a personal accounting like Money. I am not a professional in Access but I manage. Hello to all of you 😊
Top Bottom