[AccessD] A better picture?

Jennifer Gross jengross at gte.net
Thu May 29 11:47:47 CDT 2008


Darryl,

Is it that the users want charts that are created in Access dumped into
PowerPoint.  I have some code that does that automation, creating the chart
in a PowerPoint slide from Access data.

Jennifer

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Wednesday, May 28, 2008 8:46 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A better picture?



aaah, seems like snapshot is the only option. i have added an "Export..."
button to the custom toolbar to allow the users to do this.  If anyone has a
better suggestion I am all ears.

:)



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darryl Collins
Sent: Thursday, 29 May 2008 2:26 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] A better picture?



Hi People,

I have a button to create a PDF from a report.  Then my ever so creative
users are taking a copy of the PDF and putting it into power point.  Of
course by this stage (3rd generation of mushy PeeCee Graphic conversion) the
image is softer than grandma's feather bed and much less comfy.

Is there anyway of turning the Access report immediately into a JPG instead
of using snapshot?

As usual, I know you can do this in Excel with charts and the like, '
---------------------------- Dim Chart1 As Chart Set mychart =
Sheets("MySheet").ChartObjects(1).Chart
mychart.Export Filename:="C:\CopyOfMyChart.jpg", FilterName:="jpg"
' ----------------------------

or any part of a workbook using code such as:\ Selection.CopyPicture
Appearance:=xlScreen, Format:=xlPicture"

Is this possible to do in VBA Access?

regards
Darryl.

This email and any attachments may contain privileged and confidential
information and are intended for the named addressee only. If you have
received this e-mail in error, please notify the sender and delete this
e-mail immediately. Any confidentiality, privilege or copyright is not
waived or lost because this e-mail has been sent to you in error. It is your
responsibility to check this e-mail and any attachments for viruses.  No
warranty is made that this material is free from computer virus or any other
defect or error.  Any loss/damage incurred by using this material is not the
sender's responsibility.  The sender's entire liability will be limited to
resupplying the material.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential
information and are intended for the named addressee only. If you have
received this e-mail in error, please notify the sender and delete this
e-mail immediately. Any confidentiality, privilege or copyright is not
waived or lost because this e-mail has been sent to you in error. It is your
responsibility to check this e-mail and any attachments for viruses.  No
warranty is made that this material is free from computer virus or any other
defect or error.  Any loss/damage incurred by using this material is not the
sender's responsibility.  The sender's entire liability will be limited to
resupplying the material.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list