Hi C, > Thanks, Ben... Just put the single "DoEvents" in > the loop, no parameters or anything?
DO NOT PUT DOEVENTS IN THE LOOP TO RUN ON EVERY ITERATION!!!!! (Was that clear enough?) If you call DoEvents from EVERY iteration it'll slow the actual loop processing down to a crawl. Instead, use an iterator to find a 'reasonable' number of records to process between calls of DoEvents. There's an example on my site if you need to see some code, but generally you just need to say something like "if liter mod 1000 = 0 then doevents" - which would call DoEvents only every 1000th iteration. http://ReliableAnswers.com/VB/Samples.asp#exit > Was that in VB for dummies? I believe it was. ;) Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== Don't skinny dip with snapping turtles. ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
