run function in different MS access database file

[mygmat123]

I need to run a function from another database file I have, the function returns a value. What would be the code that wuld reference the file/module/function? Thank you

 

[SiJP]

mygmat ... I understand what you are trying to do, however I don't beleive this is possible (kind of like using the function as you would from a DLL..)

What I'd suggest doing is important the function required into your db, and linking the data you need to run the function against. This way the objects are run locally.

------------------------
Hit any User to continue

 

[mygmat123]

I really wanted to prevent doing that. But if that's the only way, I'll have to. Though I thought I remember learning that you could, and I just did not remember how.

thanks

 

[SiJP]

There may well be!! I'd be interested to hear if it can

------------------------
Hit any User to continue

 

[PJStephenson]

You can reference other databases through the Tools/References menu, Click on Browse then change 'Files of Type' to MDB. You can then browse to your access database and use any of the public functions.
HTH
Peter

 

[mygmat123]

Thank you both, I added the reference AND Linked the Tables

It works great!