How do you store your useful code? [Best Practice]

[Noob]

Hi,

In Excel I was told to make a PERSONAL workbook to store my useful code in for reuse. I have found that to be a great habit to get into. Now after doing that for years I have some code in there for just about anything & it has saved my bacon more than a few times. I am relatively new to Access, but beginning to write some useful code that could come in handy in the future. I did a quick search on Google & didn’t come-up with anything useful, so I figured why not ask the great folks here. What do you do to store your old Access code that can/will be useful in the future?

TIA



P.S. I am only on Chapter 3 of the Access 2010 Bible & haven't seen any mention of a PRESONAL DB. Maybe I am not deep enough into the book/bible just yet & it is forthcoming. If so I apologize for asking such a Noob question.

[ranman256]

You can explore the module to a file.
but I also keep an access db of all my tools.

[pbaldy]

I use MZ Tools, which has a code template feature. If I need a DAO recordset loop, the template code is a right-click away. I have 15-20 frequently used templates stored. It also has an error handler template, so adding error handling to any function/sub is a right-click away.

[Noob]

Thanks a lot guys for taking the time to read & reply. Thanks for the good advice I am going to play around with what’s been suggested & see what I come-up with.

Please feel free to continue share your processes or methods if they differ from the above mentioned. I am still curious. Plus this might be exactly what someone else is looking for in the future too.

TIA (Thanks in advance (My wife asked me what TIA was so... (lol...)))

[davegri]

I have some common routines that I frequently use in all databases I develop. I keep then all in a module named basUniversal in a database I call Universal. The module can be copied to new databases in a couple of clicks using the ribbon 'External Data'. This is kind of like the Excel Personal workbook.

[ssanfu]

I have a table with 3 fields:
Purpose - text - Purpose of code
Keyword - text (easier to search)
Code - Memo - the code.

A form to view, add and/or edit

Find the code, copy, then paste...............