Form Takes a Long Time to Load

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I have several forms, all with some programming behind them, that take a
long time (up to 30 seconds) to load, causing the end users to think that
the program has crashed (and it sometimes does).

What types of programming or other issues could cause this? What should I
be avoiding during the "OnCurrent" event? (The loading problem, however,
seems to only happen when the form is opened, not when we go through the
other records.)
 
L.A. Lawyer said:
I have several forms, all with some programming behind them, that
take a long time (up to 30 seconds) to load, causing the end users to
think that the program has crashed (and it sometimes does).

What types of programming or other issues could cause this? What
should I be avoiding during the "OnCurrent" event? (The loading
problem, however, seems to only happen when the form is opened, not
when we go through the other records.)
Click to expand...

Slow form opening is usually due to the loading of data, rather than executing
code (unless the code is pulling data).

Do you have subforms? Lots of ListBoxes and ComboBoxes? Lots of domain
aggregate functions (DLookup, DCount, etc.)? If you temporarily change the
query for the form so it loads zero records does this make a substantial
difference?

If this is a split network app there are several known things you should do to
increase performance one of which is to make sure you always have at least one
table on the back end open at all times. The initial connection has overhead
that subsequent connections do not, but if you close all connections then you
have to incur the overhead again the next time you pull some data.

Others are to turn off NameAutoCorrect and table sub-datasheets.
 
L.A. Lawyer said:
I have several forms, all with some programming behind them, that
take a long time (up to 30 seconds) to load, causing the end users to
think that the program has crashed (and it sometimes does).

What types of programming or other issues could cause this? What
should I be avoiding during the "OnCurrent" event? (The loading
problem, however, seems to only happen when the form is opened, not
when we go through the other records.)
Click to expand...

If you have the Name AutoCorrect option enabled, try turning it off and
see if that makes a difference.
 
Back
Top