VBA - GET / SET ??

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


"Klatuu" wrote:

Normally I do see the MVP logo, but I don't see any on the link you provide.
I do see some in the second thread. Your name appears two different ways -
with and without. That indicates you log on from different locations.

I made it very plain I don't know if you are or are not, it is just that
there is a lot of doubt.

Put yourself in my shoes. What's the fastest way for my boss to accidentally
find out I'm an MVP and fire me because of it? Post my name, highest area of
expertise, and "Microsoft MVP" in posts on the net. The MVPs my boss has a
problem with would find those posts with a search engine and email my boss
with the evidence and "Did you know Chris is an MVP?" Anybody in my company
could do the same thing.

I'd be smart to avoid that. Posting with Anonymous, Microsoft
"fillintheblank" MVP has less credibility than "mypartialname", which has
less credibility than "mypartialname", Microsoft MVP.

So you see why I don't have any good choices if I want to keep my job and
help people publicly.

Access *is* one of my areas of expertise or I wouldn't post answers here. I
can't tell Microsoft "Please make me an Access MVP because I'd like that
better than any other designation you decide". I have to demonstrate
competence in Access in the majority of my contributions in the past year.

Chris
Microsoft MVP


BruceM wrote:
Yes, I finally found some postings with the icon. I am still curious as to
why he refuses to say in what area he received the MVP designation. By
identifying himself as an MVP here he suggests this is his area of
expertise. In a sense I suppose the discipline doesn't matter if the
answers are helpful, as they often are, but even so I find the retricence
rather curious.

--
Message posted via http://www.accessmonster.com

Dave, telling somebody they're out of line is fine, but announcing publicly -
and repeatedly - they're a kook comes under "personal attacks". We'd do well
to follow Dirk Goldgar's and Tony Toews's examples by stating opinions and
not adding personal attacks.

Chris
Microsoft MVP


Klatuu wrote:

I also said in my post you are knowledgeable and usually helpful, but in
this case I stand by my statement that you are out of line. It is not the
first time I have seen you go weird for no apparent reason.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

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
Microsoft MVP


Clif McIrvin wrote:

It seems to me that I have seen his sig in other forums that I lurk in;
and as here, his posts generally seem helpful and on target. Also, like
Klatuu, there have been posts that simply leave me scratching my head
and wondering, "Where did *that* come from?"

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

"Chris O'C via AccessMonster.com" wrote in message:
news:8c58acc6f63dc@uwe...

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

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

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. Leave the personal attacks out.

Chris
Microsoft MVP


Klatuu wrote:

I also said in my post you are knowledgeable and usually helpful, but in
this case I stand by my statement that you are out of line.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

Thanks for joining the thread, Jeff.

I wasn't originally selected for the MVP award from my group participation
either, so I know first hand it's not impossible to be awarded without MVP in
your display name.

Microsoft has tools for measuring posters' previous participation in
Microsoft communities and they work best when MVP is put in the display name.
That's why Microsoft leads requested we put MVP in the displayname. It's not
required, it's just easier for them to get accurate measurements.

Microsoft awards those who contribute to the Microsoft community regardless
of whether they would receive the award. In other words, the recipients of
the award contribute to the Microsoft community in spite of the award. They
don't expect it. OTH, those who only contribute in order to earn the MVP
award have been frowned on for many years and often get bypassed. Telling
others they aspire to become MVPs usually makes it harder to become an MVP.

Even if leads tell you they're not looking at self proclaimed MVP wannabees,
some still are.

Chris
Microsoft MVP


Jeff Conrad [MSFT] wrote:

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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

"MVP - WannaB" wrote in message
...
Hello and again Thank you very much for any assistance you can
provide.

snip

======================
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.


--
Clif
Still learning Access 2003

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.

"Chris O'C via AccessMonster.com" u29189@uwe wrote in message
news:8c6d24577cbfc@uwe...
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. Leave the personal attacks out.

Chris
Microsoft MVP


Klatuu wrote:

I also said in my post you are knowledgeable and usually helpful, but in
this case I stand by my statement that you are out of line.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

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.

"Clif McIrvin" wrote in message
...
"MVP - WannaB" wrote in message
...
Hello and again Thank you very much for any assistance you can provide.

snip

======================
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.


--
Clif
Still learning Access 2003