?
Solved

default values for properties.

Posted on 2002-03-06
2
Medium Priority
?
226 Views
Last Modified: 2013-11-23
I'm sure this is really easy, but I'm not totally up on my VB knowledge, so would liek to know how I can declare lots of global variables, give them aa default values, and then have LET/ GET property declarations to override the defaults?

This is what I have so far:

Dim mProdCode As String
Dim mItemName As String
Dim mManufacturer As Integer
Dim mCollection As Integer
Dim mCategory As Integer
Dim mMaterial As Integer
Dim mCurrPage As Integer

Public Property Get ProdCode() As String
    ProdCode = mProdCode
End Property

Public Property Let ProdCode(ByVal vNewValue As String)
    mProdCode = vNewValue
End Property

Public Property Get ItemName() As String
    ItemName = mItemName
End Property

Public Property Let ItemName(ByVal vNewValue As String)
    mItemName = vNewValue
End Property

Public Property Get Manufacturer() As Integer
    Manufacturer = mManufacturer
End Property

Public Property Let Manufacturer(ByVal vNewValue As Integer)
    mManufacturer = vNewValue
End Property

Public Property Get Collection() As Integer
    Collection = mCollection
End Property

Public Property Let Collection(ByVal vNewValue As Integer)
    mCollection = vNewValue
End Property

Public Property Get Category() As Integer
    Category = mCategory
End Property

Public Property Let Category(ByVal vNewValue As Integer)
    mCategory = vNewValue
End Property

Public Property Get Material() As Integer
    Material = mMaterial
End Property

Public Property Let Material(ByVal vNewValue As Integer)
    mMaterial = vNewValue
End Property

Public Property Get CurrPage() As Integer
    CurrPage = mCurrPage
End Property

Public Property Let CurrPage(ByVal vNewValue As Integer)
    mCurrPage = vNewValue
End Property

I've had a look at stuff on Constructors, but can't see this applying to this, as ultimately this will be a COM object.
0
Comment
Question by:AlfaNoMore
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Author Comment

by:AlfaNoMore
ID: 6844466
I HATE THAT!!!!

Just posted this question, and IMMEDIATELY found the solution!!!

Private Sub Class_Initialize()
   mvarValue = 0
End Sub

I'll get this deleted then...
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 6844509
Don't hate it, it's great.  You posted a question and added the solution, this could help others.  I refunded the 50 points to you and will move to the PAQ at zero points to close it.

Thanks,

Moondancer
EE Moderator
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question