?Link to enternal modules?

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
Mark said:
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?
Click to expand...

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.
 
Back
Top