Printing Reports

  • Thread starter Thread starter Server404
  • Start date Start date
S

Server404

I have constructed a chart using a query called "Expenses". The query
contains 2 "Like" statements and "Between" statements for dates. All works
well when building the chart and it is displayed on screen as expected.

The problem comes in when I want to print the chart that is being displayed.

When "Print" is selected from the menu bar it runs the query again prior to
printing the chart...this is the info that was just entered so it become
annoying and even confusing to new users.

I am curious if there is a way to build a "Print" button on the chart itself
or a way to keep it from asking the info again prior to printing.

Thanks,
JCrowe
 
J:

Access reports are designed to run "real time" i.e. pulling the latest data
from the underlying tables. What it appears that you are seeing is that
you first open your report in preview (where it prompts you) and then send
it to print (where it prompts you again.) This is expected behaviour
because Access will "requery" a previewed report when it is sent to print,
rather than working with the static data that it already pulled.

The easiest work around for this is to create a form where the user enters
the values you want for the spans or other paramters and then in the
underlying query for the report / chart, reference the form's controls
rather than creating a prompt parameter. As a result the user only enters
the data once and then the report pulls those same parameters each time it
is run.

HTH
 
Back
Top