I had done something similar a good while back, but I was having problems that
when I changed the var in one row it would change the others as well behind the scenes.. and since the form wasn't updated it didn't work well. I gave up on
this, but if I remember right I had column - .var and the checkbox was a var.
I will look into your methods.. thank you for your persistance..
Jim Limburg
Victor Timmons wrote:
Ok here is what i came up. I know it can be done in 7.0 but I had a need in 6.5++. Here is what I came up with. It really just a look alike checkbox but i thought it was kind of a cool method
Type 1 = Putting a check box inside the region on the form
1. Add a extra column to the table that the region is based off of
2. Create a matching var by adding a var to form
a. vHwVar2 = HwVar2
3. Put that var inside the regions and use these properties and some a. No border
b. 3-D on
c. Font WindDings size 10
d. Size the Column to look square
4. Go to your start button - Run - type CHARMAP change the font to wingdings and find a char that works for you a. I used � that puts a nice little x in the var. You could also use � which a nice little check mark on the var. Play with it you will find what you like
5. Add an eep to the "on entry into:" part of the var a.WCheck.EEP USING 1
6. Click edit and and some code like this
SET VAR vCheck = .%1 IF vCheck = 1 THEN IF vHwVar2 IS NULL THEN SET VAR vHwVar2 = '�' UPDATE CustomerRMA SET + HWVar2 = .vHWVar2 + WHERE ??????????? ELSE SET VAR vHwVar2 = NULL UPDATE CustomerRMA SET + HWVar2 = .vHWVar2 + WHERE ??????????? ENDIF GOTO DONE ENDIF
LABEL Done RECALC VARIABLES SKIP TO vHwTxt SAVEROW
7. Now you can program using the results just like a real checkbox.
--------------------------------------------------------------------------------
Type 2 = Form with region but need a checkbox outside the region.
1. Creat the form with 2 tables 1 with real data and 1 dummy table 2. Create var's to hold the check box based on the the dummy table or create global var's when entering the form
3. Put the var's on the form with these properties a. No border b. 3-D on c. Font WindDings size 10 d. Size the var to look square
4. Go to your start button - Run - type CHARMAP change the font to wingdings and find a char that works for you a. I used � that puts a nice little x in the var. You could also use � which a nice little check mark on the var
5. Add an eep to the "on entry into:" part of the var a.WCheck.EEP USING 1
6. Click edit and and some code like this
SET VAR vCheck = .%1 IF vCheck = 1 THEN SET VAR vHwVar2 = '�' GOTO DONE ENDIF
IF vCheck = 2 THEN SET VAR vHwOr = '�' SET VAR vHwAnd = NULL GOTO DONE ENDIF
IF vCheck = 3 THEN SET VAR vHwOr = NULL SET VAR vHwAnd = '�' GOTO DONE ENDIF
LABEL Done RECALC VARIABLES SKIP TO vHwTxt SAVEROW
RETURN
7. Now you can program using the results just like a real checkbox.
On 1 Nov 2003 at 8:22, Sami Aaron wrote:
Can't be done in that version - but you can in 7.0.
Sami ----------------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 mailto:[EMAIL PROTECTED] 913-915-1971
----- Original Message ----- From: "Victor Timmons" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 6:19 PM
Subject: [RBASE-L] - Checkboxes on form with a region
Look for a way to put a checkbox on form with a region in rbase 6.5++ for windows
Victor Timmons Tiz's Door Sales, Inc 425-258-2391
Victor Timmons Tiz's Door Sales, Inc 425-258-2391
