[AccessD] Conditional Formatting

[Rocky Smolin]

Been nice knowing you Bill 😁

On Mon, May 10, 2021 at 6:32 AM Bill Benson <bensonforums at gmail.com> wrote:

> Oh ok I get what you meant now! I get tunnel vision. Thanks for the
> response Rocky.
>
> On Mon, May 10, 2021 at 9:26 AM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
>
> > More than once I have found the answer to a problem by trying to describe
> > and document it completely. So when you asked "What is your conditional
> > check looking for?  What exactly is the check?' I set to work detailing
> it,
> > looking at the code, etc. I think others on the list have had the same
> > experience.  It' one of the downsides of working alone - you have a
> problem
> > and you can't just walk around the corner and ask your friend in the next
> > cubicle who may not know the answer bus asks a question for clarity and
> > that leads to the solution.
> >
> > I'm mostly retired - only have 2-3 active clients left and they give me
> > just enough work to be fun. But without AccessD over the last - what is
> it,
> > 25 years or so? -  it would have been/be a lot harder.
> >
> > r
> > On Mon, May 10, 2021 at 4:49 AM Bill Benson <bensonforums at gmail.com>
> > wrote:
> >
> > > How did knowing us, as opposed to knowing a fact about requery, help
> > here?
> > > :)
> > >
> > > On Fri, May 7, 2021 at 4:35 PM Rocky Smolin <rockysmolin2 at gmail.com>
> > > wrote:
> > >
> > > > It's not what you know - it's who you know.  And I know you all! 😀
> > > >
> > > > r
> > > >
> > > > On Fri, May 7, 2021 at 12:23 PM Charlotte Foust <
> > > charlotte.foust at gmail.com
> > > > >
> > > > wrote:
> > > >
> > > > > Timing is everything! ;)
> > > > > Charlotte Foust
> > > > > (916) 206-4336
> > > > >
> > > > >
> > > > > On Fri, May 7, 2021 at 10:47 AM Rocky Smolin <
> rockysmolin2 at gmail.com
> > >
> > > > > wrote:
> > > > >
> > > > > > Got it! In the process of going through the steps to document for
> > > you,
> > > > I
> > > > > > tried putting the requery call in the modal/popup form and walla!
> > It
> > > > > > worked.
> > > > > >
> > > > > > The conditional rule is checking the value of another text box on
> > the
> > > > > form
> > > > > > that has the value of the number of comments (in a child table)
> for
> > > the
> > > > > > record that has the focus.  The box is a field in the query that
> is
> > > the
> > > > > > recordsource for the form and is invisible.  But I've made it
> > visible
> > > > for
> > > > > > debug purposes to confirm that it has either a 0 (no comment
> > record)
> > > > or 1
> > > > > > (has a comment record).  The condition
> > > > > > is: [CountOffldTenantLeaseStepID]<>0.  When I delete the comment,
> > and
> > > > > close
> > > > > > the form, the number of comments stays at 1.  I thought the code
> > > would
> > > > > stop
> > > > > > executing while the modal form was open but it didn't. Sp my
> > requery
> > > in
> > > > > the
> > > > > > calling form was being executed before the modal form closed.
> > > > > >
> > > > > > So moving the Requery of the calling form to the modal form
> solved
> > > it!
> > > > > >
> > > > > > Thank you.
> > > > > >
> > > > > > r
> > > > > >
> > > > > > TIA
> > > > > >
> > > > > > rocky
> > > > > >
> > > > > >
> > > > > > On Fri, May 7, 2021 at 10:16 AM Jim Dettman via AccessD <
> > > > > > accessd at databaseadvisors.com> wrote:
> > > > > >
> > > > > > > Rocky,
> > > > > > >
> > > > > > >  What is your conditional check looking for?  What exactly is
> the
> > > > > check?
> > > > > > >
> > > > > > > Jim.
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: AccessD On Behalf Of Rocky Smolin
> > > > > > > Sent: Friday, May 7, 2021 11:29 AM
> > > > > > > To: Access Developers discussion and problem solving
> > > > > > > <accessd at databaseadvisors.com>; Off Topic <
> > > > dba-ot at databaseadvisors.com
> > > > > >
> > > > > > > Subject: [AccessD] Conditional Formatting
> > > > > > >
> > > > > > > Dear list(s)
> > > > > > >
> > > > > > > I have a text box with an asterisk in it on a continuous form.
> > > When
> > > > > the
> > > > > > > user clicks the box a modal/ pop-up form opens and the user can
> > > > enter a
> > > > > > > comment in a memo field which is linked to the parent recordset
> > by
> > > > > PK/FK.
> > > > > > >
> > > > > > > I have conditional formatting set so that if there is a comment
> > for
> > > > > that
> > > > > > > particular record the backcolor of the asterisk box turns red -
> > if
> > > no
> > > > > > > record the backcolor is white.  This is so the user can see
> which
> > > > > records
> > > > > > > on the form have comments attached to them.
> > > > > > >
> > > > > > > This works fine when I open the parent form - the asterisk box
> > for
> > > > all
> > > > > > the
> > > > > > > records which have comments are backgrounded red, those without
> > > > > comments
> > > > > > > are white.
> > > > > > >
> > > > > > > The problem is that when I add a comment to a record that
> didn't
> > > have
> > > > > one
> > > > > > > the asterisk box does not turn red when the modal/popup form
> > > closes.
> > > > > And
> > > > > > > when I delete the comment so that the record has no comment,
> the
> > > > > > background
> > > > > > > color of the asterisk box does not turn from red to white.
> > > > > > >
> > > > > > > Exiting the form and re-entering it again show the right
> > conditions
> > > > for
> > > > > > > each record on the form.
> > > > > > >
> > > > > > > So the conditional formatting is not being triggered except
> when
> > > the
> > > > > form
> > > > > > > opens.  I have tried requery, refresh, and repaint but no
> cigar.
> > > > > > >
> > > > > > > *Does anyone know how to refresh the conditional formatting of
> > > fields
> > > > > on
> > > > > > a
> > > > > > > form while it's open?*
> > > > > > >
> > > > > > > MTIA
> > > > > > >
> > > > > > > Rockty
> > >
> > >
> > --
> > 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
>