Darryl Collins
Darryl.Collins at coles.com.au
Thu May 29 22:28:08 CDT 2008
bah humbug. This is not going to work as the dll file needs to be placed in the system folder and I cannot get access to anything close to that on any of the corporate PC fleet. Might have to try another approach.
:-/
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darryl Collins
Sent: Friday, 30 May 2008 8:37 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A better picture?
aaaaah, Lebans, I should have guessed. Will also have a look at this option, although I also like the sound of Jennifer's approach.
many thanks
Darryl
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William
Hindman
Sent: Thursday, 29 May 2008 5:30 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A better picture?
http://www.lebans.com/loadsavejpeg.htm
...he uses the intel jpeg library to allow Access to use much larger jpegs
in the image control ...should in turn give you a much cleaner pdf graphic
output ...he also has a report converter to word that manages large embedded
graphics ...I use it regularly with clients rather than snapshot.
William
"The truth is incontrovertible, malice may attack it, ignorance may deride
it, but in the end; there it is."
--------------------------------------------------
From: "Darryl Collins" <Darryl.Collins at coles.com.au>
Sent: Thursday, May 29, 2008 12:45 AM
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
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
--
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
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.