Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Nov 5 08:22:08 CST 2007
Dear List: I have a form which opens very slowly on the clients machine over a network. So I need to speed up the open. But first I need a benchmark. I tried capturing the time at the start and end of the Open event and then displaying a message box with the start, end, and elapsed times. But after I click OK on the message box there's still more stuff going on. I see Calculating... in the status at the bottom left which I think indicates that it's still evaluating the record source. And I think the slowness is from the recordsource query and/or the row sources of the combo boxes. So I need to capture the elapsed time from the very beginning to the very end of the open and load process. The start time is trivial, I think - first statement in the Open event timStart = Now. But where to I capture the stop time? If I can get the real elapsed time then I can begin to tweak the record and row sources - add indexes, simplify, etc. But I need an accurate measure of elapsed time. MTIA Rocky