Is there code to DELAY an entire procedure for 1 second

MaryC

GURU / GEEK
Local time
Yesterday, 21:52
Joined
Apr 15, 2003
Messages
13
I want to set the code for an OnCurrent procedure to delay for 1 second, allowing controls to get data from subforms 1st then run the procedure to calculate on those controls. Access 2007 is too slow on getting the totals from the subforms with a lot of records:confused: .
 
The delay code works fine, but It didn't fix my problem

Thanks - I will try another work around eeeek!:)
 
You could also put code in the CurrentEvent of the SubForm to total what you need with either a query or the RecordSet and put the total in the Parent form.
 
If your system is running slow I would look at the indexes and is it normalized.

Access can handle millions of entries and do calcs very quickly.

It takes my db 3-4 seconds to build these stats when The systems compacted.

post-2-1176053742.jpg
 

Users who are viewing this thread

Back
Top Bottom