Solved

User Defined Data Type, Like Boolean but with three options

Posted on 2011-03-20
3
386 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
ID: 35177072
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
ID: 35177104
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
ID: 35177107
Thats what I was looking for.

Thanks
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

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…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 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