?Link to enternal modules?

[Mark]

Can a function, located in a Module in a different .mdb
be linked or called from another .mdb? If so, how?

e.g.
MydatabaseB contains a Module that has function
called ABC().

1) Can queries in MydatabaseA call ABC()? syntax?

2) Can Modules/routines in MydatabaseA call ABC()? syntax?


TIA,
Mark

 

[Dirk Goldgar]

Can a function, located in a Module in a different .mdb
be linked or called from another .mdb? If so, how?

e.g.
MydatabaseB contains a Module that has function
called ABC().

1) Can queries in MydatabaseA call ABC()? syntax?

2) Can Modules/routines in MydatabaseA call ABC()? syntax?

Yes, and yes, but you have to set a reference to MyDatabaseB in your
project References. You can use the Tools -> References... dialog in
the VB Editor to do this. Then the syntax is just the same as that for
any user-written function. You do have to watch out for name
collisions; that is, having two procedures with the same name. I
believe that you can resolve such collisions by qualifying the procedure
name with the name of the VBA Project containing it, but I don't
remember exactly.