MDB Code Not Seeing MDE In Reference

[Gary]

I have a MDB database with a form which has vba code. There is a variable
defined in my original VBA Code which I have moved over to a MDE database
that just has most of my VBA Code. That variable was declared in there.

I created an experiment where I separated all of the Modules to another
database and created an MDE.

The MDB doesn't have any of the Modules. I have a dummy module in the MDB
for reference linking. I open the module and reference my VBA Mde database
as its reference.

When I debug my mdb database, I have a parameter in a form (which still has
vba code that reference my vba modules). It doesn't see that parameter.

Can someone please help.

Thank You,

Gary

 

[Gary]

2nd Question:

I can duplicate the declaration in the mdb database. Then No declaration
errors.
Do I need to do the declaration in the mdb???

Here is the 2nd question: I have a function used in a form within the mdb
database. I got an error because it didn't see that function. That function
is in my mde database and that mde database is referenced by the mdb database.

What is the error occuring??

Thanks,

Gary

 

[Klatuu]

Gary,
I think you got lost in the woods somewhere. You should have all your code
working and compiling without errors in the mdb. Then create the mde from
the mdb. There is no readable code in an mde. It is stripped out leaving
only compiled code. That is to avoid someone modfiying.