[AccessD] Fwd: RE: [AccessDevelopers] My screen freezes while I am doing recordset updates

Lonnie Johnson prodevmg at yahoo.com
Sat Feb 5 16:58:04 CST 2005


Me.Repaint did it. 
 
Man, that was too simple. I've used Me.Repaint and it didn't occur to me.
 
Thanks Tom.

Tom Oakes <tom at personalpc.com> wrote:
To: 
From: "Tom Oakes" 
Date: Sat, 5 Feb 2005 07:36:35 -0800
Subject: RE: [AccessDevelopers] My screen freezes while I am doing recordset updates

I usually have to call the form's Repaint method every time the progress bar is updated: 

Me.Repaint
 

Tom Oakes 
Personal PC Consultants, Inc. 
tom at personalpc.com 
503.230.0911 (O) 
402.968.6946 (C) 
917.591.1769 (F) 



---------------------------------
From: Lonnie Johnson [mailto:prodevmg at yahoo.com] 
Sent: Saturday, February 05, 2005 5:53 AM
To: 'MS-ACCESS-L at lists.missouri.edu'; AccessDevelopers; ms_access; Access Professionals; AccessD solving'
Subject: [AccessDevelopers] My screen freezes while I am doing recordset updates



I have form that runs a process using DAO recordsets. I have built a progress bar on the form. This progress bar has worked with other recordset processing. This particular process (updates) takes a long time and freezes up the screen. I don't see the results of the progress bar until it's done.
 
Can anyone give me some advice as to how I can see the process while the updates are being made?



May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us





 






---------------------------------
Do you Yahoo!?
The all-new My Yahoo!  Get yours free! 


Please zip all files prior to uploading to Files section. 




Please zip all files prior to uploading to Files section. 



---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
  
   To unsubscribe from this group, send an email to:
AccessDevelopers-unsubscribe at yahoogroups.com
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 




May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us





 





		
---------------------------------
Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'


More information about the AccessD mailing list