Form Saves too Slowly

S

Sammie

I have augmented my database and now an important form
takes forever to save and load. I took an order
application (like that in the Northwind DB) and changed all
the table, query, form and report names and also all the VB
Code I could find. It's not perfect yet, but it works.
The problem is that every time I make a design change to
the form, it takes about 2 minutes to save and return to
form view. What is the best approach to clean up this form?
Thanks. Sammie
 
D

Dirk Goldgar

Sammie said:
I have augmented my database and now an important form
takes forever to save and load. I took an order
application (like that in the Northwind DB) and changed all
the table, query, form and report names and also all the VB
Code I could find. It's not perfect yet, but it works.
The problem is that every time I make a design change to
the form, it takes about 2 minutes to save and return to
form view. What is the best approach to clean up this form?
Thanks. Sammie

In my experience, this is usually the operation of the Name AutoCorrect
feature. Click Tools -> Options..., go to the General tab, and turn off
Name AutoCorrect. See if that makes a difference.
 
S

Sammie

Dirk said:
In my experience, this is usually the operation of the Name AutoCorrect
feature. Click Tools -> Options..., go to the General tab, and turn off
Name AutoCorrect. See if that makes a difference.
That was exactly the problem! Makes a HUGE difference. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top