Printing

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

I have a chart on a form that I want to print. I currently have it set up
to print the form, but it captures some excess grey areas and the buttons on
the form. Is there a way to print only the chart object?

Tiffany
 
Tiffany,

Put everything in a report and then print the report. Forms are not for
printing.
 
I had the following code written and it worked perfectly, but since reports
are the way to go, I tried inserting a new chart into a report and then
tried to make the rowsource = strs in the code. I can't figure out how to
do the same thing I am doing with the form on the report. I keep getting
errors. I try it one way and access stops me saying the report is not
opened yet, I try it another way and the report cannot be changed after it
is printed. I am pulling my hair out!

strs = "SELECT Julian" & strItems & " FROM Production WHERE Julian >=" &
cboStart & _
" and Julian <=" & cboEnd & ";"
'Debug.Print strs
DoCmd.OpenForm "Form"
Form_Form.OLEUnbound0.RowSource = strs

Tiffany
 
Back
Top