Access recalculate(Rerun the queries) when printing report

  • Thread starter Thread starter jayan
  • Start date Start date
J

jayan

I have a problem with Access report.(Access 97)
I have a report with sub report in it.
When I am opening the report, it will take a few minutes
to populate the report.Then when I try to print a page
(Most of the time there is only a single page), Acccess
is rerunning all the queries again!.
Is there any i way i can avoid this recalculation .I just
want print to print the prewview screen.
The code i am using to print the report is

DoCmd.OpenForm "Job Customer PO Retainers",
0, "", "[JobNumber]='" & Me![JobNumber] & "' and [PONum]
='" & Me![PONum] & "'", 1, 0
Any help will be appreciated.
Thanks in advance
 
Not much you can do. Access reruns the queries when you print from the preview.
 
If your queries take a long time to run, use the queries to append the data
to an empty local temp table and base your report on the temp table. That
way the queries themselves only run once and the report will only query the
local temp table which should be very quick.
 
Thanks Guys .
Let me try the temp table method.
i will let you know.
-----Original Message-----
If your queries take a long time to run, use the queries to append the data
to an empty local temp table and base your report on the temp table. That
way the queries themselves only run once and the report will only query the
local temp table which should be very quick.

--

Alphonse Giambrone
Email: (e-mail address removed)
For email replace NOSPAM with agiam


jayan said:
I have a problem with Access report.(Access 97)
I have a report with sub report in it.
When I am opening the report, it will take a few minutes
to populate the report.Then when I try to print a page
(Most of the time there is only a single page), Acccess
is rerunning all the queries again!.
Is there any i way i can avoid this recalculation .I just
want print to print the prewview screen.
The code i am using to print the report is

DoCmd.OpenForm "Job Customer PO Retainers",
0, "", "[JobNumber]='" & Me![JobNumber] & "' and [PONum]
='" & Me![PONum] & "'", 1, 0
Any help will be appreciated.
Thanks in advance
Click to expand...


.
Click to expand...
 
Back
Top