Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

User Defined Data Type, Like Boolean but with three options

Posted on 2011-03-20
3
Medium Priority
?
414 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
[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
3 Comments
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 375 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

636 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