• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1654
  • Last Modified:

How can I stop my access form from flickering when applying a filter?

I have a form that has two combo boxes on it. After the user selects an item from the second combobox the following code runs to update the filter;

Me.Filter = "[Source] = '" & cboSource & "'" & " and " & "[ProgNum] = '" & cboProgram & "'"
Me.FilterOn = True


When this runs, it causes the form to flicker once. Is there a way to prevent this?

Thanks!
0
SeyerIT
Asked:
SeyerIT
  • 8
  • 6
2 Solutions
 
Jeffrey CoachmanCommented:
Any "Flicker" should be barely noticeable.

This may become an issue if the number of records you are filtering is quite large.
...Or the Recordsource is a complex (a relative term here) query.
0
 
Jeffrey CoachmanCommented:
Also is there any other code on that second combobox?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
What version of Access?   There was a problem with screen flicker in an earlier version of you had un-attached labels, but outside of that, as Jeff said, any flicker shoul dbe barely noticeable.

Jim.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SeyerITAuthor Commented:
The recordsource currently has 3 records in it, I'm on Access 2010, and is the only code on that dropdown.. The flicker is rather noticeable on the pc and very noticeable through RDP on an ipad.

I just tried to attach a video of the flicker but guess that's not supported.
0
 
Jeffrey CoachmanCommented:
Yeah, you might have to change the extension of the video, ...either that or Zip the file...

But with 3 records, you should not see any flicker at all.

But all bets are off for rdp and ipads
Access will always be "slower" (a relative term here) over the internet or via RDP.
Access gives you the best performance when run from a standard Client/server configuration...
(Split database)
But Jim can speak more definitively on this subject...

Can you post a simple sample of the database that exhibits this issue?
0
 
SeyerITAuthor Commented:
Yes, give me a minute and I will put one up here.
0
 
SeyerITAuthor Commented:
While creating the test database I figured out what is causing the issue.. I have a picture set as the backround of the form and whenever it sets the filter it causes it to flicker..

Any ideas how to keep a picture in there and not have it cause the flickering?
0
 
Jeffrey CoachmanCommented:
Images (especially background images) are huge resource hogs.
(even if you scale them down and/or use a compressed image  file format)
This is because Access must "draw" them each time.

Is this image really needed to be a background?
It might be better if you just made it of a smaller res image and just set it in the corner or something...?
0
 
SeyerITAuthor Commented:
It would be nice to keep it :) The form looks pretty boring otherwise..
0
 
Jeffrey CoachmanCommented:
Then there may be no way to avoid the flicker...

For me, ...I'll take a form that works, over a pretty form that flickers...

Boring is a subjective term.
Are users really complaining about a form being "boring" if it does what it is supposed to do?
;-)

I make sure my database structure is sound above all else.
Looking pretty is perhaps a quaternary concern...

So it seems you need to make a trade off here somewhere...

JeffCoachman
0
 
Jeffrey CoachmanCommented:
..perhaps try lowering the resolution of the image...
0
 
SeyerITAuthor Commented:
Jeff I hear ya, I'm all about the useablity from the users end.. I removed teh backrounds and just changed the backround color. That works much better!
0
 
Jeffrey CoachmanCommented:
;-)
0
 
Jeffrey CoachmanCommented:
Thanks, but ultimately you solved your own issue...

"I removed teh backrounds and just changed the backround color. That works much better!"

So it would be more helpful to other members here searching for the same issue to see *your* post flagged as the solution, not mine.
;-)

Please click the Request Attention link to have this changed.

;-)

Jeff
0
 
SeyerITAuthor Commented:
How is this? Accepted mine as the best solution as it is the cause and Jeff's as the assisted as it explains why this is an issue.

Hopefully this will suffice?

Thanks again guys!
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now