Solved

User Defined Data Type, Like Boolean but with three options

Posted on 2011-03-20
3
356 Views
Last Modified: 2012-05-11
Here are some easy points for someone, I'm sure.

I want to decalre a new datatype to operate like Boolean does, but I need three options instead of two.

Public Type LogOpt
    'The three options are:
       1. OpenNow (integer value 1)
       2. CloseNow (integer value 2)
       3. OpenCloseNow (integer value 3)
End Type

What is code to Declare this user defined data type?

Cheers.
0
Comment
Question by:Carl Sudholz
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 125 total points
Comment Utility
Enum Statement
Declares a type for an enumeration.

Syntax
[Public | Private] Enum name
membername [= constantexpression]
membername [= constantexpression]
. . .
End Enum
0
 

Author Closing Comment

by:Carl Sudholz
Comment Utility
Provided the Syntax of for Enumeration which made me think a bit.  But probably a better solution becuase I learned more.
0
 

Author Comment

by:Carl Sudholz
Comment Utility
Thats what I was looking for.

Thanks
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

728 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now