How to set up a code library?

[Jesse Aviles]

I have gathered a lot of code from the web and some that I made and placed them on various text
files or left them in their databases. I got tired of trying to find some code that I barely
remembered were it was located and decided that I can just write a database to make a code library.
After the library is done I would like to reference to it as an Access Add-in. Unfortunately,
Access offers no help in making an add-in. I recently used a treeview control to navigate through a
hierarchy of components and I think that a control like it will be nice to go through code
classifications and I have an idea on how to make such a library database. Any pointers on how to
make the library and then use it as an add-in? TIA

 

[Paul Overway]

There is some information for creating an add-in here:

http://tinyurl.com/4rl7k

Library databases don't need to be add-ins though, nor do they need the
UsysRegInfo table. You just need to compile the library and add a reference
to your other project. However, you should know that if you recompile a
library database referenced by other projects that the other projects will
need to be recompiled too. Also, you'll need to add a registry entry under
RefLibPaths, i.e.,

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\RefLibPaths]
@=""
"LibraryA.MDE"="C:\\Program Files\\Library\\LibraryA.MDE"

The registry key allows Access to find the referenced file.

 

[Arvin Meyer]

These 3 articles may help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;153858

http://support.microsoft.com/kb/143270/EN-US/

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/usysregacc2k.asp

I have gathered a lot of code from the web and some that I made and placed them on various text
files or left them in their databases. I got tired of trying to find some code that I barely
remembered were it was located and decided that I can just write a

database to make a code library.

 

[Arvin Meyer]

These 3 articles may help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;153858

http://support.microsoft.com/kb/143270/EN-US/

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/usysregacc2k.asp

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I have gathered a lot of code from the web and some that I made and placed them on various text
files or left them in their databases. I got tired of trying to find some code that I barely
remembered were it was located and decided that I can just write a

database to make a code library.

 

[Jesse Aviles]

Thank you. Ill review them later today.