Re: Sharing VB Classes with Other Databases (Alex Dybenko)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Problem is the Classes are not available. I don't know how to apply
Attribute suggestion you mentioned. Maybe it would help maybe it

Apparently it doesn't work in 2003. So it should work in 2002,
but you may wish to reconsider your use of classes.

(david)


"Mark" <Mark@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D1AC489B-3D37-4749-BDBB-672E2D095ECF@xxxxxxxxxxxxxxxx
Alex -

After playing a bit I am able to "see" the modules in DB2. We were able
to
see the modules without using the Attribute suggestion.

Problem is the Classes are not available. I don't know how to apply the
Attribute suggestion you mentioned. Maybe it would help maybe it wouldn't
don't know.

Any other suggestions would be welcome.

Thanks, Mark

"Alex Dybenko" wrote:

Hi Mark,
I am not so familiar with classes in library mde, but AFAIR - you have to
do
some tricks in order to have it visible. Look here:
http://alexdyb.blogspot.com/2005/01/how-to-hide-procedure-in-library-mde.html

I think you have to set:
Attribute VB_Exposed = True
using method in a link provided

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"Mark" <Mark@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A79DA1B6-E87C-46F8-BB6A-E53D86C8265A@xxxxxxxxxxxxxxxx
Alex -

Upon further review...

I was able to set the reference to DB2 from DB1.

The Explorer window shows DB2 project and there it shows up under
"References" as a "Reference to DB2.mdb" in the DB1project also in the
Explorer window.

So that looks great. By all indications the reference is set.

However, when I go to dim a class or module from DB2 they don't show up
in
DB1.

So:
dim obj as DB2.myclass
set obj = new DB2.myclass

It gives me a "User Defined type not defined" error.

FYI, I tried setting a reference to the Northwind - which was
successful.
The "Northwind" reference shows up in the object window. DB2 does
not.

I'm using Access 2002, if that makes a difference.

Any suggestions?

Thanks again, Mark





.

Relevant Pages

  • Re: Sharing VB Classes with Other Databases (Alex Dybenko)
    ... I was able to set the reference to DB2 from DB1. ... The Explorer window shows DB2 project and there it shows up under ... I tried setting a reference to the Northwind - which was successful. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sharing VB Classes with Other Databases (Alex Dybenko)
    ... "Alex Dybenko" wrote: ... After playing a bit I am able to "see" the modules in DB2. ... I was able to set the reference to DB2 from DB1. ... The Explorer window shows DB2 project and there it shows up under ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sharing VB Classes with Other Databases (Alex Dybenko)
    ... After playing a bit I am able to "see" the modules in DB2. ... Attribute suggestion you mentioned. ... "Alex Dybenko" wrote: ... I was able to set the reference to DB2 from DB1. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Funky error loading form
    ... I first followed your suggestion, ad that did not resolve the issue, but it ... After your suggestion didn't work, ... I added a reference, and successfully inserted the control into a new form. ...
    (microsoft.public.vb.controls)
  • Re: Sharing VB Classes with Other Databases (Alex Dybenko)
    ... Mark, if you plan to build some kind of library for classes and functions - I would recommend you to consider using VB6 activex dll - this works fine in any access version ... After playing a bit I am able to "see" the modules in DB2. ... "Alex Dybenko" wrote: ... By all indications the reference is set. ...
    (microsoft.public.access.modulesdaovba)