is there a code to determine how much time it takes to run a form ora load button in access form?

  • Thread starter Thread starter swami1912
  • Start date Start date
If you are opening this form from another, you could save the time when you
issue the OpenForm, then save the time in the Current event of the
just-opened form. If you want a finer "granularity", someone can probably
tell you how to get time using an API down to the millisecond.

I remember back when the "big deal" of a release was "lightweight forms"
(those with no class module) and how much time they saved. The tech editor
of Access Advisor magagine did a test and found the "significant difference"
claimed turned out to be only 15 milliseconds difference between a
lightweight form and the same form loaded down with all the code you could
stuff in its module.

From that memory, I'm guessing that time to load a form (which, by
definition, is intended to be viewed by a user) is unlikely to make any
significant difference in the users' perception of response... though if you
load it down with images, you might prove otherwise.
 
Back
Top