How to Publish a Public Function (vb module) for use in other mdbs

[ChrisH]

Hi All,

I created a Public function in a particular mdb and I want to make it
available to other Access db's when running queries. How do I "publish" a
module so that it's available as a default whenever I open/create a new
database? Is there some sort of blank "template" db that it needs to go
into, or something else. Can't for the life of me find it in the VB Help
that goes with Access.

Thanks!

 

[Tom Wickerath]

Hi Chris,

Here you go:

Using Database Library Files in Your Access Application
http://www.vb123.com/toolshed/07_access/libraries.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Larry Linson]

You can include it in a separate database, which you make certain is
available (which may mean distributing with the database application) and
add that database to the references of the databases in which you want the
Public function to be available.

Larry Linson
Microsoft Office Access MVP

 

[david]

module so that it's available as a default whenever I open/create a new

That doesn't work any more. You would have to go back to A97
or version 2.0 to get that to work.

What you can do is

a) Manually add the database as a reference to every new database.
or
b) Automatically add an add-in menu item to every new database, so
that the VB function can be called from the add-in menu - not from
queries.

(david)