If you can't find it, Javier, I know I saved it in my notes somewhere, because it was a good "trick"! I forgot all about it.
Karen -----Original Message----- From: Javier Valencia <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, Mar 5, 2015 6:08 pm Subject: [RBASE-L] - Re: negative highlighted in scrolling region Jim, I know exactly what you want and I do have solution that makes the background of the entire row on the scrolling region red or whatever color you want; actually, you can have as many colors as you want depending on values. Once Enhanced Grids became available I switched to those and what you need can be easily done there. I will see if I can find an old form with a scrolling region that has that feature and prepare a sample for you. I know I have sent samples before on this subject so I will look this evening in my old e-mails and maybe it is ready to go. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, March 05, 2015 3:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region That may be the way I need to go but I would rather have a way the guilty row itself would be pointed out. Thanks for the suggestions. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Thursday, March 05, 2015 3:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region You could design form expressions modelled like what I had below and locate the variables on the row, maybe in bold red. Variable labels have the ability to blink, so you could add that too! Karen -----Original Message----- From: Jim Belisle <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Thu, Mar 5, 2015 3:23 pm Subject: [RBASE-L] - Re: negative highlighted in scrolling region Karen, I have been away from the computer for a while. What I want is if any of the rows, not just the focused row, are negative then: 1) A warning box would come up. I have this completed. 2) The cursor focuses on the detail section. I have this completed. 3) The offending row in the scrolling region would do something to get the attention of the user. Number three is what I need. It would be great if the cursor would not only jump to the detail section but to the offending row. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]>] From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Karen Tellef Sent: Wednesday, March 04, 2015 4:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region When I have to do something like that, I try to use a form variable since they are evaluated only for the focused row. Would it be good enough to put a red variable with the word "negative" or 2 red parenthesis around the field if it is negative? Something like: set var vNegText = (IFLT(column, 0, 'NEGATIVE', ' ')) Karen -----Original Message----- From: Jim Belisle <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]?>>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]?>>> Sent: Wed, Mar 4, 2015 4:15 pm Subject: [RBASE-L] - negative highlighted in scrolling region Scrolling region with a variable vemptime that calculates the time for a process. The driving table of this form is different than the scrolling region. Sometimes when importing into this table, the times are messed up and this var becomes negative. (The variable is based on the punch in punch out times). My code shows a PAUSE clause then forces the cursor into the scrolling region if the punch out time is less than the punch in time. What I want now is the offending var field to change color because it is negative. Since there are multiple rows and many of them will be fine, I only want to var field that is negative to change. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]?>>]
