VBA - GET / SET ??

[Tony Toews [MVP]]

For what it's worth, it never occurred to me to take any offense at your
usage, nor that it might be seen as anything but a sign of aspiration and
(maybe) shameless flattery. <g> I can see where Chris's concerns are coming
from, but I don't feel the same way.

Agreed.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Chris O''C]

Sorry, you've been posting so many years from Microsoft's site, I didn't
think I should give you instructions in case you thought I was talking down
to you. Click on the plus sign at the left of each thread to expand it and
show all the posts. Then drag the right edge of the center column (the part
with the posters' names and dates showing) further to the right so you can
see the full names and Microsoft's icons.

When you click on the blue MVP icon next to my name, it opens a page that
says this:

"What are Most Valuable Professionals (MVPs)?
Microsoft MVPs are also identified with an icon. These are individuals who
have received the MVP award for their positive impact in the technical and
product communities they participate in. They are viewed by their peers and
by Microsoft as credible experts who provide accurate technical answers while
sharing a common passion for technology.

MVPs are individuals from around the globe recognized by Microsoft for their
demonstrated technical expertise and active participation in Microsoft
peer-to-peer communities like discussion groups and message boards. These
individuals represent a wide variety of backgrounds and professions, but they
share the basic characteristics of having very strong technical skills in one
or more Microsoft products or technology areas and the willingness to share
that knowledge with others. MVPs are recognized for their past contributions
to one or more online communities and many times are also prominent authors,
developers, industry "gurus" or speakers.

The enthusiasm of the MVPs combined with their positive contributions
exemplifies the spirit of strong communities."

Is that enough proof for you that I'm an MVP? If not please state why you
think the blue MVP icon on my post on Microsoft's site doesn't prove I signed
in with my MVP account on Microsoft's site to post this message.

Most of the time I post using accessmonster.com because they're web based
and keep track of my posts and the responses. I don't usually post using
Microsoft's site because it doesn't work well with Firefox, doesn't keep
track of my threads, can only send me emails notifying me of responses (which
is bad for me because I move from pc to pc), and often doesn't work when I
need it to.

Chris
Microsoft MVP

 

[Jeff Conrad [MSFT]]

in message:

People who evaluate MVPs look for the MVP in the display name. You're not
evaluating MVPs so it doesn't have the same significance to you.

Chris, I will have to respectfully disagree with that assessment. A great deal of MVPs do not put
MVP in their display name. There are other MVPs that never even post to newsgroups; I personally
know one person.

Also, when Microsoft evaluates potential candidates that have *never* been awarded MVP, how would it
even be possible to evaluate them on having MVP in their display name? That scenario makes
absolutely no sense.

I personally took no offense to the OP's display name. I actually chuckled at first because I
suspected, as noted else where in the thread, that it was a sign of aspiration.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Clif McIrvin]

Hello and again Thank you very much for any assistance you can
provide.

======================
Private Sub Ubound_LostFocus()

<snip>

I'd recommend against using LostFocus in this context. You can lose
focus for many reasons having nothing to do with changing data in the
control.

From the code you posted, I suggest using the control's AfterUpdate
event to set a 'UboundChanged' flag, and the form's AfterUpdate event to
execute the code you currently have here. This way, you only update the
other record when changes are committed to the database, not before.

 

[Klatuu]

My response to you was because of your personal attack. Since you are never
in the private groups, I have no way to communicate with you outside the
public groups. I think it was Tony, but I can't remember for sure. But you
also launched a rather ugly attack on another MVP for no apparent reason.

Because Jeff joined the thread, I believe, indeed, you are an MVP. But,
given the history of the discussions, I did have reason to doubt it. You
know full well there are those who claim certifications they do not have.

I repsonded because I thought your attack was particularly vicious based on
the OP's post.

Thanks for the bit on clicking on the icon. That I was not aware of.

Peace be with you.

 

[Klatuu]

