Install add-in with user defined functions

[F.H. van Zelm]

Hi,

Looking for an easy way to make user defined functions available for any mdb
to open in Access 2003.

I thought: create and mda, write VBA code and use Tools - Add-in Manager.
That doesn't work because of a USysRegInfo table ...?

Do I realy have to go through that 'misery' or is a simpler way?

Many thanks, Frans
www.fhvzelm.com

 

[Tony Toews [MVP]]

Looking for an easy way to make user defined functions available for any mdb
to open in Access 2003.

I thought: create and mda, write VBA code and use Tools - Add-in Manager.
That doesn't work because of a USysRegInfo table ...?

Do I realy have to go through that 'misery' or is a simpler way?

No, you don't need to use the USysRegInfo table if you are
distributing the user defined functions in a separate MDB/MDE along
with your own MDB/MDE. The UsysReginfo is more for if you have a
commercial add-in that will be installed on many systems in which you
don't have any control.

All you need to do is to set a reference to the MDB/MDE.

See my Add-in Tips, Hints and Gotchas page at
http://www.granite.ab.ca/access/addins.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[F.H. van Zelm]

Hi Tony,

Thanks for reply. There were little responses so I got a little worried ;-).

I followed your advice to set a reference in B.mdb to A.mdb that contains
the UDF. It works fine. (And I visited your site: quit nice.)
Now I open C.mdb, try to use de UDF ... No go (of cource).

Although my code is not 'commercial', I want to have it available in any
Access database that I use on my computer.

Please don't tell me the USysRegInfo table is the only way. If it is: what's
the best way to set it up. Or, if available: a hint to a simpler solution.