If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
VBA - GET / SET ??
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 |
#13
|
|||
|
|||
VBA - GET / SET ??
"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) |
#14
|
|||
|
|||
VBA - GET / SET ??
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 |
#15
|
|||
|
|||
VBA - GET / SET ??
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 |
#16
|
|||
|
|||
VBA - GET / SET ??
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 |
#17
|
|||
|
|||
VBA - GET / SET ??
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 |
#18
|
|||
|
|||
VBA - GET / SET ??
"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 |
#19
|
|||
|
|||
VBA - GET / SET ??
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 |
#20
|
|||
|
|||
VBA - GET / SET ??
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 |
Thread Tools | |
Display Modes | |
|
|