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
16  11797 
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
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
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
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
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
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
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
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
>
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
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
>>
>
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
>
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
> >>
> >
>
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
> >>
> >
>
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
> > >>
> > >
> >
>
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
> > > >>
> > > >
> > >
> >
>
>
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
>> This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Pat |
last post by:
I would like to send the Print Preview of a MS Access form to a
Snapshot file. The form contains an OLE graph.
BACKGROUND
A snapshot of a report is possible. If I could I would use a report to...
|
by: B Love |
last post by:
I am trying to insert a hyperlink field which will link to a JPEG file in a
folder on a server but for some reason, I am unable to do so. I can enter
the same information in a browser, and it...
|
by: VB Programmer |
last post by:
Briefly, how do you save the current form to a jpeg or gif?
Details: I have a form with a speedometer control on it. It continually
loops through a table in a db that has different current...
|
by: Jon |
last post by:
Is there a simple way to export all the form fields on a form the user
submitted to an xml format? For instance, if you had a form with three
fields on it and in the submit event you did the...
|
by: marc.welty |
last post by:
Hi all,
I have browsed the message board extensively on how to export OLE
Objects as JPEG's and everyone referes to Stephen Lebans utility. I d/l
and it works great! HOWEVER, I want to try and...
|
by: Sashi |
last post by:
Hi All,
I have a table from which I want to export the data as a plain text
file.
I exported the data using the "Export" option and selected the comma
as a separator and the " as the Text...
|
by: icenemesis |
last post by:
I have a form that searches dynamically based on what criteria the user enters. The resulting query populates a subform in datasheet view.
If I wanted to have a button that would export the...
|
by: printline |
last post by:
Hello All
I'm quite new to xml vs. PHP, so i hope someone can help with an issue i have been struggeling with.
I have an html form, that when submitted, it should create an xml file, and save...
|
by: santhanalakshmi |
last post by:
Hello,
I currently have an HTML table with data in it. The data comes from SQL2000. I want to take my HTML table and allow users to hit an "Export to CSV" button which will allow them to download...
|
by: Sharkiness |
last post by:
Hi all who wish to help,
I have created a database that contains five different tables. Each linking to a main table through an ID.
The database opens asking for an ID. When ID is input and...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
