[AccessD] Another Trick Needed

[Rocky Smolin]

Got it. WIll have a look tomorrow.

Thanks

r

On Tue, Jan 23, 2024 at 3:05 PM Darren - Active Billing <
darren at activebilling.com.au> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>