[AccessD] Another Trick Needed

[Darren - Active Billing]

sample sent off-line to rockysmolin2 at gmail.com

darren


----------------------------------------

> On 24 Jan 2024, at 9:42 am, Rocky Smolin <rockysmolin2 at gmail.com> wrote:
> 
> Darren, Ryan, Paul, and Jim:
> 
> Thank you for the leads. I've got some thinking to do here. I will get back
> when I 1) have a solution, 2) reach all dead ends.
> 
> Thanks again.
> 
> r
> 
> On Tue, Jan 23, 2024 at 2:37 PM Darren - Active Billing <
> darren at activebilling.com.au> wrote:
> 
>> in a post last week I mentioned the TabBlank thing I do. It’s precisely
>> for times like this.
>> 
>> If a user clicks on a formatted text box (That must remain enabled) that I
>> use under a check box for check box highlighting, they simply end up at
>> this TabBlank control.
>> 
>> I bind the formatted field to the same field the check box is bound too.
>> 
>> So no code or trickery needed - as soon as the check box is ticked, the
>> formatted field underneath goes green or red
>> 
>> When I do clickable "a to z" and "z to a" sorts on header labels, it’s
>> always on specific fields; and thus all other field values should just
>> 'follow along'.
>> 
>> if you are sorting on say the value of that CheckBox, the formatted fields
>> should just 'follow along'
>> 
>> Is that not what’s happening here?
>> 
>> DArren
>> 
>> --------------------
>> 
>>> On 24 Jan 2024, at 4:33 am, Rocky Smolin <rockysmolin2 at gmail.com> wrote:
>>> 
>>> Dear List:
>>> 
>>> This is not a requirement by the client - just an 'it would be nice
>> if...'
>>> and I'd like to find a way to do it.
>>> 
>>> I have a continuous form with three checkboxes on it. The checkboxes are
>>> bound to fields in a table. The client requested that if a certain
>>> CONDITION applied to any of the three that somehow that checkbox would be
>>> made to stand out or be identified visually.
>>> 
>>> Because conditional formatting cannot be used  on a checkbox, I put a box
>>> behind the checkbox with borders a little larger than the checkbox. I
>> then
>>> used conditional formatting on the box behind the checkbox. If the
>> checkbox
>>> CONDITION is TRUE then the box backcolor is turned red so that the
>> checkbox
>>> appears to have a red border.  If the CONDITION is FALSE then the
>>> backcolor of the box behind the check box is the same as the backcolor of
>>> the detail section.
>>> 
>>> The client was delighted.
>>> 
>>> For a couple of weeks. Then he asked for a tweak.
>>> 
>>> On this continuous form I have labels at the top of each field. Like many
>>> of my continuous forms, I put some code in the click event of the label
>>> which sorts the column ascending.  Another click - descending. Client
>> loves
>>> that feature.
>>> 
>>> But now, when he clicks the label at the top of one of the three
>>> checkboxes, all the boxes WITH checks sort together either at the top or
>>> bottom of that column. But even though the checkboxes checked TRUE are
>> all
>>> grouped together, the ones with the red border are not. They are
>> sprinkled
>>> randomly along the list of checked boxes.
>>> 
>>> So what he asked for was to have the checkboxes marked TREU WITH the red
>>> border sorted together, followed by the checkboxes marked TRUE without
>> the
>>> border.
>>> 
>>> I puzzled over this for quite a while but cannot figure out a way to do
>> it.
>>> 
>>> Any ideas?
>>> 
>>> As I say, the client is delighted with the program - 'lives and dies by
>> it'
>>> he says (which is gratifying) - so I get no points off if I can't do
>> this.
>>> 
>>> MMTIA,
>>> 
>>> Rocky
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> https://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>> 
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com