By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

Export of form with 2 graphs As a JPEG

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
16 Replies


P: n/a
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 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


Nov 12 '05 #2

P: n/a
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:KV*********************@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 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

Nov 12 '05 #3

P: n/a
On Mon, 3 Nov 2003 06:54:19 -0000, "David Lauberts" <da************@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.

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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:KV*********************@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 overlayeach > 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 Ineed > 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 alittle > knowledge is dangerous). It is either impossible to do as the objectdoesn'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 exportinga > 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
Nov 12 '05 #4

P: n/a
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" <da************@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.
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:KV*********************@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 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


Wayne Gillespie
Gosford NSW Australia


Nov 12 '05 #5

P: n/a
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:WD*********************@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" <da************@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.

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 buttonfor future work.

Anyone know if it can be done?

Regards
Dave
"Peter Flick" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:KV*********************@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 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
>
>


Wayne Gillespie
Gosford NSW Australia


Nov 12 '05 #6

P: n/a
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:WD*********************@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"
<da************@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.
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:KV*********************@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
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
>>
>>
>
Wayne Gillespie
Gosford NSW Australia


Nov 12 '05 #7

P: n/a
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:WD*********************@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"


<da************@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.


>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" <pf****@bigpondXXremoveXX.net.au> wrote in message
>news:KV*********************@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


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
>>>
>>>
>>
Wayne Gillespie
Gosford NSW Australia


Nov 12 '05 #8

P: n/a
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" <Fo****************************************@linval id.com>
wrote in message news:5i*******************@ursa-nb00s0.nbnet.nb.ca...
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:WD*********************@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"

<da************@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.

>>
>>
>>>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" <pf****@bigpondXXremoveXX.net.au> wrote in message
>>>news:KV*********************@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

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
>>>>>
>>>>>
>>>>
>>Wayne Gillespie
>>Gosford NSW Australia
>

Nov 12 '05 #9

P: n/a
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:
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:WD*********************@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"

<da************@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.
>
>>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" <pf****@bigpondXXremoveXX.net.au> wrote in message
>>news:KV*********************@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

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
>>>>
>>>>
>>>
>Wayne Gillespie
>Gosford NSW Australia


Nov 12 '05 #10

P: n/a
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" <da************@ntlworld.com> wrote in message
news:tL****************@newsfep1-gui.server.ntli.net...
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" <Fo****************************************@linval id.com> wrote in message news:5i*******************@ursa-nb00s0.nbnet.nb.ca...
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message
> news:WD*********************@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"
>
> <da************@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.
>
>>>
>>>
>>>>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" <pf****@bigpondXXremoveXX.net.au> wrote in
message >>>>news:KV*********************@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
>
> 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
>>>>>>
>>>>>>
>>>>>
>>>Wayne Gillespie
>>>Gosford NSW Australia
>>
>



Nov 12 '05 #11

P: n/a
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:n0********************@news-server.bigpond.net.au...
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:
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:WD*********************@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"

<da************@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.
>>
>>>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" <pf****@bigpondXXremoveXX.net.au> wrote in message
>>>news:KV*********************@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

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
>>>>>
>>>>>
>>>>
>>Wayne Gillespie
>>Gosford NSW Australia
>


Nov 12 '05 #12

P: n/a
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" <Fo****************************************@linval id.com>
wrote in message news:Y9*******************@ursa-nb00s0.nbnet.nb.ca...
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" <da************@ntlworld.com> wrote in message
news:tL****************@newsfep1-gui.server.ntli.net...
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"

<Fo****************************************@linval id.com>
wrote in message news:5i*******************@ursa-nb00s0.nbnet.nb.ca...
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message
> > news:WD*********************@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"
> >
> > <da************@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.
> >
> >>>
> >>>
> >>>>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" <pf****@bigpondXXremoveXX.net.au> wrote in message > >>>>news:KV*********************@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
> >
> > 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
> >>>>>>
> >>>>>>
> >>>>>
> >>>Wayne Gillespie
> >>>Gosford NSW Australia
> >>
> >
>



