[AccessD] OT Got it: Was... Rate for first time

Hi Virginia

> WOW! 1998, I can't believe it has been that long. I still feel so
> inexperienced. Have you ever gone back and looked at something you did when
> you first started - you think - I can't believe I did that! I remember
> printing the screen for reports & had the navigation buttons showing on the
> form when printed.

> Oh, hey, it has been more than a tiny part - I would say all of it! I can
> honestly say I never would have been able to do anything without everyone's
> help & patience.

> Just curious - what was my first question?

No, Virginia, not all. No matter what, the major part is your own time
and efforts.

This is the first message I have. There may have been others before
the 25. of October 1998. I joined the list July 1998:

<memories>

Hi Virginia,

> I have an attached table that uses numbers in the field to stand for
> certain classes, ex: 2=Quality, 4=NonSafety, etc. I use this data in
> a subform. 
> Is there any way to convert (or show) the numbers to their
> corresponding meaning instead of the numbers? I use this form in
> V2.0 and 97. 

If you only have a few values and these don't change, you could use
the function Switch() as a quick and not so dirty solution. Look in
the on-line help. 

In your case, if the number of the class is ClassID and your control
for display the description of the ClassID in the form is ClassText,
then in the form set ControlSource for ClassText to:

   
=Switch([ClassID]=1;"Something";[ClassID]=2;"Quality";[ClassID]=4;"NonSafety")

Put in pairs of values and text for all possible ClassIDs.

</memories>

I can add to this that I only recall to have used Switch() once.

/gustav


> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Wednesday, April 02, 2003 11:28 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] OT Got it: Was... Rate for first time


> Hi Virginia

>> Thank you! I am a bit nervous about doing it all. I think once I get into
>> it
>> I will calm down and it should start fitting together. Right now the whole
>> project seems so overwhelming.

>> I don't know what I would do without everyone's help and support. Thank
>> you so much!

> You are very welcome! Maybe we all added a tiny tiny part to your
> success (nice thought anyway)? In my nicely cleaned archive I located
> more than 100 messages addressed to you from numerous list members -
> the first message, by coincident, from myself in October 1998 in the
> days of the old list of MT Group!

> /gustav


>> Amazing! I'm so proud of your Virginia!!!! 

>> Susan H. 

>>> Congrats!!!
>>> 
>>> John W. Colby