Call a function from .mde

[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.

 

[Marshall Barton]

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?

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.

 

[Tim]

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 Overway]

See http://www.mvps.org/access/modules/mdl0034.htm

 

[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.

 

[Marshall Barton]

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?

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]

 

[Tim]

Marsh,

Thanks.

Tim.

-----Original Message-----

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?

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

test.mdb.

.