Export of form with 2 graphs As a JPEG

Hi

Wonder if someone has some words of wisdom.

I have a access 2002 form that contains 2 graph objects that overlay each
other and would like to export them as a JPEG to use in a presentation. I
can do this individually for each graph but this does not help me as I need
both on the same JPEG. I thought I would try an export the form that
contains both but I am having trouble. (My VBA is self taught and a little
knowledge is dangerous). It is either impossible to do as the object doesn't
support the action or I have the code wrong.

I have tried looking through google through news groups, there is a lot
about IMPORTING jpegs into forms but can't find anything about exporting a
form as a JPEG.

The code I am using is:

Function PictureTest()
Dim obj As Object
Set obj = Forms![frmGraph].[FirstGraph].Object
obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
Set obj = Nothing

End Function

This works for each graph but not when I try :

Set obj = Forms![frmGraph].Object

or:

Set obj = Forms![frmGraph]

Any pearls of wisdom would be appreciated

Regards
Dave

Hi David,

The only options I have found to convert a MS Access report as a
graphic into something useable by any other software:

Convert to .pdf using Acrobat Writer and then open .pdf using
CorelDraw / save as .jpg

or

Print Screen / paste into CorelDraw (or other graphics program)/
edit bitmap / crop bitmap (to eliminate what is not required on the
screen) / save as .jpg

If anyone has a better idea I would love to hear it.

Peter

David Lauberts wrote:[color=blue]
> Hi
>
> Wonder if someone has some words of wisdom.
>
> I have a access 2002 form that contains 2 graph objects that overlay each
> other and would like to export them as a JPEG to use in a presentation. I
> can do this individually for each graph but this does not help me as I need
> both on the same JPEG. I thought I would try an export the form that
> contains both but I am having trouble. (My VBA is self taught and a little
> knowledge is dangerous). It is either impossible to do as the object doesn't
> support the action or I have the code wrong.
>
> I have tried looking through google through news groups, there is a lot
> about IMPORTING jpegs into forms but can't find anything about exporting a
> form as a JPEG.
>
> The code I am using is:
>
> Function PictureTest()
> Dim obj As Object
> Set obj = Forms![frmGraph].[FirstGraph].Object
> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> Set obj = Nothing
>
> End Function
>
> This works for each graph but not when I try :
>
> Set obj = Forms![frmGraph].Object
>
> or:
>
> Set obj = Forms![frmGraph]
>
> Any pearls of wisdom would be appreciated
>
> Regards
> Dave
>
>[/color]

Peter

I used print screen and MS Paint, thanks for the tip, but I was just
wondering if the was a way to do it directly using vb using a command button
for future work.

Anyone know if it can be done?

Regards
Dave
"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...[color=blue]
> Hi David,
>
> The only options I have found to convert a MS Access report as a
> graphic into something useable by any other software:
>
> Convert to .pdf using Acrobat Writer and then open .pdf using
> CorelDraw / save as .jpg
>
> or
>
> Print Screen / paste into CorelDraw (or other graphics program)/
> edit bitmap / crop bitmap (to eliminate what is not required on the
> screen) / save as .jpg
>
> If anyone has a better idea I would love to hear it.
>
> Peter
>
>
>
> David Lauberts wrote:[color=green]
> > Hi
> >
> > Wonder if someone has some words of wisdom.
> >
> > I have a access 2002 form that contains 2 graph objects that overlay[/color][/color]
each[color=blue][color=green]
> > other and would like to export them as a JPEG to use in a presentation.[/color][/color]
I[color=blue][color=green]
> > can do this individually for each graph but this does not help me as I[/color][/color]
need[color=blue][color=green]
> > both on the same JPEG. I thought I would try an export the form that
> > contains both but I am having trouble. (My VBA is self taught and a[/color][/color]
little[color=blue][color=green]
> > knowledge is dangerous). It is either impossible to do as the object[/color][/color]
doesn't[color=blue][color=green]
> > support the action or I have the code wrong.
> >
> > I have tried looking through google through news groups, there is a lot
> > about IMPORTING jpegs into forms but can't find anything about exporting[/color][/color]
a[color=blue][color=green]
> > form as a JPEG.
> >
> > The code I am using is:
> >
> > Function PictureTest()
> > Dim obj As Object
> > Set obj = Forms![frmGraph].[FirstGraph].Object
> > obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> > Set obj = Nothing
> >
> > End Function
> >
> > This works for each graph but not when I try :
> >
> > Set obj = Forms![frmGraph].Object
> >
> > or:
> >
> > Set obj = Forms![frmGraph]
> >
> > Any pearls of wisdom would be appreciated
> >
> > Regards
> > Dave
> >
> >[/color]
>[/color]

On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts" <david.lauberts@ntlworld.com> wrote:

You could try Stephen Lebans site http://www.lebans.com/ReportUtilities.htm his Report Utilies download allows you to save a report as an EMF or WMF
file. This file could then be converted to a jpg if required.
You would have to build a report showing your graphs in order to use this method. The easiest way to do this is to right click on your form in the
database window and select "Save As Report". This will create a new report based on your form which you can edit to suit your needs.

[color=blue]
>Peter
>
>I used print screen and MS Paint, thanks for the tip, but I was just
>wondering if the was a way to do it directly using vb using a command button
>for future work.
>
>Anyone know if it can be done?
>
>Regards
>Dave
>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...[color=green]
>> Hi David,
>>
>> The only options I have found to convert a MS Access report as a
>> graphic into something useable by any other software:
>>
>> Convert to .pdf using Acrobat Writer and then open .pdf using
>> CorelDraw / save as .jpg
>>
>> or
>>
>> Print Screen / paste into CorelDraw (or other graphics program)/
>> edit bitmap / crop bitmap (to eliminate what is not required on the
>> screen) / save as .jpg
>>
>> If anyone has a better idea I would love to hear it.
>>
>> Peter
>>
>>
>>
>> David Lauberts wrote:[color=darkred]
>> > Hi
>> >
>> > Wonder if someone has some words of wisdom.
>> >
>> > I have a access 2002 form that contains 2 graph objects that overlay[/color][/color]
>each[color=green][color=darkred]
>> > other and would like to export them as a JPEG to use in a presentation.[/color][/color]
>I[color=green][color=darkred]
>> > can do this individually for each graph but this does not help me as I[/color][/color]
>need[color=green][color=darkred]
>> > both on the same JPEG. I thought I would try an export the form that
>> > contains both but I am having trouble. (My VBA is self taught and a[/color][/color]
>little[color=green][color=darkred]
>> > knowledge is dangerous). It is either impossible to do as the object[/color][/color]
>doesn't[color=green][color=darkred]
>> > support the action or I have the code wrong.
>> >
>> > I have tried looking through google through news groups, there is a lot
>> > about IMPORTING jpegs into forms but can't find anything about exporting[/color][/color]
>a[color=green][color=darkred]
>> > form as a JPEG.
>> >
>> > The code I am using is:
>> >
>> > Function PictureTest()
>> > Dim obj As Object
>> > Set obj = Forms![frmGraph].[FirstGraph].Object
>> > obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
>> > Set obj = Nothing
>> >
>> > End Function
>> >
>> > This works for each graph but not when I try :
>> >
>> > Set obj = Forms![frmGraph].Object
>> >
>> > or:
>> >
>> > Set obj = Forms![frmGraph]
>> >
>> > Any pearls of wisdom would be appreciated
>> >
>> > Regards
>> > Dave
>> >
>> >[/color]
>>[/color]
>[/color]

Wayne Gillespie
Gosford NSW Australia

Wayne,

Thanks for your information. It does not change much. The MSAccess
report still has to be copied using non-MSAccess software and then
worked on to produce a useable graphic image.

We use online printing equipment, that refer to the MSAccess
database for the information to print. It would be nice if the whole
of the label information generated by MSAccess could be uplifted
directly from the report.

One of our printers has Swiss software that is able to handle .pdf
files directly, that makes the process a little easier.
Unfortunately the others are looking for a graphics image.

Please note an error in my reply to David. The .jpg files would need
to be exported from CorelDraw, not saved.

We hope that at some time in the future MSAccess may incorporate
some basic graphics interfaces.

Regards

Peter

Wayne Gillespie wrote:[color=blue]
> On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts" <david.lauberts@ntlworld.com> wrote:
>
> You could try Stephen Lebans site http://www.lebans.com/ReportUtilities.htm his Report Utilies download allows you to save a report as an EMF or WMF
> file. This file could then be converted to a jpg if required.
> You would have to build a report showing your graphs in order to use this method. The easiest way to do this is to right click on your form in the
> database window and select "Save As Report". This will create a new report based on your form which you can edit to suit your needs.
>
>
>[color=green]
>>Peter
>>
>>I used print screen and MS Paint, thanks for the tip, but I was just
>>wondering if the was a way to do it directly using vb using a command button
>>for future work.
>>
>>Anyone know if it can be done?
>>
>>Regards
>>Dave
>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
>>[color=darkred]
>>>Hi David,
>>>
>>>The only options I have found to convert a MS Access report as a
>>>graphic into something useable by any other software:
>>>
>>>Convert to .pdf using Acrobat Writer and then open .pdf using
>>>CorelDraw / save as .jpg
>>>
>>>or
>>>
>>>Print Screen / paste into CorelDraw (or other graphics program)/
>>>edit bitmap / crop bitmap (to eliminate what is not required on the
>>>screen) / save as .jpg
>>>
>>>If anyone has a better idea I would love to hear it.
>>>
>>>Peter
>>>
>>>
>>>
>>>David Lauberts wrote:
>>>
>>>>Hi
>>>>
>>>>Wonder if someone has some words of wisdom.
>>>>
>>>>I have a access 2002 form that contains 2 graph objects that overlay[/color]
>>
>>each
>>[color=darkred]
>>>>other and would like to export them as a JPEG to use in a presentation.[/color]
>>
>>I
>>[color=darkred]
>>>>can do this individually for each graph but this does not help me as I[/color]
>>
>>need
>>[color=darkred]
>>>>both on the same JPEG. I thought I would try an export the form that
>>>>contains both but I am having trouble. (My VBA is self taught and a[/color]
>>
>>little
>>[color=darkred]
>>>>knowledge is dangerous). It is either impossible to do as the object[/color]
>>
>>doesn't
>>[color=darkred]
>>>>support the action or I have the code wrong.
>>>>
>>>>I have tried looking through google through news groups, there is a lot
>>>>about IMPORTING jpegs into forms but can't find anything about exporting[/color]
>>
>>a
>>[color=darkred]
>>>>form as a JPEG.
>>>>
>>>>The code I am using is:
>>>>
>>>>Function PictureTest()
>>>>Dim obj As Object
>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
>>>> Set obj = Nothing
>>>>
>>>>End Function
>>>>
>>>>This works for each graph but not when I try :
>>>>
>>>>Set obj = Forms![frmGraph].Object
>>>>
>>>>or:
>>>>
>>>>Set obj = Forms![frmGraph]
>>>>
>>>>Any pearls of wisdom would be appreciated
>>>>
>>>>Regards
>>>>Dave
>>>>
>>>>
>>>[/color][/color]
>
> Wayne Gillespie
> Gosford NSW Australia[/color]

Peter I'm not sure exactly what process are you trying to automate. DO
you need to export the image of 2 Graphs contained on a Form and then
save this output as a single Jpeg file? Is it just the graphs you want
exported or the whole Form as it appears on the screen?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...[color=blue]
> Wayne,
>
> Thanks for your information. It does not change much. The MSAccess
> report still has to be copied using non-MSAccess software and then
> worked on to produce a useable graphic image.
>
> We use online printing equipment, that refer to the MSAccess
> database for the information to print. It would be nice if the whole
> of the label information generated by MSAccess could be uplifted
> directly from the report.
>
> One of our printers has Swiss software that is able to handle .pdf
> files directly, that makes the process a little easier.
> Unfortunately the others are looking for a graphics image.
>
> Please note an error in my reply to David. The .jpg files would need
> to be exported from CorelDraw, not saved.
>
> We hope that at some time in the future MSAccess may incorporate
> some basic graphics interfaces.
>
> Regards
>
> Peter
>
> Wayne Gillespie wrote:[color=green]
> > On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"[/color][/color]
<david.lauberts@ntlworld.com> wrote:[color=blue][color=green]
> >
> > You could try Stephen Lebans site[/color][/color]
http://www.lebans.com/ReportUtilities.htm his Report Utilies download
allows you to save a report as an EMF or WMF[color=blue][color=green]
> > file. This file could then be converted to a jpg if required.
> > You would have to build a report showing your graphs in order to use[/color][/color]
this method. The easiest way to do this is to right click on your form
in the[color=blue][color=green]
> > database window and select "Save As Report". This will create a new[/color][/color]
report based on your form which you can edit to suit your needs.[color=blue][color=green]
> >
> >
> >[color=darkred]
> >>Peter
> >>
> >>I used print screen and MS Paint, thanks for the tip, but I was just
> >>wondering if the was a way to do it directly using vb using a[/color][/color][/color]
command button[color=blue][color=green][color=darkred]
> >>for future work.
> >>
> >>Anyone know if it can be done?
> >>
> >>Regards
> >>Dave
> >>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> >>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> >>
> >>>Hi David,
> >>>
> >>>The only options I have found to convert a MS Access report as a
> >>>graphic into something useable by any other software:
> >>>
> >>>Convert to .pdf using Acrobat Writer and then open .pdf using
> >>>CorelDraw / save as .jpg
> >>>
> >>>or
> >>>
> >>>Print Screen / paste into CorelDraw (or other graphics program)/
> >>>edit bitmap / crop bitmap (to eliminate what is not required on the
> >>>screen) / save as .jpg
> >>>
> >>>If anyone has a better idea I would love to hear it.
> >>>
> >>>Peter
> >>>
> >>>
> >>>
> >>>David Lauberts wrote:
> >>>
> >>>>Hi
> >>>>
> >>>>Wonder if someone has some words of wisdom.
> >>>>
> >>>>I have a access 2002 form that contains 2 graph objects that[/color][/color][/color]
overlay[color=blue][color=green][color=darkred]
> >>
> >>each
> >>
> >>>>other and would like to export them as a JPEG to use in a[/color][/color][/color]
presentation.[color=blue][color=green][color=darkred]
> >>
> >>I
> >>
> >>>>can do this individually for each graph but this does not help me[/color][/color][/color]
as I[color=blue][color=green][color=darkred]
> >>
> >>need
> >>
> >>>>both on the same JPEG. I thought I would try an export the form[/color][/color][/color]
that[color=blue][color=green][color=darkred]
> >>>>contains both but I am having trouble. (My VBA is self taught and[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> >>
> >>little
> >>
> >>>>knowledge is dangerous). It is either impossible to do as the[/color][/color][/color]
object[color=blue][color=green][color=darkred]
> >>
> >>doesn't
> >>
> >>>>support the action or I have the code wrong.
> >>>>
> >>>>I have tried looking through google through news groups, there is[/color][/color][/color]
a lot[color=blue][color=green][color=darkred]
> >>>>about IMPORTING jpegs into forms but can't find anything about[/color][/color][/color]
exporting[color=blue][color=green][color=darkred]
> >>
> >>a
> >>
> >>>>form as a JPEG.
> >>>>
> >>>>The code I am using is:
> >>>>
> >>>>Function PictureTest()
> >>>>Dim obj As Object
> >>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> >>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> >>>> Set obj = Nothing
> >>>>
> >>>>End Function
> >>>>
> >>>>This works for each graph but not when I try :
> >>>>
> >>>>Set obj = Forms![frmGraph].Object
> >>>>
> >>>>or:
> >>>>
> >>>>Set obj = Forms![frmGraph]
> >>>>
> >>>>Any pearls of wisdom would be appreciated
> >>>>
> >>>>Regards
> >>>>Dave
> >>>>
> >>>>
> >>>[/color]
> >
> > Wayne Gillespie
> > Gosford NSW Australia[/color]
>[/color]

Stephen,

We have a data base of recipes and ingredients. Using MSAccess we
construct a label which includes all the legally required
information. The label information is designed to be printed onto a
preprinted base label by a label printer on a packaging machine. One
label printer (Intermec, in fact we wrote our own label design
software for the Intermec using MSAccess) is able to handle a
MSAccess report format, and one label printer (Hapa) is able to
handle the image as .pdf, however our other label printers
(Smartdates and Easycoders) require a graphics image.

The nutritional panel has a prescribed format which includes columns
of data and boxes.

The label includes the ingredient statement, the allergens and the
nutritional panel all of which are calculated each time the label is
printed, to ensure that any changes to the underlying recipe have
been updated on the label. Our system overcomes the possibility of a
product recall because of a change in a recipe not being
incorporated into the data on the label.

We have a nominal range of just under 500,000 products, so it is
more convenient to generate the label and the carton label at the
time a particular product is made. All products are crosschecked
(Recipe barcode, label barcode, carton barcode, packaging machine
barcode and the storage coolroom barcode) by a wireless Intermec
barcode system which is integrated into our MSAccess system which
also updates our accounting system via the MSAccess ODBC driver.

So basically the problem is being able to output a whole MSAccess
report page (it is only 100mm x 100mm) as a bitmap image.

Thanks

Peter

Stephen Lebans wrote:[color=blue]
> Peter I'm not sure exactly what process are you trying to automate. DO
> you need to export the image of 2 Graphs contained on a Form and then
> save this output as a single Jpeg file? Is it just the graphs you want
> exported or the whole Form as it appears on the screen?
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
>[color=green]
>>Wayne,
>>
>>Thanks for your information. It does not change much. The MSAccess
>>report still has to be copied using non-MSAccess software and then
>>worked on to produce a useable graphic image.
>>
>>We use online printing equipment, that refer to the MSAccess
>>database for the information to print. It would be nice if the whole
>>of the label information generated by MSAccess could be uplifted
>>directly from the report.
>>
>>One of our printers has Swiss software that is able to handle .pdf
>>files directly, that makes the process a little easier.
>>Unfortunately the others are looking for a graphics image.
>>
>>Please note an error in my reply to David. The .jpg files would need
>>to be exported from CorelDraw, not saved.
>>
>>We hope that at some time in the future MSAccess may incorporate
>>some basic graphics interfaces.
>>
>>Regards
>>
>>Peter
>>
>>Wayne Gillespie wrote:
>>[color=darkred]
>>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"[/color][/color]
>
> <david.lauberts@ntlworld.com> wrote:
>[color=green][color=darkred]
>>>You could try Stephen Lebans site[/color][/color]
>
> http://www.lebans.com/ReportUtilities.htm his Report Utilies download
> allows you to save a report as an EMF or WMF
>[color=green][color=darkred]
>>>file. This file could then be converted to a jpg if required.
>>>You would have to build a report showing your graphs in order to use[/color][/color]
>
> this method. The easiest way to do this is to right click on your form
> in the
>[color=green][color=darkred]
>>>database window and select "Save As Report". This will create a new[/color][/color]
>
> report based on your form which you can edit to suit your needs.
>[color=green][color=darkred]
>>>
>>>
>>>>Peter
>>>>
>>>>I used print screen and MS Paint, thanks for the tip, but I was just
>>>>wondering if the was a way to do it directly using vb using a[/color][/color]
>
> command button
>[color=green][color=darkred]
>>>>for future work.
>>>>
>>>>Anyone know if it can be done?
>>>>
>>>>Regards
>>>>Dave
>>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
>>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
>>>>
>>>>
>>>>>Hi David,
>>>>>
>>>>>The only options I have found to convert a MS Access report as a
>>>>>graphic into something useable by any other software:
>>>>>
>>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
>>>>>CorelDraw / save as .jpg
>>>>>
>>>>>or
>>>>>
>>>>>Print Screen / paste into CorelDraw (or other graphics program)/
>>>>>edit bitmap / crop bitmap (to eliminate what is not required on the
>>>>>screen) / save as .jpg
>>>>>
>>>>>If anyone has a better idea I would love to hear it.
>>>>>
>>>>>Peter
>>>>>
>>>>>
>>>>>
>>>>>David Lauberts wrote:
>>>>>
>>>>>
>>>>>>Hi
>>>>>>
>>>>>>Wonder if someone has some words of wisdom.
>>>>>>
>>>>>>I have a access 2002 form that contains 2 graph objects that[/color][/color]
>
> overlay
>[color=green][color=darkred]
>>>>each
>>>>
>>>>
>>>>>>other and would like to export them as a JPEG to use in a[/color][/color]
>
> presentation.
>[color=green][color=darkred]
>>>>I
>>>>
>>>>
>>>>>>can do this individually for each graph but this does not help me[/color][/color]
>
> as I
>[color=green][color=darkred]
>>>>need
>>>>
>>>>
>>>>>>both on the same JPEG. I thought I would try an export the form[/color][/color]
>
> that
>[color=green][color=darkred]
>>>>>>contains both but I am having trouble. (My VBA is self taught and[/color][/color]
>
> a
>[color=green][color=darkred]
>>>>little
>>>>
>>>>
>>>>>>knowledge is dangerous). It is either impossible to do as the[/color][/color]
>
> object
>[color=green][color=darkred]
>>>>doesn't
>>>>
>>>>
>>>>>>support the action or I have the code wrong.
>>>>>>
>>>>>>I have tried looking through google through news groups, there is[/color][/color]
>
> a lot
>[color=green][color=darkred]
>>>>>>about IMPORTING jpegs into forms but can't find anything about[/color][/color]
>
> exporting
>[color=green][color=darkred]
>>>>a
>>>>
>>>>
>>>>>>form as a JPEG.
>>>>>>
>>>>>>The code I am using is:
>>>>>>
>>>>>>Function PictureTest()
>>>>>>Dim obj As Object
>>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
>>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
>>>>>> Set obj = Nothing
>>>>>>
>>>>>>End Function
>>>>>>
>>>>>>This works for each graph but not when I try :
>>>>>>
>>>>>>Set obj = Forms![frmGraph].Object
>>>>>>
>>>>>>or:
>>>>>>
>>>>>>Set obj = Forms![frmGraph]
>>>>>>
>>>>>>Any pearls of wisdom would be appreciated
>>>>>>
>>>>>>Regards
>>>>>>Dave
>>>>>>
>>>>>>
>>>>>
>>>Wayne Gillespie
>>>Gosford NSW Australia[/color]
>>[/color]
>[/color]

There might be a very simple solution depending on:
1) What is the output resolution of your label printer?
2) What version of WIndows are you running?
3) What version of Access?
4) What is the current display resolution of the monitor previewing the
report?

