[AccessD] Form flashes on timer event

Cool, glad it worked!

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Wednesday, April 02, 2008 10:43 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Form flashes on timer event

Drew:

Perfect.  Replaced with a label and the flicker went away.  

Thanks.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, April 02, 2008 8:15 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Form flashes on timer event

I see you got a few replies on this.  Just an FYI, there may not be
anything
you can do on this.  Though I will give a suggestion in a minute.

Access forms don't work like other windows in Windows.  A typical
window, if
it has a dozen textboxes, actually has a dozen 'child windows'. Each
control, be it a label, button, textbox, etc., is it's own window.  With
an
access form, only the ACTIVE control is it's own window.  Everything
else is
just an image painted on the form.  Weird, I know.  But, it means that
changing a value in a control, that doesn't have focus, is going to
'repaint' the form.

So, my suggestion, is if this is a value being changed frequently,
instead
of making it a textbox, turn it into a label, and just update it's
caption.
See if that helps the flicker problem.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at
Beach Access Software
Sent: Tuesday, April 01, 2008 6:57 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Form flashes on timer event

Dear List:
 
I've got a fairly complex bound form (no sub forms, though) with a timer
on
it to keep track of elapsed time (timesheet form for a law firm).  SO
they
can start and pause and cancel the timer with a couple of button.  And
it
shows the elapsed time.
 
The timer interval is set to 1000 and each time the timer event fires
the
screen flashes like it's being repainted.
 
Here's the code snip:
 
Private Sub Form_Timer()
 
If boolTrapErrors = True Then On Error GoTo Err_Form_Timer
 
    mdblTotalHours = mdblTotalHours + ((Me.TimerInterval / 1000) / 60) /
60
    Me.txtElapsedHours = DecHoursToHMS(mdblTotalHours)

where Me.txtElapsedHours  is obviously the box where the elapsed tiem is
being displayed.  
 
This is legacy code.  DecHoursToHMS is a function:
 
    DecHoursToHMS = Format(dblHours / 24, "HH:MM:SS")

Is there a way to stop the flashing?  A2K3 BTW.
 
MTIA
 
Rocky
 


 	
	
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com The information contained in
this
transmission is intended only for the person or entity to which it is
addressed and may contain II-VI Proprietary and/or II-VI Business
Sensitive
material. If you are not the intended recipient, please contact the
sender
immediately and destroy the material in its entirety, whether electronic
or
hard copy. You are notified that any review, retransmission, copying,
disclosure, dissemination, or other use of, or taking of any action in
reliance upon this information by persons or entities other than the
intended recipient is prohibited.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.519 / Virus Database: 269.22.4/1355 - Release Date:
4/1/2008
5:37 PM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.