VBA - GET / SET ??

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.

You really don't need the 'LBound' field if it is the value from the previous
record. What you would need is a 'Ranked' query to pull the value.

http://blogs.conchango.com/jamespipe...n-a-query.aspx
--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud


"MVP - WannaB" wrote:

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.

"vbasean" wrote in message
...
You really don't need the 'LBound' field if it is the value from the
previous
record. What you would need is a 'Ranked' query to pull the value.


Chris, what is the value of Lbound in the first row? [Or, where does the
initial value come from?] Doesn't that tend to require storing the
value?

http://blogs.conchango.com/jamespipe...n-a-query.aspx

Thanks for that link --- I'm keeping that one!

remainder snipped

--
Clif
Still learning Access 2003

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


MVP - WannaB wrote:
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.

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

"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

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.

It's like if you're an American reading an online article, dollar signs will
catch your eye as currency, but yen signs probably won't. Yen doesn't mean
anything to you - but for those who can spend it, it means a lot.

Chris
Microsoft MVP


Clif McIrvin wrote:

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

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

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

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