Report slow to open

  • Thread starter Thread starter Paul Johnson
  • Start date Start date
P

Paul Johnson

I am wondering if anyone else has had this problem, and what you know about
fixing it.

Running Access 2K on Windows 2K:

I have been developing this application for some time now, it would not be
feasible to post code here. After making VBA code changes that ought to
result in (I would think) faster execution, one of my forms is suddenly very
slow opening. I have timed it taking as long as 20 or more seconds to open,
while the status bar says "Calculating..." and the mouse icon turns into an
hourglass. There are a number of steps in the form_current method, but this
is not even the form where the code changes were made! I rolled back to a
previous version that was working right, and even when I placed just a few
lines of new code in another form's event procedures, the form in question
again went to "Calculating..." upon opening. I am suspecting some generic
sort of corruption taking place, but everything functions as it should,
except for the nagging speed problem. I have compiled the code, and used
the "Compact and Repair Database" feature, but they have not fixed the
problem. I have also looked for obvious coding errors, where I might have
called an event procedure repeatedly, or caused an unwanted loop. I can't
find any such problems.

Has anyone else experienced this unexplainable slowdown of a form (or forms)
opening?

TIA,

Paul Johnson
 
I meant the subject line to read "Form slow to open." The records in my db
are called "reports" (not my choice), which has already been a source of too
much confusion. ;-)

Paul Johnson
 
Paul Johnson said:
I am wondering if anyone else has had this problem, and what you know
about fixing it.

Running Access 2K on Windows 2K:

I have been developing this application for some time now, it would
not be feasible to post code here. After making VBA code changes
that ought to result in (I would think) faster execution, one of my
forms is suddenly very slow opening. I have timed it taking as long
as 20 or more seconds to open, while the status bar says
"Calculating..." and the mouse icon turns into an hourglass. There
are a number of steps in the form_current method, but this is not
even the form where the code changes were made! I rolled back to a
previous version that was working right, and even when I placed just
a few lines of new code in another form's event procedures, the form
in question again went to "Calculating..." upon opening. I am
suspecting some generic sort of corruption taking place, but
everything functions as it should, except for the nagging speed
problem. I have compiled the code, and used the "Compact and Repair
Database" feature, but they have not fixed the problem. I have also
looked for obvious coding errors, where I might have called an event
procedure repeatedly, or caused an unwanted loop. I can't find any
such problems.

Has anyone else experienced this unexplainable slowdown of a form (or
forms) opening?
Click to expand...

Check to see if maybe the Name AutoCorrect misfeature is involved.
Click Tools -> Options..., go to the General tab, and see if the "Track
name AutoCorrect" box is checked. If it is, uncheck it, and see if that
makes a difference.
 
Thank you!

I have unchecked that box in the past, but had done some housecleaning in
this version of my app, importing all the objects into a new database, and I
forgot to look at that item. At first glance, I think you nailed the
problem.

Paul J
 
Back
Top