[AccessD] Sharing Class Modules in Acc 97

John Colby jcolby at colbyconsulting.com
Wed Oct 22 17:05:09 CDT 2003


yes, there is.  One "undocumented" method is to

1) Export the class module to a text file (extension .txt).

2 look for the following at the top of the text file:

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
END
Attribute VB_Name = "clsMyClassName"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False

3) Set

Attribute VB_Creatable = False

to

Attribute VB_Creatable = True

4) Set

Attribute VB_Exposed = False

to

Attribute VB_Exposed = True

5) Save the text file

6) Open the library
7) Click Insert / Class from the file menu
8) The code IDE will open
9) Click Insert / File from the file menu.  Find the file using the file
find browser and select it.

10) The text will be inserted inside of your class.
11) Compile and fix the compile errors.
12) Save the class.

You should now be able to "see" the classes from a FE that references your
library, use intellisense on it etc.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
Drawbridge.Jack at ic.gc.ca
Sent: Wednesday, October 22, 2003 5:39 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Sharing Class Modules in Acc 97


Is there a way to store Class Modules in a "Library" database or some
mechanism such that you can see the Class Modules from any database? I'm
using Acc97.

jack

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list