VBA - GET / SET ??

A display name is just a way to differentiate different posters - unless you
use one of the special codes. MS and MSFT in these groups means Microsoft
personnel, MVP means it's an MVP posting.

You're drawing attention to yourself to be evaluated as an MVP when you put
it in your display name. Ok I see you didn't know that but people in other
groups do, particularly ones who disrupt the groups because it's a group
about Microsoft products and they hate Microsoft, they hate MVPs, they hate
people who use Microsoft products. They do whatever they can to disrupt, and
insults to MVPs are their primary weapon.

Chris
Microsoft MVP


MVP - WannaB wrote:
OH Chris, I regret that you misunderstand me, and I mean no offense. My
display name actually tells everyone that I wish I were bright enough to be
an MVP and that I admire and respect all MVPs such that I strive to be as
good as they already are. While I am hurt that you misunderstand my intent,
I do understand that everyone has there own interpretation of what they read.
I will consider a display name that show the admiration that I truly have
for all MVP's who have achieved such a level of accomplishment.

As for your thought that "my post implies MVPs are clueless" That is the
last thing that I intend to imply and I would not waste my time to post such
rubble.

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

This brings up a question I have had about your MVP designation. I cannot
find your name listed at mvps.org, at least not as Chris O'C.

"Chris O'C via AccessMonster.com" u29189@uwe wrote in message
news:8c589ddb2c7c6@uwe...
I don't mind aspirations. If they aspire to be an MVP they can put it in
the
text of the post.

The display name is a big neon sign that says "Look at me!" They're
drawing
attention to themselves to make sure they're not missed for an MVP award
evaluation when they put MVP in the display name on posts.

You think it's coincidence so many MVPs put MVP in their display names
when
they post? It's so they can be identified easily with the neon sign.

Chris
Microsoft MVP


vbasean wrote:

I know you worked hard for your MVP and rightly so but have you concidered
that his handle implies that he 'aspires' to be an MVP one day. Which
would
be flattery instead of insult...

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

"MVP - WannaB" wrote in message
...
OH Chris, I regret that you misunderstand me, and I mean no offense. My
display name actually tells everyone that I wish I were bright enough to
be
an MVP and that I admire and respect all MVPs such that I strive to be as
good as they already are. While I am hurt that you misunderstand my
intent,
I do understand that everyone has there own interpretation of what they
read.
I will consider a display name that show the admiration that I truly have
for all MVP's who have achieved such a level of accomplishment.

As for your thought that "my post implies MVPs are clueless" That is the
last thing that I intend to imply and I would not waste my time to post
such
rubble.


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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks Cliff, that's very helpful - I have too many meeting this afternoon,
but will use what you've provided here and post my results or more questions
as soon as I can.
1. Lbound and Ubound values are required.
2. The TAB order is set so they should go through each field sequentialy,
but they can jump around.
3. All rows are preset, no additional rows will(SHOULD) be added, this is
only to allow modifications to a table that is used to rank results from
another field in another table. and there is far too much already in place
to change the structure of what is currently in use.
THANK YOU SO MUCH!!!
=======================================
"Clif McIrvin" wrote:

"MVP - WannaB" wrote in message
...
Hello, I'm not sure that subject line is exactly right for this but in
my
head it sounded close.
I have a form with 4 columns of data (ID, Lbound, Ubound, and
Description).
There are 11 rows of data that a user can modify, and because Lbound
in every
row needs to be the same as Ubound of the previous row I would like to
GET
the value of Ubound for each row and SET the value of Lbound. So the
user
only needs to enter or modify the value for Ubound and the
description. Is
GET and SET the right functions to use or am I getting VBA mixed up
with VB?
And can someone start me in the right direction to accomplish this?
Thanks
for your help in advance. I truly appreciate all your help and still
hope to
be able to help others one of these days.