The Lost Focus event will fire when you navigate away from the control
whether you make any modification to the control's value.

The way to look at which event to use is
1. If you need to do something every time the control is left, use the
LostFocus.

2. If you need to only take action when a change has been made to the
control's value, use the After Update.

 

[Klatuu]

I doubt I am interested in taking the time to find and read all your posts.
I think if you took the time to read all mine, you would find a few where I
also was out of line. Doug Steele once told me so

I think my comments in this thread are sufficient for "fixing things"

I respect your knowledge and participation.

 

[MVP - WannaB]

I must comment on one statement here "they're not looking at self proclaimed
MVP wannabees" There is a big difference between a self proclaimed MVP and a
self proclaimed MVP wannab. I would never, never proclaim myself an MVP.
But to proclaim myself a wannab of anything simply say's that I acknowledge
that I am not good enough to hold that title. Any time I have used the term
wannab in referring to anyone else it was not to say that they could be, but
just the opposite.
==================================

 

[BruceM]

Seems to me this started with your taking offense where nobody else
perceived a slight.

The reason you get inquiries about your MVP status is because it is
enigmatic. When asked you explain the reasons there is no mention of you on
the public MVP sites, but still decline to say in what area or discipline
you received the MVP designation. It leaves me wondering why.

 

[Klatuu]

Cool down, Chris.
First I didn't see the post to which you refer.
Secondly, that had nothing to do with it. You posted a heated response to a
technial opinion.

I actually prefer using the web to access the groups, but where I work, I
got hammered for too much time on the web, so I use nntp to avoid detection.

 

[Clif McIrvin]

In the interest of fixing things that are wrong, please list links to
my
posts outside this thread where you think I was out of line. If you
think
somebody is out of line, I think it's important to say something
instead of
being quiet. Others might poke a searing hot needle in your eye for
criticizing them, but I won't.

Chris, I'm confused.

Are you suggesting I reply outside the forum? If so, I'm not clueing in
on how to do so.

Or are you merely suggesting starting a new thread?

 

[vbasean]

does the work 'Highjack' come to mind when you see this thread...?

 

[David W. Fenton]

Seems to me this started with your taking offense where nobody
else perceived a slight.

I've stayed out of this discussion thus far, but I'd like to add a
somewhat different perspective.

I've in the past criticized Chris for not using his real name. I
understand his situation, but think that it's the kind of situation
I'd want to get myself out of, and thus don't think it reflects well
upon him. I also suspected him of being an imposter, but he's
demonstrated to other MVPs that he's not.

All that said, I perceived the wannabee's posts exactly the same way
Chris did -- as posted with an intent to deceive. We've had too many
encounters with people like Don Mellon and Aaron Kempf to be
comfortable with those who stick MVP in their username for no good
reason.

Chris is a good contributor to these forums. He has something of a
temper, but who am I to criticize *that*? Good lord, I'm worse than
Chris in that respect! And we *all* get bent of shape every now and
again over things that, with a bit of perspective, look like not so
big a deal after all.

I think everyone should chill out here for a while. Chris has
recognized that the poster he orginally criticized is actually
sincere and not aiming to deceive, so I just don't see what benefit
there is in drawing out the rest of this discussion.

But perhaps others *do* see benefit, so I will probably killfile the
thread so I won't be bothered by it in the future.

Perhaps others might do the same.

 

[David W. Fenton]

I really don't intend to take the time to look up any previous
posts.

Then you should really retract the accusation that you're unwilling
to back up.

 

[Klatuu]

yes, incoherent. It was actually two comments that got wrapped together.
What I was trying to say was:
1. I would prefer to have private discussions in the private group, but
since you are seldom if ever there, I don't know if that will work.

2. As I said previously, I am not sure it was even Tony, but you did post an
attack on another MVP in the public groups. I posted the reference in a
previous post.

I promise, in the future, to eschew obfuscation.

