Smoothen screen update

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • John
    #1

    Smoothen screen update

    I have a calculated field on my form and after another field is updated I
    let its afterupdate event requery the calculation:

    Private Sub FM_AfterUpdate( )
    DoCmd.Echo False
    DoCmd.RunComman d acCmdSaveRecord
    NrOfMales.Reque ry
    DoCmd.Echo True
    End Sub

    At the moment the calculated field gets updated but while calculating the
    field shows no value (field is white). I'd like the field to move from the
    old value straight to the new value. I tried the DoCmd.Echo method but no
    luck.

    Any ideas on how to achieve this?
    Thanks,
    John


    Tags: None
    • Larry Linson
      #2
      Re: Smoothen screen update

      What is the calculation... and any pertinent information about the factors
      in that calculation? What's the purpose of turning Echo on and off -- did
      you try without it and see some effect you didn't like?

      Larry Linson
      Microsoft Office Access MVP

      "John" <john@smith.com wrote in message
      news:fqf0ok$19q c$1@textnews.wa nadoo.nl...
      >I have a calculated field on my form and after another field is updated I
      >let its afterupdate event requery the calculation:
      >
      Private Sub FM_AfterUpdate( )
      DoCmd.Echo False
      DoCmd.RunComman d acCmdSaveRecord
      NrOfMales.Reque ry
      DoCmd.Echo True
      End Sub
      >
      At the moment the calculated field gets updated but while calculating the
      field shows no value (field is white). I'd like the field to move from the
      old value straight to the new value. I tried the DoCmd.Echo method but no
      luck.
      >
      Any ideas on how to achieve this?
      Thanks,
      John
      >
      >

        Comment

        • John
          #3
          Re: Smoothen screen update

          Thanks for your reaction.

          The calculation is a simple Dcount with one criterium. What happens is when
          the requery takes place the original value in the field disappears, leaving
          the field blank for a short moment and then the newly calculated value
          becomes visible. With the echo I was trying to 'freeze' the screen so that
          the field moves straight from the old value to the new value without showing
          the blank state...

          John

          "Larry Linson" <bouncer@localh ost.notschreef in bericht
          news:KO4zj.1219 1$v47.8386@trnd dc08...
          What is the calculation... and any pertinent information about the factors
          in that calculation? What's the purpose of turning Echo on and off -- did
          you try without it and see some effect you didn't like?
          >
          Larry Linson
          Microsoft Office Access MVP
          >
          "John" <john@smith.com wrote in message
          news:fqf0ok$19q c$1@textnews.wa nadoo.nl...
          >>I have a calculated field on my form and after another field is updated I
          >>let its afterupdate event requery the calculation:
          >>
          >Private Sub FM_AfterUpdate( )
          >DoCmd.Echo False
          >DoCmd.RunComma nd acCmdSaveRecord
          >NrOfMales.Requ ery
          >DoCmd.Echo True
          >End Sub
          >>
          >At the moment the calculated field gets updated but while calculating the
          >field shows no value (field is white). I'd like the field to move from
          >the old value straight to the new value. I tried the DoCmd.Echo method
          >but no luck.
          >>
          >Any ideas on how to achieve this?
          >Thanks,
          >John
          >>
          >>
          >
          >

            Comment

            • Larry Linson
              #4
              Re: Smoothen screen update

              Perhaps my sensistivity to Controls momentarily blinking out is just lower,
              but neither I nor my users have felt it necessary to be concerned... there
              are enough (usually unavoidable, often undiagnosed as to cause) flashes and
              blinks in the Windows environment that an occasional additional one doesn't
              raise my stress-level.

              Of course, that does not answer your question. A DCount may make a number
              of disk accesses before it retrieves all the records necessary to complete,
              so yours may be a longer "blink" than even I could ignore.

              Unfortunately, I don't _have_ an answer for you. If it is, as it might be,
              that it is only when the Echo is reset to True that Access "needs" to
              execute the DCount, it may be a difficult issue to address.

              If someone else has a worthwhile suggestion, I'd be interested in seeing it,
              too.

              Larry Linson
              Microsoft Office Access MVP



              "John" <john@smith.com wrote in message
              news:fqjtsg$2tq n$1@textnews.wa nadoo.nl...
              Thanks for your reaction.
              >
              The calculation is a simple Dcount with one criterium. What happens is
              when the requery takes place the original value in the field disappears,
              leaving the field blank for a short moment and then the newly calculated
              value becomes visible. With the echo I was trying to 'freeze' the screen
              so that the field moves straight from the old value to the new value
              without showing the blank state...
              >
              John
              >
              "Larry Linson" <bouncer@localh ost.notschreef in bericht
              news:KO4zj.1219 1$v47.8386@trnd dc08...
              >What is the calculation... and any pertinent information about the
              >factors in that calculation? What's the purpose of turning Echo on and
              >off -- did you try without it and see some effect you didn't like?
              >>
              >Larry Linson
              >Microsoft Office Access MVP
              >>
              >"John" <john@smith.com wrote in message
              >news:fqf0ok$19 qc$1@textnews.w anadoo.nl...
              >>>I have a calculated field on my form and after another field is updated I
              >>>let its afterupdate event requery the calculation:
              >>>
              >>Private Sub FM_AfterUpdate( )
              >>DoCmd.Echo False
              >>DoCmd.RunComm and acCmdSaveRecord
              >>NrOfMales.Req uery
              >>DoCmd.Echo True
              >>End Sub
              >>>
              >>At the moment the calculated field gets updated but while calculating
              >>the field shows no value (field is white). I'd like the field to move
              >>from the old value straight to the new value. I tried the DoCmd.Echo
              >>method but no luck.
              >>>
              >>Any ideas on how to achieve this?
              >>Thanks,
              >>John
              >>>
              >>>
              >>
              >>
              >
              >

                Comment

                Previous template Next
                Working...