In VBA GET and SET relate to properties of class objects --- different
subject altogether. (In the VBA editor, type class module into the help
search and have fun reading! Some developers write class modules, others
don't, from what I hear.)

Are the Lbound and Ubound values required?

Can the user 'jump around' in the 11 rows? That is, can you guarantee
that the user will always progress sequentially through the rows? In my
experience that's generally a bad assumption.

Assuming an initial data entry environment where the user always
proceeds sequentially 'down' the form something along these lines:

In the form (or Ubound control) AfterUpdate event set the default value
for Lbound [assuming that the next row hasn't been added to the table
yet.]

ctlLbound.DefaultValue = ctlUbound.Value

(DefultValue is always a string --- in some situations you need to
handle the data type conversion yourself.)

If the 11 rows are already present in the table the default value won't
help you. In this situation you can use the form's Current event to set
the Lbound value. I have also used the form's Before Insert event
instead of the current event so that I only modify a control's value if
the user begins typing a value into any control; the Current event will
fire anytime the current record pointer changes for any reason.

HTH
--
Clif
Still learning Access 2003

Clif,
I apologize for Chris. I did not read it that way at all.
Also, understand there is some doubt whether he actually is an MVP. He
claims he works for a company where in would frowned on for him to known as
an MVP and therefore does not allow his profile to be published. That is
legitimate. You can hide your information so it is known only to Microsoft,
but that is very rare indeed.

There has been discussion in the MVP private newgroups as to who he is and
whether is claim to be an MVP is real or not. He does not appear in the
private MVP sites that I know of. Notice he doesn't say in what disipline he
received his award.

So the bottom line is, take his comments with a grain of salt. He is
knowledgable and often helpful, but occasionally goes a bit off tilt now and
then.

"Clif McIrvin" wrote in message
...
"Chris O'C via AccessMonster.com" u29189@uwe wrote in message
news:8c586103c8cc2@uwe...
Are you intentionally trying to insult MVPs? You've succeeded. "MVP
WannaB"
as a display name says to everybody "My skills are at MVP level, so
please
evaluate me for the award".

Your post implies MVPs are clueless and don't know what get and set are
for,
don't know they shouldn't use reserved words for column names, and don't
know
that sorting data in a certain order requires an order by clause in the
query.



Chris, I disagree. I've never interpreted WannaB's display name that way;
rather as a future goal that is being worked toward.

--
Clif
Still learning Access 2003

My MVP profile isn't public because my company would find out I'm an MVP.
I'd quickly lose my job because of the hostilities other MVPs caused, though
I had nothing to do with them. Guilty by association.

But there's easy proof of who's an MVP. Only MVPs can log in with their MVP
Windows Live ID and post with a blue MVP icon next to their names on
Microsoft's site. You can see Jerry Whittle, Chris O'C, Tom Wickerath and
Larry Linson with official blue MVP icons next to our names in our posts in
these threads:

http://www.microsoft.com/office/comm...xp=&sloc=en-us


http://www.microsoft.com/office/comm...b-c95f48917f15


My boss hates MVPs, but even if an employee wasn't an MVP and said about
another employee "take his comments with a grain of salt. He is knowledgable
and often helpful, but occasionally goes a bit off tilt now and then", he'd
fire him immediately. Why? Because it undermines trust and goodwill between
colleagues and isn't professional behavior.

Chris
Microsoft MVP


Klatuu wrote:
Clif,
I apologize for Chris. I did not read it that way at all.
Also, understand there is some doubt whether he actually is an MVP. He
claims he works for a company where in would frowned on for him to known as
an MVP and therefore does not allow his profile to be published. That is
legitimate. You can hide your information so it is known only to Microsoft,
but that is very rare indeed.

There has been discussion in the MVP private newgroups as to who he is and
whether is claim to be an MVP is real or not. He does not appear in the
private MVP sites that I know of. Notice he doesn't say in what disipline he
received his award.

So the bottom line is, take his comments with a grain of salt. He is
knowledgable and often helpful, but occasionally goes a bit off tilt now and
then.

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

I don't have a website. Mvps.org lists websites of current and former MVPs.

Chris
Microsoft MVP


BruceM wrote:
This brings up a question I have had about your MVP designation. I cannot
find your name listed at mvps.org, at least not as Chris O'C.

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

"Klatuu" wrote in message
...
snip

So the bottom line is, take his comments with a grain of salt. He is
knowledgable and often helpful, but occasionally goes a bit off tilt
now and then.

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

--
Clif
Still learning Access 2003

Only about 1 in 7 MVPs posts in the private groups. One reason is because we
can't post from the web. You can't claim someone isn't an MVP who doesn't
post in the private groups when most of us don't post there.

Does it matter what disciplines I'm an expert in when I post correct answers
in these groups? No, only correct and helpful answers matter.

Chris
Microsoft MVP


Klatuu wrote:

He does not appear in the
private MVP sites that I know of. Notice he doesn't say in what disipline he
received his award.

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

OK. I expect you understand the reason such questions arise is that your
MVP designation is by your word alone.

"Chris O'C via AccessMonster.com" u29189@uwe wrote in message
news:8c59d94d79a40@uwe...
I don't have a website. Mvps.org lists websites of current and former
MVPs.

Chris
Microsoft MVP


BruceM wrote:
This brings up a question I have had about your MVP designation. I cannot
find your name listed at mvps.org, at least not as Chris O'C.

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