Requery without visibility change

S

stickandrock

I have a on Timer event on a form.

Within that logic I am performing a requery function on a number of fields.
When you requery the field goes from visable to not visable back to visable
with the refresh totals.

My problem is I am doing this requery on 26 fields on form. It's ALOT of
blinking. A bit distracting. Is there a way to perform the Requery without
the visibility change. just have it refresh the value.

Much appreciate as always.....
 
T

Tom van Stiphout

On Fri, 28 May 2010 07:26:02 -0700, stickandrock

Maybe you can wrap your code with:
Me.Painting = False
....your refresh code
Me.Painting = True

-Tom.
Microsoft Access MVP
 
S

stickandrock

still doing the same... Seems like it would work though...

between the Red/Green Conditional formatting and the blinking - I had to
laugh, looks like a Christmas tree..

keep the ideas coming. Still searching online myself to come up with a plan.
 
J

JimBurke via AccessMonster.com

Does Me.Painting do the same thing as DoCmd.Echo? I've always used Echo for
things like this, but maybe one's the same as the other. i.e. before the code
put DoCmd.Echo False, then after it put DoCmd.Echo True
still doing the same... Seems like it would work though...

between the Red/Green Conditional formatting and the blinking - I had to
laugh, looks like a Christmas tree..

keep the ideas coming. Still searching online myself to come up with a plan.
Maybe you can wrap your code with:
Me.Painting = False
[quoted text clipped - 16 lines]
 
K

kc-mass

Are you performing the requery on each of the 26 controls? If so why not
just requery the form or even just Me.Requery. That way everything gets
updated in the same cycle.

Regards

Kevin
 
D

Dirk Goldgar

stickandrock said:
I have a on Timer event on a form.

Within that logic I am performing a requery function on a number of
fields.
When you requery the field goes from visable to not visable back to
visable
with the refresh totals.

My problem is I am doing this requery on 26 fields on form. It's ALOT of
blinking. A bit distracting. Is there a way to perform the Requery
without
the visibility change. just have it refresh the value.

Much appreciate as always.....


What sort of expressions do you have in those controls? Maybe Me.Recalc
would recalculate them all.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh a form 1
Save current fields error on a chart 0
Eliminate prompt in requery of subdatasheet in vba 6
Combo Box requery 1
Hide and Seek 2
Access Form Requery 1
Count Results in Access 97 8
Requery form 2

Top