Hmm, I use something simliar
Yes but never mind the possible separation as that is the least of the worries.I don't use a Code Library because I feel it's dangerous to add another level of possible separation. I like to keep all my code in one place so that there are no problems in moving from one machine to another
Thanks, I will follow up johnThats a new one for me U.G.
I've always used MZ tools for simple procedures and my own code locker for more complex stuff.
This may be a lot easier than having to open a second DB to get code.
I think I'll spend the morning looping through my code locker to export them to text files.
nks.You might want to consider an alternative to having a Library Database.
I don't use a Code Library because I feel it's dangerous to add another level of possible separation. I like to keep all my code in one place so that there are no problems in moving from one machine to another. However this does lead to the problem of how to manage/store my custom code? where do I keep it?
There is a very handy feature available to VBA programmers and it's the "Insert File" menu option. It's a builtin feature of, I suspect all Microsoft VBA utilising products.
MS Access provides a folder which is accessed quickly and easily through the — >>>Insert >>>File — menu. This menu is shown when you are in the VBA interface. When you open it, you have access to this folder. You can have subfolders in any/all of those folders. You can have text files containing your code, Code Modules, Code Snippets, Class Modules, Anything Textual you Want! Clicking on any of the text files automatically copies the contents of that text file straight into your Code/Class Module. Follow this link to my website to see a YouTube explaining "Insert File":-