Printing Charts

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

Server404

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
 
Server404 said:
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.
Click to expand...

Use a form to supply the criteria data to your query. Your users will fill
in the required textboxes, and you can even supply defaults. Refer to your
form's textboxes in the query like:

Between [Forms]![YourForm]![txtStart] And [Forms]![YourForm]![txtEnd]

Now you can just fill in the form one time and have it run both the chart on
screen and the report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Cool...thanks for your help !

Arvin Meyer said:
Server404 said:
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.
Click to expand...

Use a form to supply the criteria data to your query. Your users will fill
in the required textboxes, and you can even supply defaults. Refer to your
form's textboxes in the query like:

Between [Forms]![YourForm]![txtStart] And [Forms]![YourForm]![txtEnd]

Now you can just fill in the form one time and have it run both the chart on
screen and the report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
 
Back
Top