Nov 12 '05 #13

P: n/a
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" <Fo****************************************@linval id.com>
wrote in message news:Y9*******************@ursa-nb00s0.nbnet.nb.ca...
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" <da************@ntlworld.com> wrote in message
news:tL****************@newsfep1-gui.server.ntli.net...
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"

<Fo****************************************@linval id.com>
wrote in message news:5i*******************@ursa-nb00s0.nbnet.nb.ca...
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message
> > news:WD*********************@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"
> >
> > <da************@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.
> >
> >>>
> >>>
> >>>>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" <pf****@bigpondXXremoveXX.net.au> wrote in message > >>>>news:KV*********************@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
> >
> > 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
> >>>>>>
> >>>>>>
> >>>>>
> >>>Wayne Gillespie
> >>>Gosford NSW Australia
> >>
> >
>


Nov 12 '05 #14

P: n/a
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" <da************@ntlworld.com> wrote in message
news:wl***************@newsfep3-gui.server.ntli.net...
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" <Fo****************************************@linval id.com> wrote in message news:Y9*******************@ursa-nb00s0.nbnet.nb.ca...
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" <da************@ntlworld.com> wrote in message
news:tL****************@newsfep1-gui.server.ntli.net...
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"

<Fo****************************************@linval id.com>
wrote in message
news:5i*******************@ursa-nb00s0.nbnet.nb.ca... > 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" <pf****@bigpondXXremoveXX.net.au> wrote in message
> news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message > > > news:WD*********************@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"
> > >
> > > <da************@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. > > >
> > >>>
> > >>>
> > >>>>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" <pf****@bigpondXXremoveXX.net.au> wrote in

message
> > >>>>news:KV*********************@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 > > >
> > > 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
> > >>>>>>
> > >>>>>>
> > >>>>>
> > >>>Wayne Gillespie
> > >>>Gosford NSW Australia
> > >>
> > >
> >
>



Nov 12 '05 #15

P: n/a
Thanks Stephen

Looks like an interesting Job for the weekend!

Let you know how I get on

Dave
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:cP*******************@ursa-nb00s0.nbnet.nb.ca...
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" <da************@ntlworld.com> wrote in message
news:wl***************@newsfep3-gui.server.ntli.net...
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"

<Fo****************************************@linval id.com>
wrote in message news:Y9*******************@ursa-nb00s0.nbnet.nb.ca...
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" <da************@ntlworld.com> wrote in message
news:tL****************@newsfep1-gui.server.ntli.net...
> 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"
<Fo****************************************@linval id.com>
> wrote in message news:5i*******************@ursa-nb00s0.nbnet.nb.ca... > > 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" <pf****@bigpondXXremoveXX.net.au> wrote in message
> > news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message > > > > news:WD*********************@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"
> > > >
> > > > <da************@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. > > > >
> > > >>>
> > > >>>
> > > >>>>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" <pf****@bigpondXXremoveXX.net.au> wrote in
message
> > > >>>>news:KV*********************@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 > > > >
> > > > 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
> > > >>>>>>
> > > >>>>>>
> > > >>>>>
> > > >>>Wayne Gillespie
> > > >>>Gosford NSW Australia
> > > >>
> > > >
> > >
> >
>
>


Nov 12 '05 #16

P: n/a
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:
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:n0********************@news-server.bigpond.net.au...
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:
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" <pf****@bigpondXXremoveXX.net.au> wrote in message
news:de*********************@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" <pf****@bigpondXXremoveXX.net.au> wrote in message
>news:WD*********************@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"
>
><da************@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.
>
>
>
>>>>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" <pf****@bigpondXXremoveXX.net.au> wrote in message
>>>>news:KV*********************@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
>
>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
>>>>>>
>>>>>>
>>>>>
>>>Wayne Gillespie
>>>Gosford NSW Australia
>>


Nov 12 '05 #17

This discussion thread is closed

Replies have been disabled for this discussion.