Concept?: Forms Loading Faster After Import

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Hello,

Thank you very much for helping me. I don't exactly have
a problem, my question is more conceptual, concerning the
way that Access loads a form:

Specifically:

1. My users have complained that 2 forms have been
loading slow (6-10 seconds).
2. I wasn't exactly surprised, because the forms contain
a lot of (1) hefty comboboxes and (2) visibility code
running on the On Current event. Also, the forms are
based on rather large tables.
3. However, by Accident, I discovered that the forms
load like lightening if I import them into a new database.
4. Then, after I edit the module behind the form, they
slow down again.
5. My question is: Why is this happening? What,
specifically is causing the forms to load slower after
they have been edited, and will the problem get worse
after the forms have been used?

Any help will be greatly appreciated.

Thx,

Jim
 
Jim,

When you are in the code module, have you done a Compile and
Save All Modules after making changes? Try this and see if
that effects the speed.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Jimmy said:
Hello,

Thank you very much for helping me. I don't exactly have
a problem, my question is more conceptual, concerning the
way that Access loads a form:

Specifically:

1. My users have complained that 2 forms have been
loading slow (6-10 seconds).
2. I wasn't exactly surprised, because the forms contain
a lot of (1) hefty comboboxes and (2) visibility code
running on the On Current event. Also, the forms are
based on rather large tables.
3. However, by Accident, I discovered that the forms
load like lightening if I import them into a new database.
4. Then, after I edit the module behind the form, they
slow down again.
5. My question is: Why is this happening? What,
specifically is causing the forms to load slower after
they have been edited, and will the problem get worse
after the forms have been used?
Click to expand...

What version of Access are you using? If you're using Access 2000 or
later, check your options (Tools -> Options..., General tab) to see if
you have the Name AutoCorrect feature enabled. It is enabled by default
on new installations. If you do have it enabled, try disabling it by
unchecking the "Track name AutoCorrect info" box. See if that has an
effect on the speed with which the forms load.
 
Thank you both for helping me. I really appreciate it.

Dirk, disabling the Autoname correct did help quite a bit.

Gary, I had already been compiling and saving the
modules. However, I did not know that that effect form
performance very much. Thanks for the heads up, and I
will make sure that I am religious about it.

Again, thank you and take care.

Jim
 
Back
Top