I wasn't referring to a post. I asked what Tony did and then guessed he
accepted proof I was an MVP. Here's your statement:

"Since you are never in the private groups, I have no way to communicate
with
you outside the public groups. I think it was Tony, but I can't remember
for
sure. But you also launched a rather ugly attack on another MVP for no
apparent reason."

You didn't make it clear what you were talking about that Tony did when I
asked you for links to my posts where you thought I was out of line. If
it
helps, your paragraph above was in response to my previous post:

In the interest of fixing things that are wrong, please list links to my
posts outside this thread where you think I was out of line. If you
think
somebody is out of line, I think it's important to say something instead
of
being quiet.

This is probably one of those times where you were writing, got a phone
call,
came back and wrote some more and posted, not realizing part of what you
wrote was an incomplete thought. Happens to me more than I'd care to
admit.

Chris
Microsoft MVP

I didn't see the post to which you refer.

You "think it was Tony"? What did Tony do? Did he say he thought I was
an

[quoted text clipped - 13 lines]

in the private groups, I have no way to communicate with you outside the
public groups. I think it was Tony, but I can't remember for sure.

 

[Klatuu]

Point well taken, David.

I can understand the consternation over the MVP in the name, but I read it
differently. When I see people wearing a Dallas Cowboys jersy with a number
9 on it, I don't assume it is someone claiming to be Tony Romo, I see it as
someone who admires him.

 

[Klatuu]

Have you not seen that I use nntp for the groups?
You don't the the icons there.

I have already stated I now believe you to be an MVP and have apologized for
not knowing that.

As to admitting anything, I have not. It is only that I don't have the time
to read back over a couple years of posts in multiple groups.

I have not made any accusations. I have only stated observed fact.
Over last few posts I have been trying to settle our difference. You
totally ignore anything I have said postive about you and want to focus on
one statement.

So, to wrap it up:
1. You are an MVP
2. You provide a lot of good knowledgable assistance to people on this
sites.
3. You flamed an OP for no good reason based on your misunderstanding of the
purpose of his name and you owe him an apology for that.
4. I stand by my statement that you ocassionally flame people. Some times
it is justified and some times it is not.

 

[Clif McIrvin]

Please don't start a new thread. Keep the info all together here in
this
thread for archive purposes. Please post links to my posts where you
think I
was out of line, other than in this thread. I think you've mistaken
me for
somebody else and gave me credit for their posts.

Chris, I believe what I was thinking of may have been in this thread:
http://tinyurl.com/5rxtdj

 

[Clif McIrvin]

If you don't take the time to present evidence for your accusations,
for all
we know you're mistaking me for somebody else. Without evidence, your
accusations are false claims, intended to defame me and give me a
negative
image. Look up the definition of libel, then look at Clif McIrvin's
responses to your posts in this thread to see if he believes the
negative
image you presented of me.

Chris, read my post again. I was expressing an opinion I had formed
independently, and was simply expressing agreement with his statement:

Thanks, <snip>, for the additional explanation. I've noticed a bit of
that myself.

As vbasean mentioned, "hijack" comes to mind --- we've likely carried
this on way too far.

Chris, there is no doubt at all in my mind that you are quite
knowledgeable, and you certainly contribute many good and helpful
answers in this and other forums.

<my opinion> While I applaud your admonitions to keep discussions
professional and leave 'personal attacks' out, it seems to me that you
often confuse "observed occurrence", "conclusion drawn", "opinion
stated" as a personal attack. </my opinion>

I intend to say no more on this matter in this thread.

With your leave (which I believe you have invited) I may well respond to
such posts that I may see in the future.

 

[Clif McIrvin]

Getting Tom's attention away from the troll and focusing on me instead
may
have saved Tom's life. Goading Tom to continue thrashing the troll
wasn't
wise, even though it was a popular pastime in that thread.

Chris, thank you for the explanation. I'm quite willing to accept this
at face value -- it makes perfect sense to me.