By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,584 Members | 3,447 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,584 IT Pros & Developers. It's quick & easy.

MS Access - Export Form Print Preview to Snapshot

P: n/a
Pat
I would like to send the Print Preview of a MS Access form to a
Snapshot file. The form contains an OLE graph.

BACKGROUND
A snapshot of a report is possible. If I could I would use a report to
display the graph but it is not possible to send query parameters to
an OLE graph on a report (or programatically change any properties of
an OLE Graph).

However with a Form you do have the ability to change the RowSource of
an OLE graph. The form Print Preview can be sent to a printer and the
output looks exactly like a printed report.

QUESTION
Is it possible to export this print preview to a snapshot file?

tkx in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Is is really just an image of the actual Graph that you want to export?
The Graph object itself should have an export/save as option. IF you are
using a third party Graph ActiveX control that does not expose the
required method then it still may be possible to save the contents of
the graph to disk via the OleDraw API. THere's code on my site showing
how to accomplish the output of an ActiveX control's contents to disk.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Pat" <sb**@sprint.ca> wrote in message
news:8c*************************@posting.google.co m...
I would like to send the Print Preview of a MS Access form to a
Snapshot file. The form contains an OLE graph.

BACKGROUND
A snapshot of a report is possible. If I could I would use a report to
display the graph but it is not possible to send query parameters to
an OLE graph on a report (or programatically change any properties of
an OLE Graph).

However with a Form you do have the ability to change the RowSource of
an OLE graph. The form Print Preview can be sent to a printer and the
output looks exactly like a printed report.

QUESTION
Is it possible to export this print preview to a snapshot file?

tkx in advance.


Nov 12 '05 #2

P: n/a
Pat
Stephen,

Tkx for the quick response.

No, it's not just an image of the actual Graph that I want to export.
I want to export the entire Form Print Preview as displayed. The Form
contains additional information as well as the graph. I am using
MSgraph and did use
the Export method to send the graph object to a JPEG file, this
experiment worked, but the solution was not sufficient.

The FORM print preview looks exactly like a REPORT print preview, my
hope was that I could somehow instruct (trick) Access to export this
view to a snapshot file.

Pat

"Stephen Lebans" <Fo****************************************@linval id.com> wrote in message news:<gJ*********************@ursa-nb00s0.nbnet.nb.ca>...
Is is really just an image of the actual Graph that you want to export?
The Graph object itself should have an export/save as option. IF you are
using a third party Graph ActiveX control that does not expose the
required method then it still may be possible to save the contents of
the graph to disk via the OleDraw API. THere's code on my site showing
how to accomplish the output of an ActiveX control's contents to disk.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Pat" <sb**@sprint.ca> wrote in message
news:8c*************************@posting.google.co m...
I would like to send the Print Preview of a MS Access form to a
Snapshot file. The form contains an OLE graph.

BACKGROUND
A snapshot of a report is possible. If I could I would use a report to
display the graph but it is not possible to send query parameters to
an OLE graph on a report (or programatically change any properties of
an OLE Graph).

However with a Form you do have the ability to change the RowSource of
an OLE graph. The form Print Preview can be sent to a printer and the
output looks exactly like a printed report.

QUESTION
Is it possible to export this print preview to a snapshot file?

tkx in advance.

Nov 12 '05 #3

P: n/a
"Pat" <sb**@sprint.ca> wrote in message
news:8c*************************@posting.google.co m...
Stephen,

Tkx for the quick response.

No, it's not just an image of the actual Graph that I want to export.
I want to export the entire Form Print Preview as displayed. The Form
contains additional information as well as the graph. I am using
MSgraph and did use
the Export method to send the graph object to a JPEG file, this
experiment worked, but the solution was not sufficient.

The FORM print preview looks exactly like a REPORT print preview, my
hope was that I could somehow instruct (trick) Access to export this
view to a snapshot file.


Is the "Export/Save As..." menu item not available when you preview the
form?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #4

P: n/a
Pat
Rick,

Yes, the Export menu item is available when Form Print Preview is
displayed.
But the export to Snapshot format is not available.

