Is there any way to call a function in another mdb file?

[Guest]

Hi, all
I met rather a large mdb file, and want to deduce the size of it. All the
tables are linked from outside. This mdb filesize is almost 1GB after
"compact database".
Now the only thing I want to do is move the "Module"s out of this mdb
file. But these "Module" codes are invoked by the other VBA code. So, is
there any way to move them out and still make them invoked from outside?

thx

 

[Guest]

You can use reference from MDB1 to MDB2, so MDB1 will recognise all the
functions in MDB2.
Open MDB1, when you are in code, select tools, reference. browse and select
MDB2.
You will notice that MDB1 recognise all the functions, but it wont recognise
forms, reports, macros etc, so if for example you want to open a form in MDB2
From MDB1, create a function in MDB2 that open the form, and then call that
function from MDB1.

 

[Guest]

Terrific! Thank you very much for your help, Ofer

 

[michal peery]

hi
it can help me very very much if i'll find out how to call a function in
MDB2 from MDB1

10X
Michal

 

[PC Datasheet]

Dim AccessApp As Application
Dim PathToMDB2 As String
Set AccessApp = New Access.Application
AccessApp.OpenCurrentDatabase PathToMDB2
Call NameOfFunctionInMDB2

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

 

[StopThisAdvertising]

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
********************************************************

Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

Need a psychiatrist ...Contact me!

Arno R