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

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.

"CJM3407" wrote:

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.

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.

--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"CJM3407" wrote:

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.

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.

"Duane Hookom" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"CJM3407" wrote:

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.

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?
--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"Duane Hookom" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"CJM3407" wrote:

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.

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)

"Duane Hookom" wrote:

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?
--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"Duane Hookom" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"CJM3407" wrote:

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.

I would make sure the company was in the report's record source. Are the
DLookup()s rendered only once or multiple times?
--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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)

"Duane Hookom" wrote:

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?
--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"Duane Hookom" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"CJM3407" wrote:

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.

I want to delete all emails of this type. How do I do so? After I attempt
to delete, they regenerate themselves.


On 7/16/09 8:50 AM, in article
, "CJM3407"
wrote:

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.

"Duane Hookom" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"CJM3407" wrote:

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.

Huh? This is a public news group, not an email. You can't delete
records/posts from a public news group.

--
Duane Hookom
Microsoft Access MVP


"Mark Liguori" wrote:

I want to delete all emails of this type. How do I do so? After I attempt
to delete, they regenerate themselves.


On 7/16/09 8:50 AM, in article
, "CJM3407"
wrote:

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.

"Duane Hookom" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"CJM3407" wrote:

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.

"CJM3407" wrote:

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.