How to make a report static, when just viewing it.

  • Thread starter Thread starter CJM3407
  • Start date Start date
C

CJM3407

There are so many calculations going on on my report that it lags because
when I scroll through or do anything it auto refreshes. The calculations are
based on stagnant data there is no reason that it needs to constantly refresh
unless they choose to hit refresh. Is there a way to disable the auto
refresh thing. It causes my access to crash on simple things.
 
Not sure how to edit on this form. Anyway, umm i might add, I now know the
data is fine if it gets calculated as it loads. Because when I go to Print
Preview, it puts all the right data in the right spots. That recalculation
every second is just destroying perfermance.
 
Can you tell us anything about the calculations? Typically this isn't an
issue. When the calculations become so complicated that they affect the
rendering of the report, you might want to consider some alternatives such as
redoing your queries or creating temporary tables.
 
Ok, it starts out with a query that grabs all the Account Activity entries
that match the two Id numbers(from the form). Then another takes that query,
and draws out the data that lies in between a 30 day span. This one also
left outer joins with a date table (has all of the dates for the next 50
years). This makes all days be shown(and the join, joins the activity
information into the correct dates). The report calls on the second qry.

On the report, I group the data by Date. In the detail section I calculate
the deposits-withdrawals. That is then added to the LastTermBalance(which is
calculated on the form before hand.

Then in the DateOf Footer(group by object), the interest calculation is
done. And another textbox is keeping a running total of the interest.

It errors when I try to reference the running total of the interest inside
the report footer.
 
Nothing you suggested should cause issues. I assume you didn't use DLookup()
or DSum() or similar in the report. Also, are all the date fields indexed?
Are teh ID numbers indexed?
 
I do use DLookup() on the form that the report gets some of its information
from. And I do a DLookUp() to find the name of the Company (for the header)
 
I would make sure the company was in the report's record source. Are the
DLookup()s rendered only once or multiple times?
 
I want to delete all emails of this type. How do I do so? After I attempt
to delete, they regenerate themselves.
 
Huh? This is a public news group, not an email. You can't delete
records/posts from a public news group.
 
Back
Top