Recent content by Superpat

Thanks Colin, I only work on personal files, I don't sell or redistribute them. I do this to try and get my brain working. Also, given my age, I no longer feel like investing in paid software. Thanks to you, I've managed to improve my functions and in my Add-in, I've put in the module header...

Thank you, a Titan's work :)

Thanks for your answers, so I'll continue with copy/paste. I'll switch to solved.

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 :)

Thank you very much, I'll work with it.

Ok, I'll use your method, which I thought was better... I've got a form that I've put in the Add-in and which I use to list the modules, then the functions, and I can't open it because, with my open function, I only open the modules and not the form sheet, so it can't find it. I found : Private...

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've tried the Add-In for the last 2 days, it's very good, it allows me to use the menu bar I've created. I didn't quite understand how the Add-Ins kept the menu bar operational, it doesn't have its own code, we just moved “Public Sub BrandNewBarAndButton()” into the Add-In. Secondary...

Exactly, I was using Mz-Tools 3.0, but with the Access updates, it's no longer valid, so to pass the time, I thought, why not? I certainly don't have your qualifications, but I'm enjoying myself... right down to the problems I don't master. Thanks for the links Thanks

Thank you very much for all these answers which helped me in the progress of my project. Access vba offers a lot of resources that I haven't gotten around to yet and probably never will... :)

It work perfectly for me, thanks you very much. What is the point of making an add-in (I have never made one) ? Could we do everything in the same project

Thanks @GPGeorge , I try it before and with your "Cleanup", but that don't works. And I saw my message ! Cleanup: BrandNewBarAndButton Debug.Print "passé sur Cleanup InsererEnTeteTitreModule" Exit Sub End Sub I have windows 11 Access version 16-18324.

No, It does'not ! Curious, curious... I try also that : ' Insérer l'en-tête au début du module CodeMod.InsertLines 1, strHeader MsgBox "En-tête inséré avec succès dans le module '" & vbComp.Name & "'.", vbInformation, "Succès" 'Add BrandNewBarAndButton End Sub But...

Thanks for your reply :) For me, it deactivates every time, even with the modification. Curious !