Call a function from .mde

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi everyone,

I have two database files. One is called test.mdb and the
other is function.mde. Both of them are saved on a shared
drive.

Is possible to call a function in function.mde from
test.mdb? How?

Thanks in advance.

Tim.
 
Tim said:
I have two database files. One is called test.mdb and the
other is function.mde. Both of them are saved on a shared
drive.

Is possible to call a function in function.mde from
test.mdb? How?
Click to expand...


In test.mdb, you can set a Reference (Tools menu) to
function.mde. Then all the Public functions and Subs in
standard modules can be used as if they were in test.mdb.
 
Marsh,

It works fine for public function but I also have a class
module in the DB. I couldn't call it from test.mdb Do
you have any idea how to fix it?

Thanks a lot.

Tim.
 
Paul,

I went to the site but it was not the way I look for. My
clase module was located in function.mde. I couldn't
export it to text file. Is there a way to call it?

Thanks.

Tim.
 
Tim said:
It works fine for public function but I also have a class
module in the DB. I couldn't call it from test.mdb Do
you have any idea how to fix it?
Click to expand...

Not without making some change to the original mdb file. If
you don't want to use the save as text, edit, load from
text, then the only other way I know of is to add a public
function to a standard module in the original mdb file that
can then be called to create and return an instance of the
class.
--
Marsh
MVP [MS Access]


 
Marsh,

Thanks.

Tim.
-----Original Message-----
Tim said:
It works fine for public function but I also have a class
module in the DB. I couldn't call it from test.mdb Do
you have any idea how to fix it?
Click to expand...

Not without making some change to the original mdb file. If
you don't want to use the save as text, edit, load from
text, then the only other way I know of is to add a public
function to a standard module in the original mdb file that
can then be called to create and return an instance of the
class.
--
Marsh
MVP [MS Access]


and
the
Click to expand...
test.mdb.

.
Click to expand...
 
Back
Top