I have code here somewhere that can copy the Report Print Preview window
to a disk based Image file. SInce your output area is only 4 inches by 4
inches, depending on your screen resolution and the printers output
resolution(I'm guessing it is only 198 DPI), you may be able to simply
capture the Print Preview window.

Alternatively, the ReportUtilites on my site can output each page at
full printer resolution to an ENhanced Metafile. It would only take a
bit mroe work instead save these EMF's programmatically to a Bitmap or
Jpeg file.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...[color=blue]
> Stephen,
>
> We have a data base of recipes and ingredients. Using MSAccess we
> construct a label which includes all the legally required
> information. The label information is designed to be printed onto a
> preprinted base label by a label printer on a packaging machine. One
> label printer (Intermec, in fact we wrote our own label design
> software for the Intermec using MSAccess) is able to handle a
> MSAccess report format, and one label printer (Hapa) is able to
> handle the image as .pdf, however our other label printers
> (Smartdates and Easycoders) require a graphics image.
>
> The nutritional panel has a prescribed format which includes columns
> of data and boxes.
>
> The label includes the ingredient statement, the allergens and the
> nutritional panel all of which are calculated each time the label is
> printed, to ensure that any changes to the underlying recipe have
> been updated on the label. Our system overcomes the possibility of a
> product recall because of a change in a recipe not being
> incorporated into the data on the label.
>
> We have a nominal range of just under 500,000 products, so it is
> more convenient to generate the label and the carton label at the
> time a particular product is made. All products are crosschecked
> (Recipe barcode, label barcode, carton barcode, packaging machine
> barcode and the storage coolroom barcode) by a wireless Intermec
> barcode system which is integrated into our MSAccess system which
> also updates our accounting system via the MSAccess ODBC driver.
>
> So basically the problem is being able to output a whole MSAccess
> report page (it is only 100mm x 100mm) as a bitmap image.
>
> Thanks
>
> Peter
>
>
>
> Stephen Lebans wrote:[color=green]
> > Peter I'm not sure exactly what process are you trying to automate.[/color][/color]
DO[color=blue][color=green]
> > you need to export the image of 2 Graphs contained on a Form and[/color][/color]
then[color=blue][color=green]
> > save this output as a single Jpeg file? Is it just the graphs you[/color][/color]
want[color=blue][color=green]
> > exported or the whole Form as it appears on the screen?
> >
> > --
> >
> > HTH
> > Stephen Lebans
> > http://www.lebans.com
> > Access Code, Tips and Tricks
> > Please respond only to the newsgroups so everyone can benefit.
> >
> >
> > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
> >[color=darkred]
> >>Wayne,
> >>
> >>Thanks for your information. It does not change much. The MSAccess
> >>report still has to be copied using non-MSAccess software and then
> >>worked on to produce a useable graphic image.
> >>
> >>We use online printing equipment, that refer to the MSAccess
> >>database for the information to print. It would be nice if the whole
> >>of the label information generated by MSAccess could be uplifted
> >>directly from the report.
> >>
> >>One of our printers has Swiss software that is able to handle .pdf
> >>files directly, that makes the process a little easier.
> >>Unfortunately the others are looking for a graphics image.
> >>
> >>Please note an error in my reply to David. The .jpg files would need
> >>to be exported from CorelDraw, not saved.
> >>
> >>We hope that at some time in the future MSAccess may incorporate
> >>some basic graphics interfaces.
> >>
> >>Regards
> >>
> >>Peter
> >>
> >>Wayne Gillespie wrote:
> >>
> >>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"[/color]
> >
> > <david.lauberts@ntlworld.com> wrote:
> >[color=darkred]
> >>>You could try Stephen Lebans site[/color]
> >
> > http://www.lebans.com/ReportUtilities.htm his Report Utilies[/color][/color]
download[color=blue][color=green]
> > allows you to save a report as an EMF or WMF
> >[color=darkred]
> >>>file. This file could then be converted to a jpg if required.
> >>>You would have to build a report showing your graphs in order to[/color][/color][/color]
use[color=blue][color=green]
> >
> > this method. The easiest way to do this is to right click on your[/color][/color]
form[color=blue][color=green]
> > in the
> >[color=darkred]
> >>>database window and select "Save As Report". This will create a new[/color]
> >
> > report based on your form which you can edit to suit your needs.
> >[color=darkred]
> >>>
> >>>
> >>>>Peter
> >>>>
> >>>>I used print screen and MS Paint, thanks for the tip, but I was[/color][/color][/color]
just[color=blue][color=green][color=darkred]
> >>>>wondering if the was a way to do it directly using vb using a[/color]
> >
> > command button
> >[color=darkred]
> >>>>for future work.
> >>>>
> >>>>Anyone know if it can be done?
> >>>>
> >>>>Regards
> >>>>Dave
> >>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> >>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> >>>>
> >>>>
> >>>>>Hi David,
> >>>>>
> >>>>>The only options I have found to convert a MS Access report as a
> >>>>>graphic into something useable by any other software:
> >>>>>
> >>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
> >>>>>CorelDraw / save as .jpg
> >>>>>
> >>>>>or
> >>>>>
> >>>>>Print Screen / paste into CorelDraw (or other graphics program)/
> >>>>>edit bitmap / crop bitmap (to eliminate what is not required on[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> >>>>>screen) / save as .jpg
> >>>>>
> >>>>>If anyone has a better idea I would love to hear it.
> >>>>>
> >>>>>Peter
> >>>>>
> >>>>>
> >>>>>
> >>>>>David Lauberts wrote:
> >>>>>
> >>>>>
> >>>>>>Hi
> >>>>>>
> >>>>>>Wonder if someone has some words of wisdom.
> >>>>>>
> >>>>>>I have a access 2002 form that contains 2 graph objects that[/color]
> >
> > overlay
> >[color=darkred]
> >>>>each
> >>>>
> >>>>
> >>>>>>other and would like to export them as a JPEG to use in a[/color]
> >
> > presentation.
> >[color=darkred]
> >>>>I
> >>>>
> >>>>
> >>>>>>can do this individually for each graph but this does not help[/color][/color][/color]
me[color=blue][color=green]
> >
> > as I
> >[color=darkred]
> >>>>need
> >>>>
> >>>>
> >>>>>>both on the same JPEG. I thought I would try an export the form[/color]
> >
> > that
> >[color=darkred]
> >>>>>>contains both but I am having trouble. (My VBA is self taught[/color][/color][/color]
and[color=blue][color=green]
> >
> > a
> >[color=darkred]
> >>>>little
> >>>>
> >>>>
> >>>>>>knowledge is dangerous). It is either impossible to do as the[/color]
> >
> > object
> >[color=darkred]
> >>>>doesn't
> >>>>
> >>>>
> >>>>>>support the action or I have the code wrong.
> >>>>>>
> >>>>>>I have tried looking through google through news groups, there[/color][/color][/color]
is[color=blue][color=green]
> >
> > a lot
> >[color=darkred]
> >>>>>>about IMPORTING jpegs into forms but can't find anything about[/color]
> >
> > exporting
> >[color=darkred]
> >>>>a
> >>>>
> >>>>
> >>>>>>form as a JPEG.
> >>>>>>
> >>>>>>The code I am using is:
> >>>>>>
> >>>>>>Function PictureTest()
> >>>>>>Dim obj As Object
> >>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> >>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> >>>>>> Set obj = Nothing
> >>>>>>
> >>>>>>End Function
> >>>>>>
> >>>>>>This works for each graph but not when I try :
> >>>>>>
> >>>>>>Set obj = Forms![frmGraph].Object
> >>>>>>
> >>>>>>or:
> >>>>>>
> >>>>>>Set obj = Forms![frmGraph]
> >>>>>>
> >>>>>>Any pearls of wisdom would be appreciated
> >>>>>>
> >>>>>>Regards
> >>>>>>Dave
> >>>>>>
> >>>>>>
> >>>>>
> >>>Wayne Gillespie
> >>>Gosford NSW Australia
> >>[/color]
> >[/color]
>[/color]

Hi Stephen

From my point of view I have 2 graphs on a form, exporting the whole form as
a JPEG would solve my problem going forward though I have used Peter's Print
screen as a temporary measure for the moment. It would be ideal if there was
some code to drop 2 graph objects on a form into a JPEG but if there is a
way I don't seem able to acheive it.

Dave
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>
wrote in message news:5iQpb.7408$R13.416379@ursa-nb00s0.nbnet.nb.ca...[color=blue]
> There might be a very simple solution depending on:
> 1) What is the output resolution of your label printer?
> 2) What version of WIndows are you running?
> 3) What version of Access?
> 4) What is the current display resolution of the monitor previewing the
> report?
>
> I have code here somewhere that can copy the Report Print Preview window
> to a disk based Image file. SInce your output area is only 4 inches by 4
> inches, depending on your screen resolution and the printers output
> resolution(I'm guessing it is only 198 DPI), you may be able to simply
> capture the Print Preview window.
>
> Alternatively, the ReportUtilites on my site can output each page at
> full printer resolution to an ENhanced Metafile. It would only take a
> bit mroe work instead save these EMF's programmatically to a Bitmap or
> Jpeg file.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...[color=green]
> > Stephen,
> >
> > We have a data base of recipes and ingredients. Using MSAccess we
> > construct a label which includes all the legally required
> > information. The label information is designed to be printed onto a
> > preprinted base label by a label printer on a packaging machine. One
> > label printer (Intermec, in fact we wrote our own label design
> > software for the Intermec using MSAccess) is able to handle a
> > MSAccess report format, and one label printer (Hapa) is able to
> > handle the image as .pdf, however our other label printers
> > (Smartdates and Easycoders) require a graphics image.
> >
> > The nutritional panel has a prescribed format which includes columns
> > of data and boxes.
> >
> > The label includes the ingredient statement, the allergens and the
> > nutritional panel all of which are calculated each time the label is
> > printed, to ensure that any changes to the underlying recipe have
> > been updated on the label. Our system overcomes the possibility of a
> > product recall because of a change in a recipe not being
> > incorporated into the data on the label.
> >
> > We have a nominal range of just under 500,000 products, so it is
> > more convenient to generate the label and the carton label at the
> > time a particular product is made. All products are crosschecked
> > (Recipe barcode, label barcode, carton barcode, packaging machine
> > barcode and the storage coolroom barcode) by a wireless Intermec
> > barcode system which is integrated into our MSAccess system which
> > also updates our accounting system via the MSAccess ODBC driver.
> >
> > So basically the problem is being able to output a whole MSAccess
> > report page (it is only 100mm x 100mm) as a bitmap image.
> >
> > Thanks
> >
> > Peter
> >
> >
> >
> > Stephen Lebans wrote:[color=darkred]
> > > Peter I'm not sure exactly what process are you trying to automate.[/color][/color]
> DO[color=green][color=darkred]
> > > you need to export the image of 2 Graphs contained on a Form and[/color][/color]
> then[color=green][color=darkred]
> > > save this output as a single Jpeg file? Is it just the graphs you[/color][/color]
> want[color=green][color=darkred]
> > > exported or the whole Form as it appears on the screen?
> > >
> > > --
> > >
> > > HTH
> > > Stephen Lebans
> > > http://www.lebans.com
> > > Access Code, Tips and Tricks
> > > Please respond only to the newsgroups so everyone can benefit.
> > >
> > >
> > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > > news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
> > >
> > >>Wayne,
> > >>
> > >>Thanks for your information. It does not change much. The MSAccess
> > >>report still has to be copied using non-MSAccess software and then
> > >>worked on to produce a useable graphic image.
> > >>
> > >>We use online printing equipment, that refer to the MSAccess
> > >>database for the information to print. It would be nice if the whole
> > >>of the label information generated by MSAccess could be uplifted
> > >>directly from the report.
> > >>
> > >>One of our printers has Swiss software that is able to handle .pdf
> > >>files directly, that makes the process a little easier.
> > >>Unfortunately the others are looking for a graphics image.
> > >>
> > >>Please note an error in my reply to David. The .jpg files would need
> > >>to be exported from CorelDraw, not saved.
> > >>
> > >>We hope that at some time in the future MSAccess may incorporate
> > >>some basic graphics interfaces.
> > >>
> > >>Regards
> > >>
> > >>Peter
> > >>
> > >>Wayne Gillespie wrote:
> > >>
> > >>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
> > >
> > > <david.lauberts@ntlworld.com> wrote:
> > >
> > >>>You could try Stephen Lebans site
> > >
> > > http://www.lebans.com/ReportUtilities.htm his Report Utilies[/color][/color]
> download[color=green][color=darkred]
> > > allows you to save a report as an EMF or WMF
> > >
> > >>>file. This file could then be converted to a jpg if required.
> > >>>You would have to build a report showing your graphs in order to[/color][/color]
> use[color=green][color=darkred]
> > >
> > > this method. The easiest way to do this is to right click on your[/color][/color]
> form[color=green][color=darkred]
> > > in the
> > >
> > >>>database window and select "Save As Report". This will create a new
> > >
> > > report based on your form which you can edit to suit your needs.
> > >
> > >>>
> > >>>
> > >>>>Peter
> > >>>>
> > >>>>I used print screen and MS Paint, thanks for the tip, but I was[/color][/color]
> just[color=green][color=darkred]
> > >>>>wondering if the was a way to do it directly using vb using a
> > >
> > > command button
> > >
> > >>>>for future work.
> > >>>>
> > >>>>Anyone know if it can be done?
> > >>>>
> > >>>>Regards
> > >>>>Dave
> > >>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > >>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> > >>>>
> > >>>>
> > >>>>>Hi David,
> > >>>>>
> > >>>>>The only options I have found to convert a MS Access report as a
> > >>>>>graphic into something useable by any other software:
> > >>>>>
> > >>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
> > >>>>>CorelDraw / save as .jpg
> > >>>>>
> > >>>>>or
> > >>>>>
> > >>>>>Print Screen / paste into CorelDraw (or other graphics program)/
> > >>>>>edit bitmap / crop bitmap (to eliminate what is not required on[/color][/color]
> the[color=green][color=darkred]
> > >>>>>screen) / save as .jpg
> > >>>>>
> > >>>>>If anyone has a better idea I would love to hear it.
> > >>>>>
> > >>>>>Peter
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>David Lauberts wrote:
> > >>>>>
> > >>>>>
> > >>>>>>Hi
> > >>>>>>
> > >>>>>>Wonder if someone has some words of wisdom.
> > >>>>>>
> > >>>>>>I have a access 2002 form that contains 2 graph objects that
> > >
> > > overlay
> > >
> > >>>>each
> > >>>>
> > >>>>
> > >>>>>>other and would like to export them as a JPEG to use in a
> > >
> > > presentation.
> > >
> > >>>>I
> > >>>>
> > >>>>
> > >>>>>>can do this individually for each graph but this does not help[/color][/color]
> me[color=green][color=darkred]
> > >
> > > as I
> > >
> > >>>>need
> > >>>>
> > >>>>
> > >>>>>>both on the same JPEG. I thought I would try an export the form
> > >
> > > that
> > >
> > >>>>>>contains both but I am having trouble. (My VBA is self taught[/color][/color]
> and[color=green][color=darkred]
> > >
> > > a
> > >
> > >>>>little
> > >>>>
> > >>>>
> > >>>>>>knowledge is dangerous). It is either impossible to do as the
> > >
> > > object
> > >
> > >>>>doesn't
> > >>>>
> > >>>>
> > >>>>>>support the action or I have the code wrong.
> > >>>>>>
> > >>>>>>I have tried looking through google through news groups, there[/color][/color]
> is[color=green][color=darkred]
> > >
> > > a lot
> > >
> > >>>>>>about IMPORTING jpegs into forms but can't find anything about
> > >
> > > exporting
> > >
> > >>>>a
> > >>>>
> > >>>>
> > >>>>>>form as a JPEG.
> > >>>>>>
> > >>>>>>The code I am using is:
> > >>>>>>
> > >>>>>>Function PictureTest()
> > >>>>>>Dim obj As Object
> > >>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> > >>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> > >>>>>> Set obj = Nothing
> > >>>>>>
> > >>>>>>End Function
> > >>>>>>
> > >>>>>>This works for each graph but not when I try :
> > >>>>>>
> > >>>>>>Set obj = Forms![frmGraph].Object
> > >>>>>>
> > >>>>>>or:
> > >>>>>>
> > >>>>>>Set obj = Forms![frmGraph]
> > >>>>>>
> > >>>>>>Any pearls of wisdom would be appreciated
> > >>>>>>
> > >>>>>>Regards
> > >>>>>>Dave
> > >>>>>>
> > >>>>>>
> > >>>>>
> > >>>Wayne Gillespie
> > >>>Gosford NSW Australia
> > >>
> > >[/color]
> >[/color]
>[/color]

Stephen,

In answer to your questions:

1. 300dpi
2. W98 the labeller's software does not work at all with later
versions of Windows even though it says it is compatible.
3. Access97 A number of later computers are running with WXP and
OfficeXP, but we have kept the base system on Access97.
4. 800x600

Any information would be appreciated.

Peter

Stephen Lebans wrote:[color=blue]
> There might be a very simple solution depending on:
> 1) What is the output resolution of your label printer?
> 2) What version of WIndows are you running?
> 3) What version of Access?
> 4) What is the current display resolution of the monitor previewing the
> report?
>
> I have code here somewhere that can copy the Report Print Preview window
> to a disk based Image file. SInce your output area is only 4 inches by 4
> inches, depending on your screen resolution and the printers output
> resolution(I'm guessing it is only 198 DPI), you may be able to simply
> capture the Print Preview window.
>
> Alternatively, the ReportUtilites on my site can output each page at
> full printer resolution to an ENhanced Metafile. It would only take a
> bit mroe work instead save these EMF's programmatically to a Bitmap or
> Jpeg file.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...
>[color=green]
>>Stephen,
>>
>>We have a data base of recipes and ingredients. Using MSAccess we
>>construct a label which includes all the legally required
>>information. The label information is designed to be printed onto a
>>preprinted base label by a label printer on a packaging machine. One
>>label printer (Intermec, in fact we wrote our own label design
>>software for the Intermec using MSAccess) is able to handle a
>>MSAccess report format, and one label printer (Hapa) is able to
>>handle the image as .pdf, however our other label printers
>>(Smartdates and Easycoders) require a graphics image.
>>
>>The nutritional panel has a prescribed format which includes columns
>>of data and boxes.
>>
>>The label includes the ingredient statement, the allergens and the
>>nutritional panel all of which are calculated each time the label is
>>printed, to ensure that any changes to the underlying recipe have
>>been updated on the label. Our system overcomes the possibility of a
>>product recall because of a change in a recipe not being
>>incorporated into the data on the label.
>>
>>We have a nominal range of just under 500,000 products, so it is
>>more convenient to generate the label and the carton label at the
>>time a particular product is made. All products are crosschecked
>>(Recipe barcode, label barcode, carton barcode, packaging machine
>>barcode and the storage coolroom barcode) by a wireless Intermec
>>barcode system which is integrated into our MSAccess system which
>>also updates our accounting system via the MSAccess ODBC driver.
>>
>>So basically the problem is being able to output a whole MSAccess
>>report page (it is only 100mm x 100mm) as a bitmap image.
>>
>>Thanks
>>
>>Peter
>>
>>
>>
>>Stephen Lebans wrote:
>>[color=darkred]
>>>Peter I'm not sure exactly what process are you trying to automate.[/color][/color]
>
> DO
>[color=green][color=darkred]
>>>you need to export the image of 2 Graphs contained on a Form and[/color][/color]
>
> then
>[color=green][color=darkred]
>>>save this output as a single Jpeg file? Is it just the graphs you[/color][/color]
>
> want
>[color=green][color=darkred]
>>>exported or the whole Form as it appears on the screen?
>>>
>>>--
>>>
>>>HTH
>>>Stephen Lebans
>>>http://www.lebans.com
>>>Access Code, Tips and Tricks
>>>Please respond only to the newsgroups so everyone can benefit.
>>>
>>>
>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
>>>news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
>>>
>>>
>>>>Wayne,
>>>>
>>>>Thanks for your information. It does not change much. The MSAccess
>>>>report still has to be copied using non-MSAccess software and then
>>>>worked on to produce a useable graphic image.
>>>>
>>>>We use online printing equipment, that refer to the MSAccess
>>>>database for the information to print. It would be nice if the whole
>>>>of the label information generated by MSAccess could be uplifted
>>>>directly from the report.
>>>>
>>>>One of our printers has Swiss software that is able to handle .pdf
>>>>files directly, that makes the process a little easier.
>>>>Unfortunately the others are looking for a graphics image.
>>>>
>>>>Please note an error in my reply to David. The .jpg files would need
>>>>to be exported from CorelDraw, not saved.
>>>>
>>>>We hope that at some time in the future MSAccess may incorporate
>>>>some basic graphics interfaces.
>>>>
>>>>Regards
>>>>
>>>>Peter
>>>>
>>>>Wayne Gillespie wrote:
>>>>
>>>>
>>>>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
>>>
>>><david.lauberts@ntlworld.com> wrote:
>>>
>>>
>>>>>You could try Stephen Lebans site
>>>
>>>http://www.lebans.com/ReportUtilities.htm his Report Utilies[/color][/color]
>
> download
>[color=green][color=darkred]
>>>allows you to save a report as an EMF or WMF
>>>
>>>
>>>>>file. This file could then be converted to a jpg if required.
>>>>>You would have to build a report showing your graphs in order to[/color][/color]
>
> use
>[color=green][color=darkred]
>>>this method. The easiest way to do this is to right click on your[/color][/color]
>
> form
>[color=green][color=darkred]
>>>in the
>>>
>>>
>>>>>database window and select "Save As Report". This will create a new
>>>
>>>report based on your form which you can edit to suit your needs.
>>>
>>>
>>>>>
>>>>>>Peter
>>>>>>
>>>>>>I used print screen and MS Paint, thanks for the tip, but I was[/color][/color]
>
> just
>[color=green][color=darkred]
>>>>>>wondering if the was a way to do it directly using vb using a
>>>
>>>command button
>>>
>>>
>>>>>>for future work.
>>>>>>
>>>>>>Anyone know if it can be done?
>>>>>>
>>>>>>Regards
>>>>>>Dave
>>>>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
>>>>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Hi David,
>>>>>>>
>>>>>>>The only options I have found to convert a MS Access report as a
>>>>>>>graphic into something useable by any other software:
>>>>>>>
>>>>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
>>>>>>>CorelDraw / save as .jpg
>>>>>>>
>>>>>>>or
>>>>>>>
>>>>>>>Print Screen / paste into CorelDraw (or other graphics program)/
>>>>>>>edit bitmap / crop bitmap (to eliminate what is not required on[/color][/color]
>
> the
>[color=green][color=darkred]
>>>>>>>screen) / save as .jpg
>>>>>>>
>>>>>>>If anyone has a better idea I would love to hear it.
>>>>>>>
>>>>>>>Peter
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>David Lauberts wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>Hi
>>>>>>>>
>>>>>>>>Wonder if someone has some words of wisdom.
>>>>>>>>
>>>>>>>>I have a access 2002 form that contains 2 graph objects that
>>>
>>>overlay
>>>
>>>
>>>>>>each
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>other and would like to export them as a JPEG to use in a
>>>
>>>presentation.
>>>
>>>
>>>>>>I
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>can do this individually for each graph but this does not help[/color][/color]
>
> me
>[color=green][color=darkred]
>>>as I
>>>
>>>
>>>>>>need
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>both on the same JPEG. I thought I would try an export the form
>>>
>>>that
>>>
>>>
>>>>>>>>contains both but I am having trouble. (My VBA is self taught[/color][/color]
>
> and
>[color=green][color=darkred]
>>>a
>>>
>>>
>>>>>>little
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>knowledge is dangerous). It is either impossible to do as the
>>>
>>>object
>>>
>>>
>>>>>>doesn't
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>support the action or I have the code wrong.
>>>>>>>>
>>>>>>>>I have tried looking through google through news groups, there[/color][/color]
>
> is
>[color=green][color=darkred]
>>>a lot
>>>
>>>
>>>>>>>>about IMPORTING jpegs into forms but can't find anything about
>>>
>>>exporting
>>>
>>>
>>>>>>a
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>form as a JPEG.
>>>>>>>>
>>>>>>>>The code I am using is:
>>>>>>>>
>>>>>>>>Function PictureTest()
>>>>>>>>Dim obj As Object
>>>>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
>>>>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
>>>>>>>> Set obj = Nothing
>>>>>>>>
>>>>>>>>End Function
>>>>>>>>
>>>>>>>>This works for each graph but not when I try :
>>>>>>>>
>>>>>>>>Set obj = Forms![frmGraph].Object
>>>>>>>>
>>>>>>>>or:
>>>>>>>>
>>>>>>>>Set obj = Forms![frmGraph]
>>>>>>>>
>>>>>>>>Any pearls of wisdom would be appreciated
>>>>>>>>
>>>>>>>>Regards
>>>>>>>>Dave
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>Wayne Gillespie
>>>>>Gosford NSW Australia
>>>>[/color][/color]
>[/color]

SO you simply want to able to programmatically combine the 2 exported
jpeg images of the graphs into one single Jpeg? You could modify a bit
of code from my site to easily do this.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"David Lauberts" <david.lauberts@ntlworld.com> wrote in message
news:tLWpb.1131$CJ1.310@newsfep1-gui.server.ntli.net...[color=blue]
> Hi Stephen
>
> From my point of view I have 2 graphs on a form, exporting the whole[/color]
form as[color=blue]
> a JPEG would solve my problem going forward though I have used Peter's[/color]
Print[color=blue]
> screen as a temporary measure for the moment. It would be ideal if[/color]
there was[color=blue]
> some code to drop 2 graph objects on a form into a JPEG but if there[/color]
is a[color=blue]
> way I don't seem able to acheive it.
>
> Dave
> "Stephen Lebans"[/color]
<ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>[color=blue]
> wrote in message news:5iQpb.7408$R13.416379@ursa-nb00s0.nbnet.nb.ca...[color=green]
> > There might be a very simple solution depending on:
> > 1) What is the output resolution of your label printer?
> > 2) What version of WIndows are you running?
> > 3) What version of Access?
> > 4) What is the current display resolution of the monitor previewing[/color][/color]
the[color=blue][color=green]
> > report?
> >
> > I have code here somewhere that can copy the Report Print Preview[/color][/color]
window[color=blue][color=green]
> > to a disk based Image file. SInce your output area is only 4 inches[/color][/color]
by 4[color=blue][color=green]
> > inches, depending on your screen resolution and the printers output
> > resolution(I'm guessing it is only 198 DPI), you may be able to[/color][/color]
simply[color=blue][color=green]
> > capture the Print Preview window.
> >
> > Alternatively, the ReportUtilites on my site can output each page at
> > full printer resolution to an ENhanced Metafile. It would only take[/color][/color]
a[color=blue][color=green]
> > bit mroe work instead save these EMF's programmatically to a Bitmap[/color][/color]
or[color=blue][color=green]
> > Jpeg file.
> >
> > --
> >
> > HTH
> > Stephen Lebans
> > http://www.lebans.com
> > Access Code, Tips and Tricks
> > Please respond only to the newsgroups so everyone can benefit.
> >
> >
> > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...[color=darkred]
> > > Stephen,
> > >
> > > We have a data base of recipes and ingredients. Using MSAccess we
> > > construct a label which includes all the legally required
> > > information. The label information is designed to be printed onto[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> > > preprinted base label by a label printer on a packaging machine.[/color][/color][/color]
One[color=blue][color=green][color=darkred]
> > > label printer (Intermec, in fact we wrote our own label design
> > > software for the Intermec using MSAccess) is able to handle a
> > > MSAccess report format, and one label printer (Hapa) is able to
> > > handle the image as .pdf, however our other label printers
> > > (Smartdates and Easycoders) require a graphics image.
> > >
> > > The nutritional panel has a prescribed format which includes[/color][/color][/color]
columns[color=blue][color=green][color=darkred]
> > > of data and boxes.
> > >
> > > The label includes the ingredient statement, the allergens and the
> > > nutritional panel all of which are calculated each time the label[/color][/color][/color]
is[color=blue][color=green][color=darkred]
> > > printed, to ensure that any changes to the underlying recipe have
> > > been updated on the label. Our system overcomes the possibility of[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> > > product recall because of a change in a recipe not being
> > > incorporated into the data on the label.
> > >
> > > We have a nominal range of just under 500,000 products, so it is
> > > more convenient to generate the label and the carton label at the
> > > time a particular product is made. All products are crosschecked
> > > (Recipe barcode, label barcode, carton barcode, packaging machine
> > > barcode and the storage coolroom barcode) by a wireless Intermec
> > > barcode system which is integrated into our MSAccess system which
> > > also updates our accounting system via the MSAccess ODBC driver.
> > >
> > > So basically the problem is being able to output a whole MSAccess
> > > report page (it is only 100mm x 100mm) as a bitmap image.
> > >
> > > Thanks
> > >
> > > Peter
> > >
> > >
> > >
> > > Stephen Lebans wrote:
> > > > Peter I'm not sure exactly what process are you trying to[/color][/color][/color]
automate.[color=blue][color=green]
> > DO[color=darkred]
> > > > you need to export the image of 2 Graphs contained on a Form and[/color]
> > then[color=darkred]
> > > > save this output as a single Jpeg file? Is it just the graphs[/color][/color][/color]
you[color=blue][color=green]
> > want[color=darkred]
> > > > exported or the whole Form as it appears on the screen?
> > > >
> > > > --
> > > >
> > > > HTH
> > > > Stephen Lebans
> > > > http://www.lebans.com
> > > > Access Code, Tips and Tricks
> > > > Please respond only to the newsgroups so everyone can benefit.
> > > >
> > > >
> > > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > > > news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
> > > >
> > > >>Wayne,
> > > >>
> > > >>Thanks for your information. It does not change much. The[/color][/color][/color]
MSAccess[color=blue][color=green][color=darkred]
> > > >>report still has to be copied using non-MSAccess software and[/color][/color][/color]
then[color=blue][color=green][color=darkred]
> > > >>worked on to produce a useable graphic image.
> > > >>
> > > >>We use online printing equipment, that refer to the MSAccess
> > > >>database for the information to print. It would be nice if the[/color][/color][/color]
whole[color=blue][color=green][color=darkred]
> > > >>of the label information generated by MSAccess could be uplifted
> > > >>directly from the report.
> > > >>
> > > >>One of our printers has Swiss software that is able to handle[/color][/color][/color]
..pdf[color=blue][color=green][color=darkred]
> > > >>files directly, that makes the process a little easier.
> > > >>Unfortunately the others are looking for a graphics image.
> > > >>
> > > >>Please note an error in my reply to David. The .jpg files would[/color][/color][/color]
need[color=blue][color=green][color=darkred]
> > > >>to be exported from CorelDraw, not saved.
> > > >>
> > > >>We hope that at some time in the future MSAccess may incorporate
> > > >>some basic graphics interfaces.
> > > >>
> > > >>Regards
> > > >>
> > > >>Peter
> > > >>
> > > >>Wayne Gillespie wrote:
> > > >>
> > > >>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
> > > >
> > > > <david.lauberts@ntlworld.com> wrote:
> > > >
> > > >>>You could try Stephen Lebans site
> > > >
> > > > http://www.lebans.com/ReportUtilities.htm his Report Utilies[/color]
> > download[color=darkred]
> > > > allows you to save a report as an EMF or WMF
> > > >
> > > >>>file. This file could then be converted to a jpg if required.
> > > >>>You would have to build a report showing your graphs in order[/color][/color][/color]
to[color=blue][color=green]
> > use[color=darkred]
> > > >
> > > > this method. The easiest way to do this is to right click on[/color][/color][/color]
your[color=blue][color=green]
> > form[color=darkred]
> > > > in the
> > > >
> > > >>>database window and select "Save As Report". This will create a[/color][/color][/color]
new[color=blue][color=green][color=darkred]
> > > >
> > > > report based on your form which you can edit to suit your needs.
> > > >
> > > >>>
> > > >>>
> > > >>>>Peter
> > > >>>>
> > > >>>>I used print screen and MS Paint, thanks for the tip, but I[/color][/color][/color]
was[color=blue][color=green]
> > just[color=darkred]
> > > >>>>wondering if the was a way to do it directly using vb using a
> > > >
> > > > command button
> > > >
> > > >>>>for future work.
> > > >>>>
> > > >>>>Anyone know if it can be done?
> > > >>>>
> > > >>>>Regards
> > > >>>>Dave
> > > >>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in[/color][/color][/color]
message[color=blue][color=green][color=darkred]
> > > >>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> > > >>>>
> > > >>>>
> > > >>>>>Hi David,
> > > >>>>>
> > > >>>>>The only options I have found to convert a MS Access report[/color][/color][/color]
as a[color=blue][color=green][color=darkred]
> > > >>>>>graphic into something useable by any other software:
> > > >>>>>
> > > >>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
> > > >>>>>CorelDraw / save as .jpg
> > > >>>>>
> > > >>>>>or
> > > >>>>>
> > > >>>>>Print Screen / paste into CorelDraw (or other graphics[/color][/color][/color]
program)/[color=blue][color=green][color=darkred]
> > > >>>>>edit bitmap / crop bitmap (to eliminate what is not required[/color][/color][/color]
on[color=blue][color=green]
> > the[color=darkred]
> > > >>>>>screen) / save as .jpg
> > > >>>>>
> > > >>>>>If anyone has a better idea I would love to hear it.
> > > >>>>>
> > > >>>>>Peter
> > > >>>>>
> > > >>>>>
> > > >>>>>
> > > >>>>>David Lauberts wrote:
> > > >>>>>
> > > >>>>>
> > > >>>>>>Hi
> > > >>>>>>
> > > >>>>>>Wonder if someone has some words of wisdom.
> > > >>>>>>
> > > >>>>>>I have a access 2002 form that contains 2 graph objects that
> > > >
> > > > overlay
> > > >
> > > >>>>each
> > > >>>>
> > > >>>>
> > > >>>>>>other and would like to export them as a JPEG to use in a
> > > >
> > > > presentation.
> > > >
> > > >>>>I
> > > >>>>
> > > >>>>
> > > >>>>>>can do this individually for each graph but this does not[/color][/color][/color]
help[color=blue][color=green]
> > me[color=darkred]
> > > >
> > > > as I
> > > >
> > > >>>>need
> > > >>>>
> > > >>>>
> > > >>>>>>both on the same JPEG. I thought I would try an export the[/color][/color][/color]
form[color=blue][color=green][color=darkred]
> > > >
> > > > that
> > > >
> > > >>>>>>contains both but I am having trouble. (My VBA is self[/color][/color][/color]
taught[color=blue][color=green]
> > and[color=darkred]
> > > >
> > > > a
> > > >
> > > >>>>little
> > > >>>>
> > > >>>>
> > > >>>>>>knowledge is dangerous). It is either impossible to do as[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > >
> > > > object
> > > >
> > > >>>>doesn't
> > > >>>>
> > > >>>>
> > > >>>>>>support the action or I have the code wrong.
> > > >>>>>>
> > > >>>>>>I have tried looking through google through news groups,[/color][/color][/color]
there[color=blue][color=green]
> > is[color=darkred]
> > > >
> > > > a lot
> > > >
> > > >>>>>>about IMPORTING jpegs into forms but can't find anything[/color][/color][/color]
about[color=blue][color=green][color=darkred]
> > > >
> > > > exporting
> > > >
> > > >>>>a
> > > >>>>
> > > >>>>
> > > >>>>>>form as a JPEG.
> > > >>>>>>
> > > >>>>>>The code I am using is:
> > > >>>>>>
> > > >>>>>>Function PictureTest()
> > > >>>>>>Dim obj As Object
> > > >>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> > > >>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> > > >>>>>> Set obj = Nothing
> > > >>>>>>
> > > >>>>>>End Function
> > > >>>>>>
> > > >>>>>>This works for each graph but not when I try :
> > > >>>>>>
> > > >>>>>>Set obj = Forms![frmGraph].Object
> > > >>>>>>
> > > >>>>>>or:
> > > >>>>>>
> > > >>>>>>Set obj = Forms![frmGraph]
> > > >>>>>>
> > > >>>>>>Any pearls of wisdom would be appreciated
> > > >>>>>>
> > > >>>>>>Regards
> > > >>>>>>Dave
> > > >>>>>>
> > > >>>>>>
> > > >>>>>
> > > >>>Wayne Gillespie
> > > >>>Gosford NSW Australia
> > > >>
> > > >
> > >[/color]
> >[/color]
>
>[/color]

Use the ReportUtilites on my site to export an EMF file, one for each
page of the Report. THen you could simply write a couple of lines of
code to load all of the exported EMF's into a StdPicture object and then
use the SaveImage method to save the EMF's out to disk based Bitmap
files.
Here's some sample code:(requires setting a Reference to "OLE
Automation". The file is "/Windows/System/StdOle2.tlb"

Private Function CreateBitmapFile(fname As String) As String

Dim obj As Object

Set obj = LoadPicture(fname)
If Not IsNull(obj) Then

SavePicture obj, "C:\SL11-52"
DoEvents
End If

CreateBitmapFile = "C:\SL11-52"
Set obj = Nothing

End Function

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
news:n06qb.179921$bo1.50394@news-server.bigpond.net.au...[color=blue]
> Stephen,
>
> In answer to your questions:
>
> 1. 300dpi
> 2. W98 the labeller's software does not work at all with later
> versions of Windows even though it says it is compatible.
> 3. Access97 A number of later computers are running with WXP and
> OfficeXP, but we have kept the base system on Access97.
> 4. 800x600
>
> Any information would be appreciated.
>
> Peter
>
> Stephen Lebans wrote:[color=green]
> > There might be a very simple solution depending on:
> > 1) What is the output resolution of your label printer?
> > 2) What version of WIndows are you running?
> > 3) What version of Access?
> > 4) What is the current display resolution of the monitor previewing[/color][/color]
the[color=blue][color=green]
> > report?
> >
> > I have code here somewhere that can copy the Report Print Preview[/color][/color]
window[color=blue][color=green]
> > to a disk based Image file. SInce your output area is only 4 inches[/color][/color]
by 4[color=blue][color=green]
> > inches, depending on your screen resolution and the printers output
> > resolution(I'm guessing it is only 198 DPI), you may be able to[/color][/color]
simply[color=blue][color=green]
> > capture the Print Preview window.
> >
> > Alternatively, the ReportUtilites on my site can output each page at
> > full printer resolution to an ENhanced Metafile. It would only take[/color][/color]
a[color=blue][color=green]
> > bit mroe work instead save these EMF's programmatically to a Bitmap[/color][/color]
or[color=blue][color=green]
> > Jpeg file.
> >
> > --
> >
> > HTH
> > Stephen Lebans
> > http://www.lebans.com
> > Access Code, Tips and Tricks
> > Please respond only to the newsgroups so everyone can benefit.
> >
> >
> > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...
> >[color=darkred]
> >>Stephen,
> >>
> >>We have a data base of recipes and ingredients. Using MSAccess we
> >>construct a label which includes all the legally required
> >>information. The label information is designed to be printed onto a
> >>preprinted base label by a label printer on a packaging machine. One
> >>label printer (Intermec, in fact we wrote our own label design
> >>software for the Intermec using MSAccess) is able to handle a
> >>MSAccess report format, and one label printer (Hapa) is able to
> >>handle the image as .pdf, however our other label printers
> >>(Smartdates and Easycoders) require a graphics image.
> >>
> >>The nutritional panel has a prescribed format which includes columns
> >>of data and boxes.
> >>
> >>The label includes the ingredient statement, the allergens and the
> >>nutritional panel all of which are calculated each time the label is
> >>printed, to ensure that any changes to the underlying recipe have
> >>been updated on the label. Our system overcomes the possibility of a
> >>product recall because of a change in a recipe not being
> >>incorporated into the data on the label.
> >>
> >>We have a nominal range of just under 500,000 products, so it is
> >>more convenient to generate the label and the carton label at the
> >>time a particular product is made. All products are crosschecked
> >>(Recipe barcode, label barcode, carton barcode, packaging machine
> >>barcode and the storage coolroom barcode) by a wireless Intermec
> >>barcode system which is integrated into our MSAccess system which
> >>also updates our accounting system via the MSAccess ODBC driver.
> >>
> >>So basically the problem is being able to output a whole MSAccess
> >>report page (it is only 100mm x 100mm) as a bitmap image.
> >>
> >>Thanks
> >>
> >>Peter
> >>
> >>
> >>
> >>Stephen Lebans wrote:
> >>
> >>>Peter I'm not sure exactly what process are you trying to automate.[/color]
> >
> > DO
> >[color=darkred]
> >>>you need to export the image of 2 Graphs contained on a Form and[/color]
> >
> > then
> >[color=darkred]
> >>>save this output as a single Jpeg file? Is it just the graphs you[/color]
> >
> > want
> >[color=darkred]
> >>>exported or the whole Form as it appears on the screen?
> >>>
> >>>--
> >>>
> >>>HTH
> >>>Stephen Lebans
> >>>http://www.lebans.com
> >>>Access Code, Tips and Tricks
> >>>Please respond only to the newsgroups so everyone can benefit.
> >>>
> >>>
> >>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> >>>news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
> >>>
> >>>
> >>>>Wayne,
> >>>>
> >>>>Thanks for your information. It does not change much. The MSAccess
> >>>>report still has to be copied using non-MSAccess software and then
> >>>>worked on to produce a useable graphic image.
> >>>>
> >>>>We use online printing equipment, that refer to the MSAccess
> >>>>database for the information to print. It would be nice if the[/color][/color][/color]
whole[color=blue][color=green][color=darkred]
> >>>>of the label information generated by MSAccess could be uplifted
> >>>>directly from the report.
> >>>>
> >>>>One of our printers has Swiss software that is able to handle .pdf
> >>>>files directly, that makes the process a little easier.
> >>>>Unfortunately the others are looking for a graphics image.
> >>>>
> >>>>Please note an error in my reply to David. The .jpg files would[/color][/color][/color]
need[color=blue][color=green][color=darkred]
> >>>>to be exported from CorelDraw, not saved.
> >>>>
> >>>>We hope that at some time in the future MSAccess may incorporate
> >>>>some basic graphics interfaces.
> >>>>
> >>>>Regards
> >>>>
> >>>>Peter
> >>>>
> >>>>Wayne Gillespie wrote:
> >>>>
> >>>>
> >>>>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
> >>>
> >>><david.lauberts@ntlworld.com> wrote:
> >>>
> >>>
> >>>>>You could try Stephen Lebans site
> >>>
> >>>http://www.lebans.com/ReportUtilities.htm his Report Utilies[/color]
> >
> > download
> >[color=darkred]
> >>>allows you to save a report as an EMF or WMF
> >>>
> >>>
> >>>>>file. This file could then be converted to a jpg if required.
> >>>>>You would have to build a report showing your graphs in order to[/color]
> >
> > use
> >[color=darkred]
> >>>this method. The easiest way to do this is to right click on your[/color]
> >
> > form
> >[color=darkred]
> >>>in the
> >>>
> >>>
> >>>>>database window and select "Save As Report". This will create a[/color][/color][/color]
new[color=blue][color=green][color=darkred]
> >>>
> >>>report based on your form which you can edit to suit your needs.
> >>>
> >>>
> >>>>>
> >>>>>>Peter
> >>>>>>
> >>>>>>I used print screen and MS Paint, thanks for the tip, but I was[/color]
> >
> > just
> >[color=darkred]
> >>>>>>wondering if the was a way to do it directly using vb using a
> >>>
> >>>command button
> >>>
> >>>
> >>>>>>for future work.
> >>>>>>
> >>>>>>Anyone know if it can be done?
> >>>>>>
> >>>>>>Regards
> >>>>>>Dave
> >>>>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> >>>>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>Hi David,
> >>>>>>>
> >>>>>>>The only options I have found to convert a MS Access report as[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> >>>>>>>graphic into something useable by any other software:
> >>>>>>>
> >>>>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
> >>>>>>>CorelDraw / save as .jpg
> >>>>>>>
> >>>>>>>or
> >>>>>>>
> >>>>>>>Print Screen / paste into CorelDraw (or other graphics[/color][/color][/color]
program)/[color=blue][color=green][color=darkred]
> >>>>>>>edit bitmap / crop bitmap (to eliminate what is not required on[/color]
> >
> > the
> >[color=darkred]
> >>>>>>>screen) / save as .jpg
> >>>>>>>
> >>>>>>>If anyone has a better idea I would love to hear it.
> >>>>>>>
> >>>>>>>Peter
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>David Lauberts wrote:
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>>Hi
> >>>>>>>>
> >>>>>>>>Wonder if someone has some words of wisdom.
> >>>>>>>>
> >>>>>>>>I have a access 2002 form that contains 2 graph objects that
> >>>
> >>>overlay
> >>>
> >>>
> >>>>>>each
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>other and would like to export them as a JPEG to use in a
> >>>
> >>>presentation.
> >>>
> >>>
> >>>>>>I
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>can do this individually for each graph but this does not help[/color]
> >
> > me
> >[color=darkred]
> >>>as I
> >>>
> >>>
> >>>>>>need
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>both on the same JPEG. I thought I would try an export the[/color][/color][/color]
form[color=blue][color=green][color=darkred]
> >>>
> >>>that
> >>>
> >>>
> >>>>>>>>contains both but I am having trouble. (My VBA is self taught[/color]
> >
> > and
> >[color=darkred]
> >>>a
> >>>
> >>>
> >>>>>>little
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>knowledge is dangerous). It is either impossible to do as the
> >>>
> >>>object
> >>>
> >>>
> >>>>>>doesn't
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>support the action or I have the code wrong.
> >>>>>>>>
> >>>>>>>>I have tried looking through google through news groups, there[/color]
> >
> > is
> >[color=darkred]
> >>>a lot
> >>>
> >>>
> >>>>>>>>about IMPORTING jpegs into forms but can't find anything about
> >>>
> >>>exporting
> >>>
> >>>
> >>>>>>a
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>form as a JPEG.
> >>>>>>>>
> >>>>>>>>The code I am using is:
> >>>>>>>>
> >>>>>>>>Function PictureTest()
> >>>>>>>>Dim obj As Object
> >>>>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> >>>>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> >>>>>>>> Set obj = Nothing
> >>>>>>>>
> >>>>>>>>End Function
> >>>>>>>>
> >>>>>>>>This works for each graph but not when I try :
> >>>>>>>>
> >>>>>>>>Set obj = Forms![frmGraph].Object
> >>>>>>>>
> >>>>>>>>or:
> >>>>>>>>
> >>>>>>>>Set obj = Forms![frmGraph]
> >>>>>>>>
> >>>>>>>>Any pearls of wisdom would be appreciated
> >>>>>>>>
> >>>>>>>>Regards
> >>>>>>>>Dave
> >>>>>>>>
> >>>>>>>>
> >>>>>>>
> >>>>>Wayne Gillespie
> >>>>>Gosford NSW Australia
> >>>>[/color]
> >[/color]
>[/color]

Stephen

Thanks for taking the time to respond.

Yes, on the form on one is a 'background' graph and one overlays it in the
'fore ground'. I can get each graph out as a JPEG, GIF or TIF and if I could
combine them so they 'overlay' each other that would great.

I have looked at your website - would I be right in saying the code to be
modified is contained in A2KExportOLEtoJPEG.zip in Misc?

Regards
Dave
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>
wrote in message news:Y9hqb.8361$R13.465338@ursa-nb00s0.nbnet.nb.ca...[color=blue]
> SO you simply want to able to programmatically combine the 2 exported
> jpeg images of the graphs into one single Jpeg? You could modify a bit
> of code from my site to easily do this.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "David Lauberts" <david.lauberts@ntlworld.com> wrote in message
> news:tLWpb.1131$CJ1.310@newsfep1-gui.server.ntli.net...[color=green]
> > Hi Stephen
> >
> > From my point of view I have 2 graphs on a form, exporting the whole[/color]
> form as[color=green]
> > a JPEG would solve my problem going forward though I have used Peter's[/color]
> Print[color=green]
> > screen as a temporary measure for the moment. It would be ideal if[/color]
> there was[color=green]
> > some code to drop 2 graph objects on a form into a JPEG but if there[/color]
> is a[color=green]
> > way I don't seem able to acheive it.
> >
> > Dave
> > "Stephen Lebans"[/color]
> <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>[color=green]
> > wrote in message news:5iQpb.7408$R13.416379@ursa-nb00s0.nbnet.nb.ca...[color=darkred]
> > > There might be a very simple solution depending on:
> > > 1) What is the output resolution of your label printer?
> > > 2) What version of WIndows are you running?
> > > 3) What version of Access?
> > > 4) What is the current display resolution of the monitor previewing[/color][/color]
> the[color=green][color=darkred]
> > > report?
> > >
> > > I have code here somewhere that can copy the Report Print Preview[/color][/color]
> window[color=green][color=darkred]
> > > to a disk based Image file. SInce your output area is only 4 inches[/color][/color]
> by 4[color=green][color=darkred]
> > > inches, depending on your screen resolution and the printers output
> > > resolution(I'm guessing it is only 198 DPI), you may be able to[/color][/color]
> simply[color=green][color=darkred]
> > > capture the Print Preview window.
> > >
> > > Alternatively, the ReportUtilites on my site can output each page at
> > > full printer resolution to an ENhanced Metafile. It would only take[/color][/color]
> a[color=green][color=darkred]
> > > bit mroe work instead save these EMF's programmatically to a Bitmap[/color][/color]
> or[color=green][color=darkred]
> > > Jpeg file.
> > >
> > > --
> > >
> > > HTH
> > > Stephen Lebans
> > > http://www.lebans.com
> > > Access Code, Tips and Tricks
> > > Please respond only to the newsgroups so everyone can benefit.
> > >
> > >
> > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > > news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...
> > > > Stephen,
> > > >
> > > > We have a data base of recipes and ingredients. Using MSAccess we
> > > > construct a label which includes all the legally required
> > > > information. The label information is designed to be printed onto[/color][/color]
> a[color=green][color=darkred]
> > > > preprinted base label by a label printer on a packaging machine.[/color][/color]
> One[color=green][color=darkred]
> > > > label printer (Intermec, in fact we wrote our own label design
> > > > software for the Intermec using MSAccess) is able to handle a
> > > > MSAccess report format, and one label printer (Hapa) is able to
> > > > handle the image as .pdf, however our other label printers
> > > > (Smartdates and Easycoders) require a graphics image.
> > > >
> > > > The nutritional panel has a prescribed format which includes[/color][/color]
> columns[color=green][color=darkred]
> > > > of data and boxes.
> > > >
> > > > The label includes the ingredient statement, the allergens and the
> > > > nutritional panel all of which are calculated each time the label[/color][/color]
> is[color=green][color=darkred]
> > > > printed, to ensure that any changes to the underlying recipe have
> > > > been updated on the label. Our system overcomes the possibility of[/color][/color]
> a[color=green][color=darkred]
> > > > product recall because of a change in a recipe not being
> > > > incorporated into the data on the label.
> > > >
> > > > We have a nominal range of just under 500,000 products, so it is
> > > > more convenient to generate the label and the carton label at the
> > > > time a particular product is made. All products are crosschecked
> > > > (Recipe barcode, label barcode, carton barcode, packaging machine
> > > > barcode and the storage coolroom barcode) by a wireless Intermec
> > > > barcode system which is integrated into our MSAccess system which
> > > > also updates our accounting system via the MSAccess ODBC driver.
> > > >
> > > > So basically the problem is being able to output a whole MSAccess
> > > > report page (it is only 100mm x 100mm) as a bitmap image.
> > > >
> > > > Thanks
> > > >
> > > > Peter
> > > >
> > > >
> > > >
> > > > Stephen Lebans wrote:
> > > > > Peter I'm not sure exactly what process are you trying to[/color][/color]
> automate.[color=green][color=darkred]
> > > DO
> > > > > you need to export the image of 2 Graphs contained on a Form and
> > > then
> > > > > save this output as a single Jpeg file? Is it just the graphs[/color][/color]
> you[color=green][color=darkred]
> > > want
> > > > > exported or the whole Form as it appears on the screen?
> > > > >
> > > > > --
> > > > >
> > > > > HTH
> > > > > Stephen Lebans
> > > > > http://www.lebans.com
> > > > > Access Code, Tips and Tricks
> > > > > Please respond only to the newsgroups so everyone can benefit.
> > > > >
> > > > >
> > > > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > > > > news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
> > > > >
> > > > >>Wayne,
> > > > >>
> > > > >>Thanks for your information. It does not change much. The[/color][/color]
> MSAccess[color=green][color=darkred]
> > > > >>report still has to be copied using non-MSAccess software and[/color][/color]
> then[color=green][color=darkred]
> > > > >>worked on to produce a useable graphic image.
> > > > >>
> > > > >>We use online printing equipment, that refer to the MSAccess
> > > > >>database for the information to print. It would be nice if the[/color][/color]
> whole[color=green][color=darkred]
> > > > >>of the label information generated by MSAccess could be uplifted
> > > > >>directly from the report.
> > > > >>
> > > > >>One of our printers has Swiss software that is able to handle[/color][/color]
> .pdf[color=green][color=darkred]
> > > > >>files directly, that makes the process a little easier.
> > > > >>Unfortunately the others are looking for a graphics image.
> > > > >>
> > > > >>Please note an error in my reply to David. The .jpg files would[/color][/color]
> need[color=green][color=darkred]
> > > > >>to be exported from CorelDraw, not saved.
> > > > >>
> > > > >>We hope that at some time in the future MSAccess may incorporate
> > > > >>some basic graphics interfaces.
> > > > >>
> > > > >>Regards
> > > > >>
> > > > >>Peter
> > > > >>
> > > > >>Wayne Gillespie wrote:
> > > > >>
> > > > >>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
> > > > >
> > > > > <david.lauberts@ntlworld.com> wrote:
> > > > >
> > > > >>>You could try Stephen Lebans site
> > > > >
> > > > > http://www.lebans.com/ReportUtilities.htm his Report Utilies
> > > download
> > > > > allows you to save a report as an EMF or WMF
> > > > >
> > > > >>>file. This file could then be converted to a jpg if required.
> > > > >>>You would have to build a report showing your graphs in order[/color][/color]
> to[color=green][color=darkred]
> > > use
> > > > >
> > > > > this method. The easiest way to do this is to right click on[/color][/color]
> your[color=green][color=darkred]
> > > form
> > > > > in the
> > > > >
> > > > >>>database window and select "Save As Report". This will create a[/color][/color]
> new[color=green][color=darkred]
> > > > >
> > > > > report based on your form which you can edit to suit your needs.
> > > > >
> > > > >>>
> > > > >>>
> > > > >>>>Peter
> > > > >>>>
> > > > >>>>I used print screen and MS Paint, thanks for the tip, but I[/color][/color]
> was[color=green][color=darkred]
> > > just
> > > > >>>>wondering if the was a way to do it directly using vb using a
> > > > >
> > > > > command button
> > > > >
> > > > >>>>for future work.
> > > > >>>>
> > > > >>>>Anyone know if it can be done?
> > > > >>>>
> > > > >>>>Regards
> > > > >>>>Dave
> > > > >>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in[/color][/color]
> message[color=green][color=darkred]
> > > > >>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> > > > >>>>
> > > > >>>>
> > > > >>>>>Hi David,
> > > > >>>>>
> > > > >>>>>The only options I have found to convert a MS Access report[/color][/color]
> as a[color=green][color=darkred]
> > > > >>>>>graphic into something useable by any other software:
> > > > >>>>>
> > > > >>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
> > > > >>>>>CorelDraw / save as .jpg
> > > > >>>>>
> > > > >>>>>or
> > > > >>>>>
> > > > >>>>>Print Screen / paste into CorelDraw (or other graphics[/color][/color]
> program)/[color=green][color=darkred]
> > > > >>>>>edit bitmap / crop bitmap (to eliminate what is not required[/color][/color]
> on[color=green][color=darkred]
> > > the
> > > > >>>>>screen) / save as .jpg
> > > > >>>>>
> > > > >>>>>If anyone has a better idea I would love to hear it.
> > > > >>>>>
> > > > >>>>>Peter
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>David Lauberts wrote:
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>>Hi
> > > > >>>>>>
> > > > >>>>>>Wonder if someone has some words of wisdom.
> > > > >>>>>>
> > > > >>>>>>I have a access 2002 form that contains 2 graph objects that
> > > > >
> > > > > overlay
> > > > >
> > > > >>>>each
> > > > >>>>
> > > > >>>>
> > > > >>>>>>other and would like to export them as a JPEG to use in a
> > > > >
> > > > > presentation.
> > > > >
> > > > >>>>I
> > > > >>>>
> > > > >>>>
> > > > >>>>>>can do this individually for each graph but this does not[/color][/color]
> help[color=green][color=darkred]
> > > me
> > > > >
> > > > > as I
> > > > >
> > > > >>>>need
> > > > >>>>
> > > > >>>>
> > > > >>>>>>both on the same JPEG. I thought I would try an export the[/color][/color]
> form[color=green][color=darkred]
> > > > >
> > > > > that
> > > > >
> > > > >>>>>>contains both but I am having trouble. (My VBA is self[/color][/color]
> taught[color=green][color=darkred]
> > > and
> > > > >
> > > > > a
> > > > >
> > > > >>>>little
> > > > >>>>
> > > > >>>>
> > > > >>>>>>knowledge is dangerous). It is either impossible to do as[/color][/color]
> the[color=green][color=darkred]
> > > > >
> > > > > object
> > > > >
> > > > >>>>doesn't
> > > > >>>>
> > > > >>>>
> > > > >>>>>>support the action or I have the code wrong.
> > > > >>>>>>
> > > > >>>>>>I have tried looking through google through news groups,[/color][/color]
> there[color=green][color=darkred]
> > > is
> > > > >
> > > > > a lot
> > > > >
> > > > >>>>>>about IMPORTING jpegs into forms but can't find anything[/color][/color]
> about[color=green][color=darkred]
> > > > >
> > > > > exporting
> > > > >
> > > > >>>>a
> > > > >>>>
> > > > >>>>
> > > > >>>>>>form as a JPEG.
> > > > >>>>>>
> > > > >>>>>>The code I am using is:
> > > > >>>>>>
> > > > >>>>>>Function PictureTest()
> > > > >>>>>>Dim obj As Object
> > > > >>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> > > > >>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> > > > >>>>>> Set obj = Nothing
> > > > >>>>>>
> > > > >>>>>>End Function
> > > > >>>>>>
> > > > >>>>>>This works for each graph but not when I try :
> > > > >>>>>>
> > > > >>>>>>Set obj = Forms![frmGraph].Object
> > > > >>>>>>
> > > > >>>>>>or:
> > > > >>>>>>
> > > > >>>>>>Set obj = Forms![frmGraph]
> > > > >>>>>>
> > > > >>>>>>Any pearls of wisdom would be appreciated
> > > > >>>>>>
> > > > >>>>>>Regards
> > > > >>>>>>Dave
> > > > >>>>>>
> > > > >>>>>>
> > > > >>>>>
> > > > >>>Wayne Gillespie
> > > > >>>Gosford NSW Australia
> > > > >>
> > > > >
> > > >
> > >[/color]
> >
> >[/color]
>[/color]

Stephen

Thanks for taking the time to respond.

Yes, on the form on one is a 'background' graph and one overlays it in the
'fore ground'. I can get each graph out as a JPEG, GIF or TIF and if I could
combine them so they 'overlay' each other that would great.

I have looked at your website - would I be right in saying the code to be
modified is contained in A2KExportOLEtoJPEG.zip in Misc?

Regards
Dave

"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>
wrote in message news:Y9hqb.8361$R13.465338@ursa-nb00s0.nbnet.nb.ca...[color=blue]
> SO you simply want to able to programmatically combine the 2 exported
> jpeg images of the graphs into one single Jpeg? You could modify a bit
> of code from my site to easily do this.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "David Lauberts" <david.lauberts@ntlworld.com> wrote in message
> news:tLWpb.1131$CJ1.310@newsfep1-gui.server.ntli.net...[color=green]
> > Hi Stephen
> >
> > From my point of view I have 2 graphs on a form, exporting the whole[/color]
> form as[color=green]
> > a JPEG would solve my problem going forward though I have used Peter's[/color]
> Print[color=green]
> > screen as a temporary measure for the moment. It would be ideal if[/color]
> there was[color=green]
> > some code to drop 2 graph objects on a form into a JPEG but if there[/color]
> is a[color=green]
> > way I don't seem able to acheive it.
> >
> > Dave
> > "Stephen Lebans"[/color]
> <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>[color=green]
> > wrote in message news:5iQpb.7408$R13.416379@ursa-nb00s0.nbnet.nb.ca...[color=darkred]
> > > There might be a very simple solution depending on:
> > > 1) What is the output resolution of your label printer?
> > > 2) What version of WIndows are you running?
> > > 3) What version of Access?
> > > 4) What is the current display resolution of the monitor previewing[/color][/color]
> the[color=green][color=darkred]
> > > report?
> > >
> > > I have code here somewhere that can copy the Report Print Preview[/color][/color]
> window[color=green][color=darkred]
> > > to a disk based Image file. SInce your output area is only 4 inches[/color][/color]
> by 4[color=green][color=darkred]
> > > inches, depending on your screen resolution and the printers output
> > > resolution(I'm guessing it is only 198 DPI), you may be able to[/color][/color]
> simply[color=green][color=darkred]
> > > capture the Print Preview window.
> > >
> > > Alternatively, the ReportUtilites on my site can output each page at
> > > full printer resolution to an ENhanced Metafile. It would only take[/color][/color]
> a[color=green][color=darkred]
> > > bit mroe work instead save these EMF's programmatically to a Bitmap[/color][/color]
> or[color=green][color=darkred]
> > > Jpeg file.
> > >
> > > --
> > >
> > > HTH
> > > Stephen Lebans
> > > http://www.lebans.com
> > > Access Code, Tips and Tricks
> > > Please respond only to the newsgroups so everyone can benefit.
> > >
> > >
> > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > > news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...
> > > > Stephen,
> > > >
> > > > We have a data base of recipes and ingredients. Using MSAccess we
> > > > construct a label which includes all the legally required
> > > > information. The label information is designed to be printed onto[/color][/color]
> a[color=green][color=darkred]
> > > > preprinted base label by a label printer on a packaging machine.[/color][/color]
> One[color=green][color=darkred]
> > > > label printer (Intermec, in fact we wrote our own label design
> > > > software for the Intermec using MSAccess) is able to handle a
> > > > MSAccess report format, and one label printer (Hapa) is able to
> > > > handle the image as .pdf, however our other label printers
> > > > (Smartdates and Easycoders) require a graphics image.
> > > >
> > > > The nutritional panel has a prescribed format which includes[/color][/color]
> columns[color=green][color=darkred]
> > > > of data and boxes.
> > > >
> > > > The label includes the ingredient statement, the allergens and the
> > > > nutritional panel all of which are calculated each time the label[/color][/color]
> is[color=green][color=darkred]
> > > > printed, to ensure that any changes to the underlying recipe have
> > > > been updated on the label. Our system overcomes the possibility of[/color][/color]
> a[color=green][color=darkred]
> > > > product recall because of a change in a recipe not being
> > > > incorporated into the data on the label.
> > > >
> > > > We have a nominal range of just under 500,000 products, so it is
> > > > more convenient to generate the label and the carton label at the
> > > > time a particular product is made. All products are crosschecked
> > > > (Recipe barcode, label barcode, carton barcode, packaging machine
> > > > barcode and the storage coolroom barcode) by a wireless Intermec
> > > > barcode system which is integrated into our MSAccess system which
> > > > also updates our accounting system via the MSAccess ODBC driver.
> > > >
> > > > So basically the problem is being able to output a whole MSAccess
> > > > report page (it is only 100mm x 100mm) as a bitmap image.
> > > >
> > > > Thanks
> > > >
> > > > Peter
> > > >
> > > >
> > > >
> > > > Stephen Lebans wrote:
> > > > > Peter I'm not sure exactly what process are you trying to[/color][/color]
> automate.[color=green][color=darkred]
> > > DO
> > > > > you need to export the image of 2 Graphs contained on a Form and
> > > then
> > > > > save this output as a single Jpeg file? Is it just the graphs[/color][/color]
> you[color=green][color=darkred]
> > > want
> > > > > exported or the whole Form as it appears on the screen?
> > > > >
> > > > > --
> > > > >
> > > > > HTH
> > > > > Stephen Lebans
> > > > > http://www.lebans.com
> > > > > Access Code, Tips and Tricks
> > > > > Please respond only to the newsgroups so everyone can benefit.
> > > > >
> > > > >
> > > > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > > > > news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
> > > > >
> > > > >>Wayne,
> > > > >>
> > > > >>Thanks for your information. It does not change much. The[/color][/color]
> MSAccess[color=green][color=darkred]
> > > > >>report still has to be copied using non-MSAccess software and[/color][/color]
> then[color=green][color=darkred]
> > > > >>worked on to produce a useable graphic image.
> > > > >>
> > > > >>We use online printing equipment, that refer to the MSAccess
> > > > >>database for the information to print. It would be nice if the[/color][/color]
> whole[color=green][color=darkred]
> > > > >>of the label information generated by MSAccess could be uplifted
> > > > >>directly from the report.
> > > > >>
> > > > >>One of our printers has Swiss software that is able to handle[/color][/color]
> .pdf[color=green][color=darkred]
> > > > >>files directly, that makes the process a little easier.
> > > > >>Unfortunately the others are looking for a graphics image.
> > > > >>
> > > > >>Please note an error in my reply to David. The .jpg files would[/color][/color]
> need[color=green][color=darkred]
> > > > >>to be exported from CorelDraw, not saved.
> > > > >>
> > > > >>We hope that at some time in the future MSAccess may incorporate
> > > > >>some basic graphics interfaces.
> > > > >>
> > > > >>Regards
> > > > >>
> > > > >>Peter
> > > > >>
> > > > >>Wayne Gillespie wrote:
> > > > >>
> > > > >>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
> > > > >
> > > > > <david.lauberts@ntlworld.com> wrote:
> > > > >
> > > > >>>You could try Stephen Lebans site
> > > > >
> > > > > http://www.lebans.com/ReportUtilities.htm his Report Utilies
> > > download
> > > > > allows you to save a report as an EMF or WMF
> > > > >
> > > > >>>file. This file could then be converted to a jpg if required.
> > > > >>>You would have to build a report showing your graphs in order[/color][/color]
> to[color=green][color=darkred]
> > > use
> > > > >
> > > > > this method. The easiest way to do this is to right click on[/color][/color]
> your[color=green][color=darkred]
> > > form
> > > > > in the
> > > > >
> > > > >>>database window and select "Save As Report". This will create a[/color][/color]
> new[color=green][color=darkred]
> > > > >
> > > > > report based on your form which you can edit to suit your needs.
> > > > >
> > > > >>>
> > > > >>>
> > > > >>>>Peter
> > > > >>>>
> > > > >>>>I used print screen and MS Paint, thanks for the tip, but I[/color][/color]
> was[color=green][color=darkred]
> > > just
> > > > >>>>wondering if the was a way to do it directly using vb using a
> > > > >
> > > > > command button
> > > > >
> > > > >>>>for future work.
> > > > >>>>
> > > > >>>>Anyone know if it can be done?
> > > > >>>>
> > > > >>>>Regards
> > > > >>>>Dave
> > > > >>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in[/color][/color]
> message[color=green][color=darkred]
> > > > >>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> > > > >>>>
> > > > >>>>
> > > > >>>>>Hi David,
> > > > >>>>>
> > > > >>>>>The only options I have found to convert a MS Access report[/color][/color]
> as a[color=green][color=darkred]
> > > > >>>>>graphic into something useable by any other software:
> > > > >>>>>
> > > > >>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
> > > > >>>>>CorelDraw / save as .jpg
> > > > >>>>>
> > > > >>>>>or
> > > > >>>>>
> > > > >>>>>Print Screen / paste into CorelDraw (or other graphics[/color][/color]
> program)/[color=green][color=darkred]
> > > > >>>>>edit bitmap / crop bitmap (to eliminate what is not required[/color][/color]
> on[color=green][color=darkred]
> > > the
> > > > >>>>>screen) / save as .jpg
> > > > >>>>>
> > > > >>>>>If anyone has a better idea I would love to hear it.
> > > > >>>>>
> > > > >>>>>Peter
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>David Lauberts wrote:
> > > > >>>>>
> > > > >>>>>
> > > > >>>>>>Hi
> > > > >>>>>>
> > > > >>>>>>Wonder if someone has some words of wisdom.
> > > > >>>>>>
> > > > >>>>>>I have a access 2002 form that contains 2 graph objects that
> > > > >
> > > > > overlay
> > > > >
> > > > >>>>each
> > > > >>>>
> > > > >>>>
> > > > >>>>>>other and would like to export them as a JPEG to use in a
> > > > >
> > > > > presentation.
> > > > >
> > > > >>>>I
> > > > >>>>
> > > > >>>>
> > > > >>>>>>can do this individually for each graph but this does not[/color][/color]
> help[color=green][color=darkred]
> > > me
> > > > >
> > > > > as I
> > > > >
> > > > >>>>need
> > > > >>>>
> > > > >>>>
> > > > >>>>>>both on the same JPEG. I thought I would try an export the[/color][/color]
> form[color=green][color=darkred]
> > > > >
> > > > > that
> > > > >
> > > > >>>>>>contains both but I am having trouble. (My VBA is self[/color][/color]
> taught[color=green][color=darkred]
> > > and
> > > > >
> > > > > a
> > > > >
> > > > >>>>little
> > > > >>>>
> > > > >>>>
> > > > >>>>>>knowledge is dangerous). It is either impossible to do as[/color][/color]
> the[color=green][color=darkred]
> > > > >
> > > > > object
> > > > >
> > > > >>>>doesn't
> > > > >>>>
> > > > >>>>
> > > > >>>>>>support the action or I have the code wrong.
> > > > >>>>>>
> > > > >>>>>>I have tried looking through google through news groups,[/color][/color]
> there[color=green][color=darkred]
> > > is
> > > > >
> > > > > a lot
> > > > >
> > > > >>>>>>about IMPORTING jpegs into forms but can't find anything[/color][/color]
> about[color=green][color=darkred]
> > > > >
> > > > > exporting
> > > > >
> > > > >>>>a
> > > > >>>>
> > > > >>>>
> > > > >>>>>>form as a JPEG.
> > > > >>>>>>
> > > > >>>>>>The code I am using is:
> > > > >>>>>>
> > > > >>>>>>Function PictureTest()
> > > > >>>>>>Dim obj As Object
> > > > >>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> > > > >>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> > > > >>>>>> Set obj = Nothing
> > > > >>>>>>
> > > > >>>>>>End Function
> > > > >>>>>>
> > > > >>>>>>This works for each graph but not when I try :
> > > > >>>>>>
> > > > >>>>>>Set obj = Forms![frmGraph].Object
> > > > >>>>>>
> > > > >>>>>>or:
> > > > >>>>>>
> > > > >>>>>>Set obj = Forms![frmGraph]
> > > > >>>>>>
> > > > >>>>>>Any pearls of wisdom would be appreciated
> > > > >>>>>>
> > > > >>>>>>Regards
> > > > >>>>>>Dave
> > > > >>>>>>
> > > > >>>>>>
> > > > >>>>>
> > > > >>>Wayne Gillespie
> > > > >>>Gosford NSW Australia
> > > > >>
> > > > >
> > > >
> > >[/color]
> >
> >[/color]
>[/color]

YOu would use the VBPictureBox class on my site.
Create three instances of the class
Load the 2 saved Jpeg images into individual instances of the class
Resize the blank third instance of the class to enable it to contain the
Image dimensions from the first two instances.
Blit the contents of the first two classes into the third
Save the third instance to disk as a Bitmap file

All of the required methods and properties are exposed by the
vbPictureBox class.
http://www.lebans.com/imageclass.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"David Lauberts" <david.lauberts@ntlworld.com> wrote in message
news:wlzqb.1381$us.824@newsfep3-gui.server.ntli.net...[color=blue]
> Stephen
>
> Thanks for taking the time to respond.
>
> Yes, on the form on one is a 'background' graph and one overlays it in[/color]
the[color=blue]
> 'fore ground'. I can get each graph out as a JPEG, GIF or TIF and if I[/color]
could[color=blue]
> combine them so they 'overlay' each other that would great.
>
> I have looked at your website - would I be right in saying the code to[/color]
be[color=blue]
> modified is contained in A2KExportOLEtoJPEG.zip in Misc?
>
> Regards
> Dave
>
> "Stephen Lebans"[/color]
<ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>[color=blue]
> wrote in message news:Y9hqb.8361$R13.465338@ursa-nb00s0.nbnet.nb.ca...[color=green]
> > SO you simply want to able to programmatically combine the 2[/color][/color]
exported[color=blue][color=green]
> > jpeg images of the graphs into one single Jpeg? You could modify a[/color][/color]
bit[color=blue][color=green]
> > of code from my site to easily do this.
> >
> > --
> >
> > HTH
> > Stephen Lebans
> > http://www.lebans.com
> > Access Code, Tips and Tricks
> > Please respond only to the newsgroups so everyone can benefit.
> >
> >
> > "David Lauberts" <david.lauberts@ntlworld.com> wrote in message
> > news:tLWpb.1131$CJ1.310@newsfep1-gui.server.ntli.net...[color=darkred]
> > > Hi Stephen
> > >
> > > From my point of view I have 2 graphs on a form, exporting the[/color][/color][/color]
whole[color=blue][color=green]
> > form as[color=darkred]
> > > a JPEG would solve my problem going forward though I have used[/color][/color][/color]
Peter's[color=blue][color=green]
> > Print[color=darkred]
> > > screen as a temporary measure for the moment. It would be ideal if[/color]
> > there was[color=darkred]
> > > some code to drop 2 graph objects on a form into a JPEG but if[/color][/color][/color]
there[color=blue][color=green]
> > is a[color=darkred]
> > > way I don't seem able to acheive it.
> > >
> > > Dave
> > > "Stephen Lebans"[/color]
> > <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>[color=darkred]
> > > wrote in message[/color][/color][/color]
news:5iQpb.7408$R13.416379@ursa-nb00s0.nbnet.nb.ca...[color=blue][color=green][color=darkred]
> > > > There might be a very simple solution depending on:
> > > > 1) What is the output resolution of your label printer?
> > > > 2) What version of WIndows are you running?
> > > > 3) What version of Access?
> > > > 4) What is the current display resolution of the monitor[/color][/color][/color]
previewing[color=blue][color=green]
> > the[color=darkred]
> > > > report?
> > > >
> > > > I have code here somewhere that can copy the Report Print[/color][/color][/color]
Preview[color=blue][color=green]
> > window[color=darkred]
> > > > to a disk based Image file. SInce your output area is only 4[/color][/color][/color]
inches[color=blue][color=green]
> > by 4[color=darkred]
> > > > inches, depending on your screen resolution and the printers[/color][/color][/color]
output[color=blue][color=green][color=darkred]
> > > > resolution(I'm guessing it is only 198 DPI), you may be able to[/color]
> > simply[color=darkred]
> > > > capture the Print Preview window.
> > > >
> > > > Alternatively, the ReportUtilites on my site can output each[/color][/color][/color]
page at[color=blue][color=green][color=darkred]
> > > > full printer resolution to an ENhanced Metafile. It would only[/color][/color][/color]
take[color=blue][color=green]
> > a[color=darkred]
> > > > bit mroe work instead save these EMF's programmatically to a[/color][/color][/color]
Bitmap[color=blue][color=green]
> > or[color=darkred]
> > > > Jpeg file.
> > > >
> > > > --
> > > >
> > > > HTH
> > > > Stephen Lebans
> > > > http://www.lebans.com
> > > > Access Code, Tips and Tricks
> > > > Please respond only to the newsgroups so everyone can benefit.
> > > >
> > > >
> > > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > > > news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...
> > > > > Stephen,
> > > > >
> > > > > We have a data base of recipes and ingredients. Using MSAccess[/color][/color][/color]
we[color=blue][color=green][color=darkred]
> > > > > construct a label which includes all the legally required
> > > > > information. The label information is designed to be printed[/color][/color][/color]
onto[color=blue][color=green]
> > a[color=darkred]
> > > > > preprinted base label by a label printer on a packaging[/color][/color][/color]
machine.[color=blue][color=green]
> > One[color=darkred]
> > > > > label printer (Intermec, in fact we wrote our own label design
> > > > > software for the Intermec using MSAccess) is able to handle a
> > > > > MSAccess report format, and one label printer (Hapa) is able[/color][/color][/color]
to[color=blue][color=green][color=darkred]
> > > > > handle the image as .pdf, however our other label printers
> > > > > (Smartdates and Easycoders) require a graphics image.
> > > > >
> > > > > The nutritional panel has a prescribed format which includes[/color]
> > columns[color=darkred]
> > > > > of data and boxes.
> > > > >
> > > > > The label includes the ingredient statement, the allergens and[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > > > nutritional panel all of which are calculated each time the[/color][/color][/color]
label[color=blue][color=green]
> > is[color=darkred]
> > > > > printed, to ensure that any changes to the underlying recipe[/color][/color][/color]
have[color=blue][color=green][color=darkred]
> > > > > been updated on the label. Our system overcomes the[/color][/color][/color]
possibility of[color=blue][color=green]
> > a[color=darkred]
> > > > > product recall because of a change in a recipe not being
> > > > > incorporated into the data on the label.
> > > > >
> > > > > We have a nominal range of just under 500,000 products, so it[/color][/color][/color]
is[color=blue][color=green][color=darkred]
> > > > > more convenient to generate the label and the carton label at[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > > > time a particular product is made. All products are[/color][/color][/color]
crosschecked[color=blue][color=green][color=darkred]
> > > > > (Recipe barcode, label barcode, carton barcode, packaging[/color][/color][/color]
machine[color=blue][color=green][color=darkred]
> > > > > barcode and the storage coolroom barcode) by a wireless[/color][/color][/color]
Intermec[color=blue][color=green][color=darkred]
> > > > > barcode system which is integrated into our MSAccess system[/color][/color][/color]
which[color=blue][color=green][color=darkred]
> > > > > also updates our accounting system via the MSAccess ODBC[/color][/color][/color]
driver.[color=blue][color=green][color=darkred]
> > > > >
> > > > > So basically the problem is being able to output a whole[/color][/color][/color]
MSAccess[color=blue][color=green][color=darkred]
> > > > > report page (it is only 100mm x 100mm) as a bitmap image.
> > > > >
> > > > > Thanks
> > > > >
> > > > > Peter
> > > > >
> > > > >
> > > > >
> > > > > Stephen Lebans wrote:
> > > > > > Peter I'm not sure exactly what process are you trying to[/color]
> > automate.[color=darkred]
> > > > DO
> > > > > > you need to export the image of 2 Graphs contained on a Form[/color][/color][/color]
and[color=blue][color=green][color=darkred]
> > > > then
> > > > > > save this output as a single Jpeg file? Is it just the[/color][/color][/color]
graphs[color=blue][color=green]
> > you[color=darkred]
> > > > want
> > > > > > exported or the whole Form as it appears on the screen?
> > > > > >
> > > > > > --
> > > > > >
> > > > > > HTH
> > > > > > Stephen Lebans
> > > > > > http://www.lebans.com
> > > > > > Access Code, Tips and Tricks
> > > > > > Please respond only to the newsgroups so everyone can[/color][/color][/color]
benefit.[color=blue][color=green][color=darkred]
> > > > > >
> > > > > >
> > > > > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in[/color][/color][/color]
message[color=blue][color=green][color=darkred]
> > > > > > news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
> > > > > >
> > > > > >>Wayne,
> > > > > >>
> > > > > >>Thanks for your information. It does not change much. The[/color]
> > MSAccess[color=darkred]
> > > > > >>report still has to be copied using non-MSAccess software[/color][/color][/color]
and[color=blue][color=green]
> > then[color=darkred]
> > > > > >>worked on to produce a useable graphic image.
> > > > > >>
> > > > > >>We use online printing equipment, that refer to the MSAccess
> > > > > >>database for the information to print. It would be nice if[/color][/color][/color]
the[color=blue][color=green]
> > whole[color=darkred]
> > > > > >>of the label information generated by MSAccess could be[/color][/color][/color]
uplifted[color=blue][color=green][color=darkred]
> > > > > >>directly from the report.
> > > > > >>
> > > > > >>One of our printers has Swiss software that is able to[/color][/color][/color]
handle[color=blue][color=green]
> > .pdf[color=darkred]
> > > > > >>files directly, that makes the process a little easier.
> > > > > >>Unfortunately the others are looking for a graphics image.
> > > > > >>
> > > > > >>Please note an error in my reply to David. The .jpg files[/color][/color][/color]
would[color=blue][color=green]
> > need[color=darkred]
> > > > > >>to be exported from CorelDraw, not saved.
> > > > > >>
> > > > > >>We hope that at some time in the future MSAccess may[/color][/color][/color]
incorporate[color=blue][color=green][color=darkred]
> > > > > >>some basic graphics interfaces.
> > > > > >>
> > > > > >>Regards
> > > > > >>
> > > > > >>Peter
> > > > > >>
> > > > > >>Wayne Gillespie wrote:
> > > > > >>
> > > > > >>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
> > > > > >
> > > > > > <david.lauberts@ntlworld.com> wrote:
> > > > > >
> > > > > >>>You could try Stephen Lebans site
> > > > > >
> > > > > > http://www.lebans.com/ReportUtilities.htm his Report Utilies
> > > > download
> > > > > > allows you to save a report as an EMF or WMF
> > > > > >
> > > > > >>>file. This file could then be converted to a jpg if[/color][/color][/color]
required.[color=blue][color=green][color=darkred]
> > > > > >>>You would have to build a report showing your graphs in[/color][/color][/color]
order[color=blue][color=green]
> > to[color=darkred]
> > > > use
> > > > > >
> > > > > > this method. The easiest way to do this is to right click on[/color]
> > your[color=darkred]
> > > > form
> > > > > > in the
> > > > > >
> > > > > >>>database window and select "Save As Report". This will[/color][/color][/color]
create a[color=blue][color=green]
> > new[color=darkred]
> > > > > >
> > > > > > report based on your form which you can edit to suit your[/color][/color][/color]
needs.[color=blue][color=green][color=darkred]
> > > > > >
> > > > > >>>
> > > > > >>>
> > > > > >>>>Peter
> > > > > >>>>
> > > > > >>>>I used print screen and MS Paint, thanks for the tip, but[/color][/color][/color]
I[color=blue][color=green]
> > was[color=darkred]
> > > > just
> > > > > >>>>wondering if the was a way to do it directly using vb[/color][/color][/color]
using a[color=blue][color=green][color=darkred]
> > > > > >
> > > > > > command button
> > > > > >
> > > > > >>>>for future work.
> > > > > >>>>
> > > > > >>>>Anyone know if it can be done?
> > > > > >>>>
> > > > > >>>>Regards
> > > > > >>>>Dave
> > > > > >>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in[/color]
> > message[color=darkred]
> > > > > >>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> > > > > >>>>
> > > > > >>>>
> > > > > >>>>>Hi David,
> > > > > >>>>>
> > > > > >>>>>The only options I have found to convert a MS Access[/color][/color][/color]
report[color=blue][color=green]
> > as a[color=darkred]
> > > > > >>>>>graphic into something useable by any other software:
> > > > > >>>>>
> > > > > >>>>>Convert to .pdf using Acrobat Writer and then open .pdf[/color][/color][/color]
using[color=blue][color=green][color=darkred]
> > > > > >>>>>CorelDraw / save as .jpg
> > > > > >>>>>
> > > > > >>>>>or
> > > > > >>>>>
> > > > > >>>>>Print Screen / paste into CorelDraw (or other graphics[/color]
> > program)/[color=darkred]
> > > > > >>>>>edit bitmap / crop bitmap (to eliminate what is not[/color][/color][/color]
required[color=blue][color=green]
> > on[color=darkred]
> > > > the
> > > > > >>>>>screen) / save as .jpg
> > > > > >>>>>
> > > > > >>>>>If anyone has a better idea I would love to hear it.
> > > > > >>>>>
> > > > > >>>>>Peter
> > > > > >>>>>
> > > > > >>>>>
> > > > > >>>>>
> > > > > >>>>>David Lauberts wrote:
> > > > > >>>>>
> > > > > >>>>>
> > > > > >>>>>>Hi
> > > > > >>>>>>
> > > > > >>>>>>Wonder if someone has some words of wisdom.
> > > > > >>>>>>
> > > > > >>>>>>I have a access 2002 form that contains 2 graph objects[/color][/color][/color]
that[color=blue][color=green][color=darkred]
> > > > > >
> > > > > > overlay
> > > > > >
> > > > > >>>>each
> > > > > >>>>
> > > > > >>>>
> > > > > >>>>>>other and would like to export them as a JPEG to use in[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> > > > > >
> > > > > > presentation.
> > > > > >
> > > > > >>>>I
> > > > > >>>>
> > > > > >>>>
> > > > > >>>>>>can do this individually for each graph but this does[/color][/color][/color]
not[color=blue][color=green]
> > help[color=darkred]
> > > > me
> > > > > >
> > > > > > as I
> > > > > >
> > > > > >>>>need
> > > > > >>>>
> > > > > >>>>
> > > > > >>>>>>both on the same JPEG. I thought I would try an export[/color][/color][/color]
the[color=blue][color=green]
> > form[color=darkred]
> > > > > >
> > > > > > that
> > > > > >
> > > > > >>>>>>contains both but I am having trouble. (My VBA is self[/color]
> > taught[color=darkred]
> > > > and
> > > > > >
> > > > > > a
> > > > > >
> > > > > >>>>little
> > > > > >>>>
> > > > > >>>>
> > > > > >>>>>>knowledge is dangerous). It is either impossible to do[/color][/color][/color]
as[color=blue][color=green]
> > the[color=darkred]
> > > > > >
> > > > > > object
> > > > > >
> > > > > >>>>doesn't
> > > > > >>>>
> > > > > >>>>
> > > > > >>>>>>support the action or I have the code wrong.
> > > > > >>>>>>
> > > > > >>>>>>I have tried looking through google through news groups,[/color]
> > there[color=darkred]
> > > > is
> > > > > >
> > > > > > a lot
> > > > > >
> > > > > >>>>>>about IMPORTING jpegs into forms but can't find anything[/color]
> > about[color=darkred]
> > > > > >
> > > > > > exporting
> > > > > >
> > > > > >>>>a
> > > > > >>>>
> > > > > >>>>
> > > > > >>>>>>form as a JPEG.
> > > > > >>>>>>
> > > > > >>>>>>The code I am using is:
> > > > > >>>>>>
> > > > > >>>>>>Function PictureTest()
> > > > > >>>>>>Dim obj As Object
> > > > > >>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> > > > > >>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> > > > > >>>>>> Set obj = Nothing
> > > > > >>>>>>
> > > > > >>>>>>End Function
> > > > > >>>>>>
> > > > > >>>>>>This works for each graph but not when I try :
> > > > > >>>>>>
> > > > > >>>>>>Set obj = Forms![frmGraph].Object
> > > > > >>>>>>
> > > > > >>>>>>or:
> > > > > >>>>>>
> > > > > >>>>>>Set obj = Forms![frmGraph]
> > > > > >>>>>>
> > > > > >>>>>>Any pearls of wisdom would be appreciated
> > > > > >>>>>>
> > > > > >>>>>>Regards
> > > > > >>>>>>Dave
> > > > > >>>>>>
> > > > > >>>>>>
> > > > > >>>>>
> > > > > >>>Wayne Gillespie
> > > > > >>>Gosford NSW Australia
> > > > > >>
> > > > > >
> > > > >
> > > >
> > >
> > >[/color]
> >[/color]
>
>[/color]

Thanks Stephen

Looks like an interesting Job for the weekend!

Let you know how I get on

Dave
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>
wrote in message news:cPBqb.8937$R13.490659@ursa-nb00s0.nbnet.nb.ca...[color=blue]
> YOu would use the VBPictureBox class on my site.
> Create three instances of the class
> Load the 2 saved Jpeg images into individual instances of the class
> Resize the blank third instance of the class to enable it to contain the
> Image dimensions from the first two instances.
> Blit the contents of the first two classes into the third
> Save the third instance to disk as a Bitmap file
>
> All of the required methods and properties are exposed by the
> vbPictureBox class.
> http://www.lebans.com/imageclass.htm
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "David Lauberts" <david.lauberts@ntlworld.com> wrote in message
> news:wlzqb.1381$us.824@newsfep3-gui.server.ntli.net...[color=green]
> > Stephen
> >
> > Thanks for taking the time to respond.
> >
> > Yes, on the form on one is a 'background' graph and one overlays it in[/color]
> the[color=green]
> > 'fore ground'. I can get each graph out as a JPEG, GIF or TIF and if I[/color]
> could[color=green]
> > combine them so they 'overlay' each other that would great.
> >
> > I have looked at your website - would I be right in saying the code to[/color]
> be[color=green]
> > modified is contained in A2KExportOLEtoJPEG.zip in Misc?
> >
> > Regards
> > Dave
> >
> > "Stephen Lebans"[/color]
> <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>[color=green]
> > wrote in message news:Y9hqb.8361$R13.465338@ursa-nb00s0.nbnet.nb.ca...[color=darkred]
> > > SO you simply want to able to programmatically combine the 2[/color][/color]
> exported[color=green][color=darkred]
> > > jpeg images of the graphs into one single Jpeg? You could modify a[/color][/color]
> bit[color=green][color=darkred]
> > > of code from my site to easily do this.
> > >
> > > --
> > >
> > > HTH
> > > Stephen Lebans
> > > http://www.lebans.com
> > > Access Code, Tips and Tricks
> > > Please respond only to the newsgroups so everyone can benefit.
> > >
> > >
> > > "David Lauberts" <david.lauberts@ntlworld.com> wrote in message
> > > news:tLWpb.1131$CJ1.310@newsfep1-gui.server.ntli.net...
> > > > Hi Stephen
> > > >
> > > > From my point of view I have 2 graphs on a form, exporting the[/color][/color]
> whole[color=green][color=darkred]
> > > form as
> > > > a JPEG would solve my problem going forward though I have used[/color][/color]
> Peter's[color=green][color=darkred]
> > > Print
> > > > screen as a temporary measure for the moment. It would be ideal if
> > > there was
> > > > some code to drop 2 graph objects on a form into a JPEG but if[/color][/color]
> there[color=green][color=darkred]
> > > is a
> > > > way I don't seem able to acheive it.
> > > >
> > > > Dave
> > > > "Stephen Lebans"
> > > <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>
> > > > wrote in message[/color][/color]
> news:5iQpb.7408$R13.416379@ursa-nb00s0.nbnet.nb.ca...[color=green][color=darkred]
> > > > > There might be a very simple solution depending on:
> > > > > 1) What is the output resolution of your label printer?
> > > > > 2) What version of WIndows are you running?
> > > > > 3) What version of Access?
> > > > > 4) What is the current display resolution of the monitor[/color][/color]
> previewing[color=green][color=darkred]
> > > the
> > > > > report?
> > > > >
> > > > > I have code here somewhere that can copy the Report Print[/color][/color]
> Preview[color=green][color=darkred]
> > > window
> > > > > to a disk based Image file. SInce your output area is only 4[/color][/color]
> inches[color=green][color=darkred]
> > > by 4
> > > > > inches, depending on your screen resolution and the printers[/color][/color]
> output[color=green][color=darkred]
> > > > > resolution(I'm guessing it is only 198 DPI), you may be able to
> > > simply
> > > > > capture the Print Preview window.
> > > > >
> > > > > Alternatively, the ReportUtilites on my site can output each[/color][/color]
> page at[color=green][color=darkred]
> > > > > full printer resolution to an ENhanced Metafile. It would only[/color][/color]
> take[color=green][color=darkred]
> > > a
> > > > > bit mroe work instead save these EMF's programmatically to a[/color][/color]
> Bitmap[color=green][color=darkred]
> > > or
> > > > > Jpeg file.
> > > > >
> > > > > --
> > > > >
> > > > > HTH
> > > > > Stephen Lebans
> > > > > http://www.lebans.com
> > > > > Access Code, Tips and Tricks
> > > > > Please respond only to the newsgroups so everyone can benefit.
> > > > >
> > > > >
> > > > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> > > > > news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...
> > > > > > Stephen,
> > > > > >
> > > > > > We have a data base of recipes and ingredients. Using MSAccess[/color][/color]
> we[color=green][color=darkred]
> > > > > > construct a label which includes all the legally required
> > > > > > information. The label information is designed to be printed[/color][/color]
> onto[color=green][color=darkred]
> > > a
> > > > > > preprinted base label by a label printer on a packaging[/color][/color]
> machine.[color=green][color=darkred]
> > > One
> > > > > > label printer (Intermec, in fact we wrote our own label design
> > > > > > software for the Intermec using MSAccess) is able to handle a
> > > > > > MSAccess report format, and one label printer (Hapa) is able[/color][/color]
> to[color=green][color=darkred]
> > > > > > handle the image as .pdf, however our other label printers
> > > > > > (Smartdates and Easycoders) require a graphics image.
> > > > > >
> > > > > > The nutritional panel has a prescribed format which includes
> > > columns
> > > > > > of data and boxes.
> > > > > >
> > > > > > The label includes the ingredient statement, the allergens and[/color][/color]
> the[color=green][color=darkred]
> > > > > > nutritional panel all of which are calculated each time the[/color][/color]
> label[color=green][color=darkred]
> > > is
> > > > > > printed, to ensure that any changes to the underlying recipe[/color][/color]
> have[color=green][color=darkred]
> > > > > > been updated on the label. Our system overcomes the[/color][/color]
> possibility of[color=green][color=darkred]
> > > a
> > > > > > product recall because of a change in a recipe not being
> > > > > > incorporated into the data on the label.
> > > > > >
> > > > > > We have a nominal range of just under 500,000 products, so it[/color][/color]
> is[color=green][color=darkred]
> > > > > > more convenient to generate the label and the carton label at[/color][/color]
> the[color=green][color=darkred]
> > > > > > time a particular product is made. All products are[/color][/color]
> crosschecked[color=green][color=darkred]
> > > > > > (Recipe barcode, label barcode, carton barcode, packaging[/color][/color]
> machine[color=green][color=darkred]
> > > > > > barcode and the storage coolroom barcode) by a wireless[/color][/color]
> Intermec[color=green][color=darkred]
> > > > > > barcode system which is integrated into our MSAccess system[/color][/color]
> which[color=green][color=darkred]
> > > > > > also updates our accounting system via the MSAccess ODBC[/color][/color]
> driver.[color=green][color=darkred]
> > > > > >
> > > > > > So basically the problem is being able to output a whole[/color][/color]
> MSAccess[color=green][color=darkred]
> > > > > > report page (it is only 100mm x 100mm) as a bitmap image.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > > Peter
> > > > > >
> > > > > >
> > > > > >
> > > > > > Stephen Lebans wrote:
> > > > > > > Peter I'm not sure exactly what process are you trying to
> > > automate.
> > > > > DO
> > > > > > > you need to export the image of 2 Graphs contained on a Form[/color][/color]
> and[color=green][color=darkred]
> > > > > then
> > > > > > > save this output as a single Jpeg file? Is it just the[/color][/color]
> graphs[color=green][color=darkred]
> > > you
> > > > > want
> > > > > > > exported or the whole Form as it appears on the screen?
> > > > > > >
> > > > > > > --
> > > > > > >
> > > > > > > HTH
> > > > > > > Stephen Lebans
> > > > > > > http://www.lebans.com
> > > > > > > Access Code, Tips and Tricks
> > > > > > > Please respond only to the newsgroups so everyone can[/color][/color]
> benefit.[color=green][color=darkred]
> > > > > > >
> > > > > > >
> > > > > > > "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in[/color][/color]
> message[color=green][color=darkred]
> > > > > > > news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
> > > > > > >
> > > > > > >>Wayne,
> > > > > > >>
> > > > > > >>Thanks for your information. It does not change much. The
> > > MSAccess
> > > > > > >>report still has to be copied using non-MSAccess software[/color][/color]
> and[color=green][color=darkred]
> > > then
> > > > > > >>worked on to produce a useable graphic image.
> > > > > > >>
> > > > > > >>We use online printing equipment, that refer to the MSAccess
> > > > > > >>database for the information to print. It would be nice if[/color][/color]
> the[color=green][color=darkred]
> > > whole
> > > > > > >>of the label information generated by MSAccess could be[/color][/color]
> uplifted[color=green][color=darkred]
> > > > > > >>directly from the report.
> > > > > > >>
> > > > > > >>One of our printers has Swiss software that is able to[/color][/color]
> handle[color=green][color=darkred]
> > > .pdf
> > > > > > >>files directly, that makes the process a little easier.
> > > > > > >>Unfortunately the others are looking for a graphics image.
> > > > > > >>
> > > > > > >>Please note an error in my reply to David. The .jpg files[/color][/color]
> would[color=green][color=darkred]
> > > need
> > > > > > >>to be exported from CorelDraw, not saved.
> > > > > > >>
> > > > > > >>We hope that at some time in the future MSAccess may[/color][/color]
> incorporate[color=green][color=darkred]
> > > > > > >>some basic graphics interfaces.
> > > > > > >>
> > > > > > >>Regards
> > > > > > >>
> > > > > > >>Peter
> > > > > > >>
> > > > > > >>Wayne Gillespie wrote:
> > > > > > >>
> > > > > > >>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
> > > > > > >
> > > > > > > <david.lauberts@ntlworld.com> wrote:
> > > > > > >
> > > > > > >>>You could try Stephen Lebans site
> > > > > > >
> > > > > > > http://www.lebans.com/ReportUtilities.htm his Report Utilies
> > > > > download
> > > > > > > allows you to save a report as an EMF or WMF
> > > > > > >
> > > > > > >>>file. This file could then be converted to a jpg if[/color][/color]
> required.[color=green][color=darkred]
> > > > > > >>>You would have to build a report showing your graphs in[/color][/color]
> order[color=green][color=darkred]
> > > to
> > > > > use
> > > > > > >
> > > > > > > this method. The easiest way to do this is to right click on
> > > your
> > > > > form
> > > > > > > in the
> > > > > > >
> > > > > > >>>database window and select "Save As Report". This will[/color][/color]
> create a[color=green][color=darkred]
> > > new
> > > > > > >
> > > > > > > report based on your form which you can edit to suit your[/color][/color]
> needs.[color=green][color=darkred]
> > > > > > >
> > > > > > >>>
> > > > > > >>>
> > > > > > >>>>Peter
> > > > > > >>>>
> > > > > > >>>>I used print screen and MS Paint, thanks for the tip, but[/color][/color]
> I[color=green][color=darkred]
> > > was
> > > > > just
> > > > > > >>>>wondering if the was a way to do it directly using vb[/color][/color]
> using a[color=green][color=darkred]
> > > > > > >
> > > > > > > command button
> > > > > > >
> > > > > > >>>>for future work.
> > > > > > >>>>
> > > > > > >>>>Anyone know if it can be done?
> > > > > > >>>>
> > > > > > >>>>Regards
> > > > > > >>>>Dave
> > > > > > >>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in
> > > message
> > > > > > >>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
> > > > > > >>>>
> > > > > > >>>>
> > > > > > >>>>>Hi David,
> > > > > > >>>>>
> > > > > > >>>>>The only options I have found to convert a MS Access[/color][/color]
> report[color=green][color=darkred]
> > > as a
> > > > > > >>>>>graphic into something useable by any other software:
> > > > > > >>>>>
> > > > > > >>>>>Convert to .pdf using Acrobat Writer and then open .pdf[/color][/color]
> using[color=green][color=darkred]
> > > > > > >>>>>CorelDraw / save as .jpg
> > > > > > >>>>>
> > > > > > >>>>>or
> > > > > > >>>>>
> > > > > > >>>>>Print Screen / paste into CorelDraw (or other graphics
> > > program)/
> > > > > > >>>>>edit bitmap / crop bitmap (to eliminate what is not[/color][/color]
> required[color=green][color=darkred]
> > > on
> > > > > the
> > > > > > >>>>>screen) / save as .jpg
> > > > > > >>>>>
> > > > > > >>>>>If anyone has a better idea I would love to hear it.
> > > > > > >>>>>
> > > > > > >>>>>Peter
> > > > > > >>>>>
> > > > > > >>>>>
> > > > > > >>>>>
> > > > > > >>>>>David Lauberts wrote:
> > > > > > >>>>>
> > > > > > >>>>>
> > > > > > >>>>>>Hi
> > > > > > >>>>>>
> > > > > > >>>>>>Wonder if someone has some words of wisdom.
> > > > > > >>>>>>
> > > > > > >>>>>>I have a access 2002 form that contains 2 graph objects[/color][/color]
> that[color=green][color=darkred]
> > > > > > >
> > > > > > > overlay
> > > > > > >
> > > > > > >>>>each
> > > > > > >>>>
> > > > > > >>>>
> > > > > > >>>>>>other and would like to export them as a JPEG to use in[/color][/color]
> a[color=green][color=darkred]
> > > > > > >
> > > > > > > presentation.
> > > > > > >
> > > > > > >>>>I
> > > > > > >>>>
> > > > > > >>>>
> > > > > > >>>>>>can do this individually for each graph but this does[/color][/color]
> not[color=green][color=darkred]
> > > help
> > > > > me
> > > > > > >
> > > > > > > as I
> > > > > > >
> > > > > > >>>>need
> > > > > > >>>>
> > > > > > >>>>
> > > > > > >>>>>>both on the same JPEG. I thought I would try an export[/color][/color]
> the[color=green][color=darkred]
> > > form
> > > > > > >
> > > > > > > that
> > > > > > >
> > > > > > >>>>>>contains both but I am having trouble. (My VBA is self
> > > taught
> > > > > and
> > > > > > >
> > > > > > > a
> > > > > > >
> > > > > > >>>>little
> > > > > > >>>>
> > > > > > >>>>
> > > > > > >>>>>>knowledge is dangerous). It is either impossible to do[/color][/color]
> as[color=green][color=darkred]
> > > the
> > > > > > >
> > > > > > > object
> > > > > > >
> > > > > > >>>>doesn't
> > > > > > >>>>
> > > > > > >>>>
> > > > > > >>>>>>support the action or I have the code wrong.
> > > > > > >>>>>>
> > > > > > >>>>>>I have tried looking through google through news groups,
> > > there
> > > > > is
> > > > > > >
> > > > > > > a lot
> > > > > > >
> > > > > > >>>>>>about IMPORTING jpegs into forms but can't find anything
> > > about
> > > > > > >
> > > > > > > exporting
> > > > > > >
> > > > > > >>>>a
> > > > > > >>>>
> > > > > > >>>>
> > > > > > >>>>>>form as a JPEG.
> > > > > > >>>>>>
> > > > > > >>>>>>The code I am using is:
> > > > > > >>>>>>
> > > > > > >>>>>>Function PictureTest()
> > > > > > >>>>>>Dim obj As Object
> > > > > > >>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
> > > > > > >>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
> > > > > > >>>>>> Set obj = Nothing
> > > > > > >>>>>>
> > > > > > >>>>>>End Function
> > > > > > >>>>>>
> > > > > > >>>>>>This works for each graph but not when I try :
> > > > > > >>>>>>
> > > > > > >>>>>>Set obj = Forms![frmGraph].Object
> > > > > > >>>>>>
> > > > > > >>>>>>or:
> > > > > > >>>>>>
> > > > > > >>>>>>Set obj = Forms![frmGraph]
> > > > > > >>>>>>
> > > > > > >>>>>>Any pearls of wisdom would be appreciated
> > > > > > >>>>>>
> > > > > > >>>>>>Regards
> > > > > > >>>>>>Dave
> > > > > > >>>>>>
> > > > > > >>>>>>
> > > > > > >>>>>
> > > > > > >>>Wayne Gillespie
> > > > > > >>>Gosford NSW Australia
> > > > > > >>
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >[/color]
> >
> >[/color]
>[/color]

Many thanks for your information.

I had a problem during the loading of the bits and pieces that I
have not had time to get back to to resolve. Unfortunately some
systems documentation has a higher priority.

Thanks

Peter

Stephen Lebans wrote:[color=blue]
> Use the ReportUtilites on my site to export an EMF file, one for each
> page of the Report. THen you could simply write a couple of lines of
> code to load all of the exported EMF's into a StdPicture object and then
> use the SaveImage method to save the EMF's out to disk based Bitmap
> files.
> Here's some sample code:(requires setting a Reference to "OLE
> Automation". The file is "/Windows/System/StdOle2.tlb"
>
>
> Private Function CreateBitmapFile(fname As String) As String
>
> Dim obj As Object
>
>
> Set obj = LoadPicture(fname)
> If Not IsNull(obj) Then
>
> SavePicture obj, "C:\SL11-52"
> DoEvents
> End If
>
>
> CreateBitmapFile = "C:\SL11-52"
> Set obj = Nothing
>
> End Function
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
> news:n06qb.179921$bo1.50394@news-server.bigpond.net.au...
>[color=green]
>>Stephen,
>>
>>In answer to your questions:
>>
>>1. 300dpi
>>2. W98 the labeller's software does not work at all with later
>>versions of Windows even though it says it is compatible.
>>3. Access97 A number of later computers are running with WXP and
>>OfficeXP, but we have kept the base system on Access97.
>>4. 800x600
>>
>>Any information would be appreciated.
>>
>>Peter
>>
>>Stephen Lebans wrote:
>>[color=darkred]
>>>There might be a very simple solution depending on:
>>>1) What is the output resolution of your label printer?
>>>2) What version of WIndows are you running?
>>>3) What version of Access?
>>>4) What is the current display resolution of the monitor previewing[/color][/color]
>
> the
>[color=green][color=darkred]
>>>report?
>>>
>>>I have code here somewhere that can copy the Report Print Preview[/color][/color]
>
> window
>[color=green][color=darkred]
>>>to a disk based Image file. SInce your output area is only 4 inches[/color][/color]
>
> by 4
>[color=green][color=darkred]
>>>inches, depending on your screen resolution and the printers output
>>>resolution(I'm guessing it is only 198 DPI), you may be able to[/color][/color]
>
> simply
>[color=green][color=darkred]
>>>capture the Print Preview window.
>>>
>>>Alternatively, the ReportUtilites on my site can output each page at
>>>full printer resolution to an ENhanced Metafile. It would only take[/color][/color]
>
> a
>[color=green][color=darkred]
>>>bit mroe work instead save these EMF's programmatically to a Bitmap[/color][/color]
>
> or
>[color=green][color=darkred]
>>>Jpeg file.
>>>
>>>--
>>>
>>>HTH
>>>Stephen Lebans
>>>http://www.lebans.com
>>>Access Code, Tips and Tricks
>>>Please respond only to the newsgroups so everyone can benefit.
>>>
>>>
>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
>>>news:deOpb.178545$bo1.118114@news-server.bigpond.net.au...
>>>
>>>
>>>>Stephen,
>>>>
>>>>We have a data base of recipes and ingredients. Using MSAccess we
>>>>construct a label which includes all the legally required
>>>>information. The label information is designed to be printed onto a
>>>>preprinted base label by a label printer on a packaging machine. One
>>>>label printer (Intermec, in fact we wrote our own label design
>>>>software for the Intermec using MSAccess) is able to handle a
>>>>MSAccess report format, and one label printer (Hapa) is able to
>>>>handle the image as .pdf, however our other label printers
>>>>(Smartdates and Easycoders) require a graphics image.
>>>>
>>>>The nutritional panel has a prescribed format which includes columns
>>>>of data and boxes.
>>>>
>>>>The label includes the ingredient statement, the allergens and the
>>>>nutritional panel all of which are calculated each time the label is
>>>>printed, to ensure that any changes to the underlying recipe have
>>>>been updated on the label. Our system overcomes the possibility of a
>>>>product recall because of a change in a recipe not being
>>>>incorporated into the data on the label.
>>>>
>>>>We have a nominal range of just under 500,000 products, so it is
>>>>more convenient to generate the label and the carton label at the
>>>>time a particular product is made. All products are crosschecked
>>>>(Recipe barcode, label barcode, carton barcode, packaging machine
>>>>barcode and the storage coolroom barcode) by a wireless Intermec
>>>>barcode system which is integrated into our MSAccess system which
>>>>also updates our accounting system via the MSAccess ODBC driver.
>>>>
>>>>So basically the problem is being able to output a whole MSAccess
>>>>report page (it is only 100mm x 100mm) as a bitmap image.
>>>>
>>>>Thanks
>>>>
>>>>Peter
>>>>
>>>>
>>>>
>>>>Stephen Lebans wrote:
>>>>
>>>>
>>>>>Peter I'm not sure exactly what process are you trying to automate.
>>>
>>>DO
>>>
>>>
>>>>>you need to export the image of 2 Graphs contained on a Form and
>>>
>>>then
>>>
>>>
>>>>>save this output as a single Jpeg file? Is it just the graphs you
>>>
>>>want
>>>
>>>
>>>>>exported or the whole Form as it appears on the screen?
>>>>>
>>>>>--
>>>>>
>>>>>HTH
>>>>>Stephen Lebans
>>>>>http://www.lebans.com
>>>>>Access Code, Tips and Tricks
>>>>>Please respond only to the newsgroups so everyone can benefit.
>>>>>
>>>>>
>>>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
>>>>>news:WDrpb.176978$bo1.146297@news-server.bigpond.net.au...
>>>>>
>>>>>
>>>>>
>>>>>>Wayne,
>>>>>>
>>>>>>Thanks for your information. It does not change much. The MSAccess
>>>>>>report still has to be copied using non-MSAccess software and then
>>>>>>worked on to produce a useable graphic image.
>>>>>>
>>>>>>We use online printing equipment, that refer to the MSAccess
>>>>>>database for the information to print. It would be nice if the[/color][/color]
>
> whole
>[color=green][color=darkred]
>>>>>>of the label information generated by MSAccess could be uplifted
>>>>>>directly from the report.
>>>>>>
>>>>>>One of our printers has Swiss software that is able to handle .pdf
>>>>>>files directly, that makes the process a little easier.
>>>>>>Unfortunately the others are looking for a graphics image.
>>>>>>
>>>>>>Please note an error in my reply to David. The .jpg files would[/color][/color]
>
> need
>[color=green][color=darkred]
>>>>>>to be exported from CorelDraw, not saved.
>>>>>>
>>>>>>We hope that at some time in the future MSAccess may incorporate
>>>>>>some basic graphics interfaces.
>>>>>>
>>>>>>Regards
>>>>>>
>>>>>>Peter
>>>>>>
>>>>>>Wayne Gillespie wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>>On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts"
>>>>>
>>>>><david.lauberts@ntlworld.com> wrote:
>>>>>
>>>>>
>>>>>
>>>>>>>You could try Stephen Lebans site
>>>>>
>>>>>http://www.lebans.com/ReportUtilities.htm his Report Utilies
>>>
>>>download
>>>
>>>
>>>>>allows you to save a report as an EMF or WMF
>>>>>
>>>>>
>>>>>
>>>>>>>file. This file could then be converted to a jpg if required.
>>>>>>>You would have to build a report showing your graphs in order to
>>>
>>>use
>>>
>>>
>>>>>this method. The easiest way to do this is to right click on your
>>>
>>>form
>>>
>>>
>>>>>in the
>>>>>
>>>>>
>>>>>
>>>>>>>database window and select "Save As Report". This will create a[/color][/color]
>
> new
>[color=green][color=darkred]
>>>>>report based on your form which you can edit to suit your needs.
>>>>>
>>>>>
>>>>>
>>>>>>>>Peter
>>>>>>>>
>>>>>>>>I used print screen and MS Paint, thanks for the tip, but I was
>>>
>>>just
>>>
>>>
>>>>>>>>wondering if the was a way to do it directly using vb using a
>>>>>
>>>>>command button
>>>>>
>>>>>
>>>>>
>>>>>>>>for future work.
>>>>>>>>
>>>>>>>>Anyone know if it can be done?
>>>>>>>>
>>>>>>>>Regards
>>>>>>>>Dave
>>>>>>>>"Peter Flick" <pflick@bigpondXXremoveXX.net.au> wrote in message
>>>>>>>>news:KV3pb.175091$bo1.104182@news-server.bigpond.net.au...
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>Hi David,
>>>>>>>>>
>>>>>>>>>The only options I have found to convert a MS Access report as[/color][/color]
>
> a
>[color=green][color=darkred]
>>>>>>>>>graphic into something useable by any other software:
>>>>>>>>>
>>>>>>>>>Convert to .pdf using Acrobat Writer and then open .pdf using
>>>>>>>>>CorelDraw / save as .jpg
>>>>>>>>>
>>>>>>>>>or
>>>>>>>>>
>>>>>>>>>Print Screen / paste into CorelDraw (or other graphics[/color][/color]
>
> program)/
>[color=green][color=darkred]
>>>>>>>>>edit bitmap / crop bitmap (to eliminate what is not required on
>>>
>>>the
>>>
>>>
>>>>>>>>>screen) / save as .jpg
>>>>>>>>>
>>>>>>>>>If anyone has a better idea I would love to hear it.
>>>>>>>>>
>>>>>>>>>Peter
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>David Lauberts wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>Hi
>>>>>>>>>>
>>>>>>>>>>Wonder if someone has some words of wisdom.
>>>>>>>>>>
>>>>>>>>>>I have a access 2002 form that contains 2 graph objects that
>>>>>
>>>>>overlay
>>>>>
>>>>>
>>>>>
>>>>>>>>each
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>>other and would like to export them as a JPEG to use in a
>>>>>
>>>>>presentation.
>>>>>
>>>>>
>>>>>
>>>>>>>>I
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>>can do this individually for each graph but this does not help
>>>
>>>me
>>>
>>>
>>>>>as I
>>>>>
>>>>>
>>>>>
>>>>>>>>need
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>>both on the same JPEG. I thought I would try an export the[/color][/color]
>
> form
>[color=green][color=darkred]
>>>>>that
>>>>>
>>>>>
>>>>>
>>>>>>>>>>contains both but I am having trouble. (My VBA is self taught
>>>
>>>and
>>>
>>>
>>>>>a
>>>>>
>>>>>
>>>>>
>>>>>>>>little
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>>knowledge is dangerous). It is either impossible to do as the
>>>>>
>>>>>object
>>>>>
>>>>>
>>>>>
>>>>>>>>doesn't
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>>support the action or I have the code wrong.
>>>>>>>>>>
>>>>>>>>>>I have tried looking through google through news groups, there
>>>
>>>is
>>>
>>>
>>>>>a lot
>>>>>
>>>>>
>>>>>
>>>>>>>>>>about IMPORTING jpegs into forms but can't find anything about
>>>>>
>>>>>exporting
>>>>>
>>>>>
>>>>>
>>>>>>>>a
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>>form as a JPEG.
>>>>>>>>>>
>>>>>>>>>>The code I am using is:
>>>>>>>>>>
>>>>>>>>>>Function PictureTest()
>>>>>>>>>>Dim obj As Object
>>>>>>>>>> Set obj = Forms![frmGraph].[FirstGraph].Object
>>>>>>>>>> obj.Export "c:\temp\PictureTest.jpeg", "jpeg"
>>>>>>>>>> Set obj = Nothing
>>>>>>>>>>
>>>>>>>>>>End Function
>>>>>>>>>>
>>>>>>>>>>This works for each graph but not when I try :
>>>>>>>>>>
>>>>>>>>>>Set obj = Forms![frmGraph].Object
>>>>>>>>>>
>>>>>>>>>>or:
>>>>>>>>>>
>>>>>>>>>>Set obj = Forms![frmGraph]
>>>>>>>>>>
>>>>>>>>>>Any pearls of wisdom would be appreciated
>>>>>>>>>>
>>>>>>>>>>Regards
>>>>>>>>>>Dave
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>Wayne Gillespie
>>>>>>>Gosford NSW Australia
>>>>>>[/color][/color]
>[/color]

Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

re: Export of form with 2 graphs As a JPEG

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about