I have a function library written in VB as a module in an access .mdb database. Since all my databases call these functions (such as computing month ending date, generating correct date format) quite often in Access sql queries
I would like to create a DLL library so that all my Access database can use the function in queries without setting reference for each individual database. Also if possible I would like to use the functions in Excel spreadsheet as well.
What I am hoping for is that, after I register myLib.dll and set reference to it in Access, I can do the following in all my Access databases:
from myDatabase md
where functionFromMyLib (md.date) > 0
Please give me some advice on how to accomplish this. I would really appreciate it.