You could set up an Access file as a code library and import the module into it, then export code from it when needed You can also have a compiled version of the library and set up a reference to it in the VBA. With a code library, the code needs to be generic. That sometimes takes a while to design and write but having a code library can prove to be a worthwhile investment of your time.
I'm looking for your thoughts on this, any help appreciated. I'm finding as I code more modules, I would like to re-use that little trick again. Rather than rely on my memory that may or not remember that I solved that problem in database xyz, I'd like to save code to be found at a later date. What I'm thinking is to copy the code into a OneNote page and give it a reasonable title. I'd be able to search OneNote and copy and paste it into my new database. Is there a slicker way to have a central code store? I'm using Office 2016.
Posted by: "Glenn Lloyd" <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (2)|