Results 1 to 12 of 12
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Swindon, Wiltshire, United Kingdom
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Screenjudder (Access 97 SR2)

    Strange one this - when clicking on certain controls the screen judders, rapidly switching between what looks like an interlaced, jagged image and the normal screen. The process is completely repeatable and only occurs on certain controls in the form.

    My first suspicion was a graphic card but this is happening on a number of networked machines using the same copy of the database - don't mention the advantages of a Front End - I know and I'd love to if only 'they' would let me <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

    The problem happens when clicking in the same controls - this is what points me towards Access and not a graphic card problem.

    Does anyone have any ideas?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Screenjudder (Access 97 SR2)

    When did this start happening?
    I had a similar problem after I had Win95 reinstalled, it happended I needed the correct driver for my screen.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Screenjudder (Access 97 SR2)

    It may very well be Access in the sense that what you've told it to do is causing the screen to redraw itself. YOu need to take a look at what is going on behind the scenes when you click on those controls. Step through the code and see what's going on. The cure may be as simple as turning Painting off temporarily while some code is completed and then setting Me.Painting = True after it's finished.
    Charlotte

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    Do these buttons modify any settings? Such as enable/disable, show/hide ... If they do then try turning off screen repainting until the procedure is completed.

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Swindon, Wiltshire, United Kingdom
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    Thanks for those suggestions - unfortunately I haven't got direct access to the database at the moment but I'll see if any of those options help. As far as I remember there is no code attached to the controls and, in any case, it would have to be attached to the OnClick event as tabbing into the control does not cause the problem and the problem occurs before any changes are made.

    I didn't create the database so I'm not sure that there isn't something attached to the OnClick property. This problems happens on text boxes so I would be suprised if there was (but, hey, you never know!)

    I think that maybe the graphics card drivers would be a good place to start - at least that eliminates any strange 'incompatability features' that may be going on.

    Thanks again.

  6. #6
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    I've seen an effect like what you are describing, and it was completely caused by Access. What caused it was an 'endless' loop. For instance, on the AfterUpdate Event of Control1, it changes the value of Control2. Control2 has an AfterUpdate Event that changes Control1. Now, situations like these can happen from time to time, you just have to put a little 'checking' into the process, so that when the last leg of the loop finishes, the first leg knows everything is done, and stops. What is really wierd, when I have seen this occurance, I don't get an overflow error, or any error for that matter, and the process just stops....all on it's own. You can tell when it's done too, cause the screen stops gittering. It's basically like Access says to itself 'this is pointless', and just stops the code (you can keep using other stuff, and the code isn't interrupted in anyway).

  7. #7
    Lounger
    Join Date
    Jan 2001
    Location
    Swindon, Wiltshire, United Kingdom
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    mmm....I think that I'll have to check this one out.

    I spoke to someone in the office and they said that there was a macro attached to the AfterUpdate event of one of the controls causing the problem but without knowing what the macro does it's difficult to assess it.

    Next time I'm in....

    Thanks

  8. #8
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    The problem I experienced (and I'll have to admit...I caused it.....hey, when you're writing code at 2 in the morning...you tend to forget a few details....like stopping an endless loop! <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>), was all code, no macros. But you can have a Macro 'run' another macro, or there could be two macro's feeding off of each other....it's still one event firing another...and so on.

    Just have them remove one of the AfterUpdate events, to see if that prevents the 'flicker'. If it does, problem identified (not necessarily solved....). If it's a macro, they should just be able to 'cut' the macro name from the event, try the form, then paste it back in...without affecting anything.

  9. #9
    Lounger
    Join Date
    Jan 2001
    Location
    Swindon, Wiltshire, United Kingdom
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    I'll try that tomorrow - thanks.

    Meanwhile back to your Intro to ASP page....(and about time I got around to it! <img src=/S/smile.gif border=0 alt=smile width=15 height=15> )

  10. #10
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    I almost got yelled at for that tutorial, because I posted it as a few large emails on the AccessD Email list. I sure wish I had it when I started using ASP. (Even more so, the VBA tutorial I wrote when I was teaching myself VB/VBA! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>).

  11. #11
    Lounger
    Join Date
    Jan 2001
    Location
    Swindon, Wiltshire, United Kingdom
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    Thanks Drew - the hardest thing about a new area is sometimes the first step. When I think of some of the procedures I've created in VBA, having seen your article ASP seems less daunting.

    Back on topic tomorrow when I've got in touch with the office <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  12. #12
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screenjudder (Access 97 SR2)

    Okey dokey! I'll keep my fingers crossed for you, that it's just an endless loop!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •