Slow form

  • Thread starter Thread starter Denis
  • Start date Start date
D

Denis

Hi,

I've recently inherited a DB which was built by somebody
else. One of the forms takes about 2 minutes to open. It
is a form with about 7 tabs, each tab with a couple of sub-
forms. The query driving the form includes 6 tables, but
the query opens up in about 2 secs. The form has a lot of
VBA code controling the Visible property of various
controls.

To speed the form up, I have:
1. split the database so that front ends sit on users
machines
2. set referential integrity on the back end database
(yeah, it was built without referential integrity!)
3. deleted 5 of the tabs, to clean things up, and created
buttons leading to other forms.

The form still takes about 40 secs to open. Could it be
because the first tab includes a couple of sub forms and
filters (combo boxes)? Any ideas to speed this thing up
further?

Thanks!

Denis
 
Denis said:
Hi,

I've recently inherited a DB which was built by somebody
else. One of the forms takes about 2 minutes to open. It
is a form with about 7 tabs, each tab with a couple of sub-
forms. The query driving the form includes 6 tables, but
the query opens up in about 2 secs. The form has a lot of
VBA code controling the Visible property of various
controls.

To speed the form up, I have:
1. split the database so that front ends sit on users
machines
2. set referential integrity on the back end database
(yeah, it was built without referential integrity!)
3. deleted 5 of the tabs, to clean things up, and created
buttons leading to other forms.

The form still takes about 40 secs to open. Could it be
because the first tab includes a couple of sub forms and
filters (combo boxes)? Any ideas to speed this thing up
further?

Thanks!

Denis
Click to expand...

Check your options to see if you have the Name AutoCorrect option turned
on. If you do, try turning it off and see if that helps.
 
Thank you for your post! I also inherited a database and had a form taking several minutes to load on startup. Now it's seconds!
 
Angie said:
Thank you for your post! I also inherited a database and had a form
taking several minutes to load on startup. Now it's seconds!
Click to expand...

You're welcome, Angie. Name AutoCorrect turned out to be a much better
idea in theory than it did in practice.
 
Back
Top