I started this years (and years) ago - How do you create a code library add in?
Background:
Currently BE is SQLSE, 2 FEs - one for daily stuff (reports, single entry, looking up info) and the other FE for importing monthly data from CSV files.
One CSV file could/would be around 4,000 lines, another CSV file could/would be up to 30,000 lines
I have two FEs that have a lot of code that is common to both. So I am make changes to one FE and don't get the changes copied to the other FE. I am getting real tired of having to try and find the changes that I missed. There was a tool (VBA Code Compare) that would compare the code from both FEs, but right now it still only works with mdb files. An update is in the works, but unknown at this time when the update will be completed.
What little I remember is that , in A97/A2K, you could create a dB (.mda) with the common code, go to the IDE add in manager and add the dB to both FEs.
Tada! Code only had to be modified in one place.
But it doesn't seem to function the same way in the new dB format (accdb).
Any pointers, info, examples???