473,320 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MS Access - Export Form Print Preview to Snapshot

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
7 14319
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
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
"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
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
"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
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Joris Kempen | last post by:
Hi people, I know that the question has come around sometimes: How to open an Access Report using ASP and export it to for example RTF. I'm trying to implement the first method of David...
0
by: Malcolm Cook | last post by:
I've discovered: Using "File > Print Preview" in a form's datasheet view with a server Filter crashes access after previewing... ....that is, unless ServerFilterByForm has been turned off...
7
by: Susan Bricker | last post by:
I would like to generate a report (I have the report working already) using MS/ACCESS 2000 and then have the ability to send the report as an email attachment to my colleagues. I have looked...
15
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user...
1
by: Tom Louchbaum | last post by:
When I preview my Access 2000 Report it looks fine. When I Email the report using DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , , "Subject", , False the resulting...
3
by: Jorge Cecílio | last post by:
Hi! I would like to export some MS-Access reports output to pdf. However, the only possibility offered by Access (afaik) for me to export formatted output is snp (snapshot) (I use MS-Office...
1
by: Vincel2k2 | last post by:
Hi, I need to provide Access reports from our web site. When the app gets to the output command I get this error I get this error: The formats that enable you to output data as a Microsoft Excel,...
13
by: salad | last post by:
Hi Guys: I was stuck. I needed to send a report to a file. My beautiful report(s) in Access were going to require loss of formatting with RTFs, a PITA in WordMailMerge, sending it as a text...
1
by: ellenh | last post by:
I have read postings on the similar subject including the posting from 2003 shown below. This process works fine to display a single page snapshot report in PowerPoint. I need to display...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.