How can I reuse functions in other databases?

[snowsride]

How can I use some custom functions I have created in other databases? I have tried saving as .mda file and then installing as an Add In but this is only partially successful because although the functions can be used they do not appear in the Expression Builder so the user has to know they exist and what form they take.

I am totally confused about Add Ins. It seems I can open a module and then use Tools, Reference and search and install them or, when not in a module use Tools, Add Ins and install them. I think the functionality of the two options differ but I can't figure out what they are.

When trying to resolve the problem of sharing functions in other mdb's, by trial and error, I did once get the custom functions displayed in the Expression Builder but after further tinkering about I lost them and don't know how to get them back.

I have looked in the MS Knowledge Base and several forums and there is mention of the USysRegInfo table settings but it seems only to apply to Wizards, Builders and Menu Add Ins and my simple functions are none of these - I think.

I would like to have the functions load every time I open Access and would like to share the functions with others.

Please help.

Thanks

 

[pcs]

you may be asking a question that is way beyond my expertise as i don't create wizards, builders, activex controls, etc.

are you talking about custom public functions that you have written and placed in a module?

al

 

[R. Hicks]

I usually just "Import" the needed modules into the app.

I keep a .mdb file that contains nothing but Modules and sample code. When I need a specific function in a module, I import it into the app and alter it to fit my situation.

HTH
RDH

 

[pcs]

rdh,

that was i was going to suggest... it just seemed too simple

al

 

[R. Hicks]

LOL .... today is Saturday and all that comes to mind is "simple solutions".

Hopefully I will not encounter something too intricate .... :-(

RDH

 

[snowsride]

Thanks everyone. I do mean custom public functions. I was hoping it may be possible to store the functions in a public folder and then use them in any open database.

Anyone know anything about Add Ins?