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. 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.
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.
"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
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?
"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
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.
"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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
| |