Linking to a VBA Function

[RayMilhon]

If I have an Access 2010 Database with several Functions in VBA can I link to those modules from other Access Databases and get access to the function.



For example we have a calculation for per 1000 variables (Admits, ER's, Beddays) The calculations are in a number of different Access Databases. I would like to create a Database with a module and put the calculation in the new database and be able to run it from those different databases. That way if the formula changes I only have to change it once and not have to go through every Database We have in production and modify the formula in each one. These formula's don't change often but when they do it's a major effort to fix them.

[June7]

Bing: Access public function another database

http://www.tek-tips.com/viewthread.cfm?qid=669161