Working With Class Modules

[Devlin]

I am working with class modules and have dedicated several to particular
tables in this DB project. I am calling some of the functions within the
class objects directly without creating a new instance of the class. I am a
beginner when it comes to working with class modules.

Here is an example. I have a class module called class_stores. In this
module I have a function: DBLookUpStoreID(sStoreName as String) as Long.

I will call on this function from forms or other modules to look up the
store ID for a particular store name (i.e. lStoreID =
class_stores.DBLookUpStoreID("Giant")).

Question: Is this acceptable, or is it necessary to create a new instance of
the class each time I want to access a function?

 

[Naresh Nichani MVP]

Hi:

In VBA you have to instantiate class when calling function in class.

If you have function and it does not "logically" belong to a class place it
a plain Module and you can call without instaniating Module.

Regards,

Naresh Nichani
Microsoft Access MVP

 

[david epsom dot com dot au]

To see previous answers to your question (posted in
Microsoft.public.access.formscoding), go to

http://groups.google.com/groups?q=microsoft.public.access

and search for "Working With Class Modules"

(david)