OTHER INFO
In FORM Print Preview mode when the menu item (Export) is selected,
you are presented with a dialog exactly the same as when you are
dealing with a REPORT Print Preview. The difference is that the the
export to Snapshot format is not available when in FORM Print Preview,
all other formats are available. The other formats (HTML etc) don't
like OLE Objects and ignore them. The snapshot is nice because it
treats the report preview like a photo.

Pat
"Rick Brandt" <ri*********@hotmail.com> wrote in message news:<bq*************@ID-98015.news.uni-berlin.de>...
"Pat" <sb**@sprint.ca> wrote in message
news:8c*************************@posting.google.co m...
Stephen,

Tkx for the quick response.

No, it's not just an image of the actual Graph that I want to export.
I want to export the entire Form Print Preview as displayed. The Form
contains additional information as well as the graph. I am using
MSgraph and did use
the Export method to send the graph object to a JPEG file, this
experiment worked, but the solution was not sufficient.

The FORM print preview looks exactly like a REPORT print preview, my
hope was that I could somehow instruct (trick) Access to export this
view to a snapshot file.


Is the "Export/Save As..." menu item not available when you preview the
form?

Nov 12 '05 #5

P: n/a
"Pat" <sb**@sprint.ca> wrote in message
news:8c*************************@posting.google.co m...
Rick,

Yes, the Export menu item is available when Form Print Preview is
displayed.
But the export to Snapshot format is not available.

OTHER INFO
In FORM Print Preview mode when the menu item (Export) is selected,
you are presented with a dialog exactly the same as when you are
dealing with a REPORT Print Preview. The difference is that the the
export to Snapshot format is not available when in FORM Print Preview,
all other formats are available. The other formats (HTML etc) don't
like OLE Objects and ignore them. The snapshot is nice because it
treats the report preview like a photo.


I would do the following:

Right-Click on your form in the db Window and select "Save as Report". You
will now have a report that looks exactly like your form. Export that
instead.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #6

P: n/a
Pat
Rick,

Yes, I considered that but the problem is that this approach creates
new report objects in the MDB evey time the user wants a snapshot.
There is the possibility that a user could overwrite an existing
canned report. I suppose that I could programatically control the
process of creating and deleting of these (temporary) objects. On
reconsideration, I think that this may be the best option, tks Rick.

I am still mystified as to why MS did not provide the export to
snapshot format from FORM report preview mode (they provides all the
other export formats). Was it an oversight or by design? If someone
has succeeded in accessing this feature I'm all ears.

Pat
"Rick Brandt" <ri*********@hotmail.com> wrote in message news:<bq*************@ID-98015.news.uni-berlin.de>...
"Pat" <sb**@sprint.ca> wrote in message
news:8c*************************@posting.google.co m...
Rick,

Yes, the Export menu item is available when Form Print Preview is
displayed.
But the export to Snapshot format is not available.

OTHER INFO
In FORM Print Preview mode when the menu item (Export) is selected,
you are presented with a dialog exactly the same as when you are
dealing with a REPORT Print Preview. The difference is that the the
export to Snapshot format is not available when in FORM Print Preview,
all other formats are available. The other formats (HTML etc) don't
like OLE Objects and ignore them. The snapshot is nice because it
treats the report preview like a photo.


I would do the following:

Right-Click on your form in the db Window and select "Save as Report". You
will now have a report that looks exactly like your form. Export that
instead.

Nov 12 '05 #7

P: n/a
"Pat" <sb**@sprint.ca> wrote in message
news:8c*************************@posting.google.co m...
Rick,

Yes, I considered that but the problem is that this approach creates
new report objects in the MDB evey time the user wants a snapshot.
There is the possibility that a user could overwrite an existing
canned report. I suppose that I could programatically control the
process of creating and deleting of these (temporary) objects. On
reconsideration, I think that this may be the best option, tks Rick.


Why on earth would the users be creating new report objects? You would use
ONE report and filter it each time to display whatever record(s) the user
wanted.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.