|
Just a little follow-up on
this - I now have my bit button working properly, and when the user goes to the
sub category screen, I have a list box populated with the current
settings. I added 2 buttons for Add Sub Categories and Delete Sub
Categories and by playing around with the property commands, I can now hide the
add button if there are no more subcategories to add and hide the delete button
if no subcategories are defined! Of course, its taken me all day, but this
is just so cool! Thanks again for everyone's help. This list really
is a lifesaver. I can't tell you how many times I've referenced old emails
trying to figure out how to do something and I usually find the answers in
there!!!
Jan
----- Original Message -----
Sent: Wednesday, September 28, 2005 11:20
AM
Subject: [Norton AntiSpam] [RBG7-L] - Re:
Visible Bit Button
Jan,
Glad to be of help. I get a lot of great ideas from this
list and I really am getting in to the property command.
Heck my code now looks like a DIALOG here and there, throw
in a PAUSE, SET VAR or two, do some DECLARE CURSOR
and then a whole pile of PROPERTY commands.
Jan Johansen
----- Original Message -----
Sent: Wednesday, September 28, 2005
8:04 AM
Subject: [RBG7-L] - Re: Visible Bit
Button
Dawn and
Jan,
Thanks for your quick
responses! I'm still learning with the property commands and having
them set on the form itself did not refresh with each new record, but now
that I've added the command to the table settings, it works
beautifully! Thanks so much - you saved many a dent in my office
walls!!!!!
Jan
----- Original Message -----
Sent: Wednesday, September 28, 2005
10:45 AM
Subject: [Norton AntiSpam] [RBG7-L] -
Re: Visible Bit Button
Jan,
I have a few buttons that do this. But sometimes I
remember to turn them on but forget to turn them off again. Without seeing
the details of your eeps try this
SELECT COUNT(SubCategory) INTO vCount INDIC ivCount FROM
<TableName>
IF ivCount = 0 THEN
PROPERTY <bitbutton> VISIBLE
'TRUE'
ELSE
PROPERTY <bitbutton> VISIBLE
'FALSE'
ENDIF
Jan Johansen
----- Original Message -----
Sent: Wednesday, September 28, 2005
7:28 AM
Subject: [RBG7-L] - Visible Bit
Button
Hey
all!
I am setting up a
form for customers and depending on the category, they may or may not
have subcategories. When a category is selected that has
subcategories, a bit button appears for the user to select
subcategories, but if there are no subcategories, the bit button is
invisible. This worked until I added a DB Navigator bar.
Now, once a category that has subcategories is selected, the subcategory
button stays visible thru the rest of the records, even when there are
no subcategories. Am I missing some kind of a recalc var
somewhere? The form happens to be a tab form, and I have a recalc
var eep on tab change and also on the On After Start.
Thanks!
Jan
Barley
|
