Gustav Brock
Gustav at cactus.dk
Thu Jun 19 16:32:57 CDT 2008
Hi Rocky That's a lot. Are you running many queries? Perhaps you could speed up the code replacing SQL with DAO? I've done that myself for code than ran nicely with the test data but ran slowly with real life data volumes. /gustav >>> rockysmolin at bchacc.com 19-06-2008 21:05 >>> Yeah once per second is probably adequate. The calculations, however, is about 2000 lines. So that's a lot of DoEvents.