Print an object from a form

[NevilleT]

I have a form with a Gantt Chart using the chart object. Is it possible to
print just the unbound object from the form? Docmd.PrintOut is close to what
I want but I have to select pages.
I would prefer not to use a chart on a report as the Gantt can be configured
on the form e.g. timescale, date range etc. Makes coordinating the form
display and the report a bit tricky.

 

[Alex Dybenko]

Hi,
you can specify pages for Docmd.PrintOut, see it arguments.
you can also bring access print dialog with ctrl+p

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[NevilleT]

Hi Alex. What I really need is a command that just prints the chart object
from the form. I can probably fiddle with printing particular pages (e.g. 3
and 4) from the form but as the chart can be varialble height it will not
always work.

 

[Dale Fye]

Why not imbed the same chart object within a report, if you set the
parameters for the chart by referring to controls on the form, then the chart
in the report should look just like the chart in the form.

Then you can just use docmd.OutputTo to print your chart.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Alex Dybenko]

Hi,
if chart supports printing - you can try to do so using this technique:
http://accessblog.net/2006/04/how-to-open-document-in-ole-field.html

activate it and then run it print method (or whatever method it has for
printing)

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[NevilleT]

That is what I ended up doing. Was trying to take a shortcut but in the end
I had to build all the parameters into the report. Basically rebuilt the
report with code. Sometimes looking for a shortcut can take longer than
doing it the obvious way. Thanks to you all for your help.