printing pictures in report

[nebros]

I am using access 2003 with win 2k pro. I have a table that keeps the path
to the pictures, and I am using the VB approach to displaying them on the
report. They are large photos and I believe I am running out of memory.

Does anyone have a quickfix or a fix at all>

 

[Gina Whipp]

Nebros,

Might help to get an answer if you tell what akes you think that... Are you
getting some specific error message? Is it taking a long time to print and
you think it should be shorter? Do you see them in the report?

 

[nebros]

The report prints, but it will sometimes print 2, 3, or 4 of the pictures on
the page. Their are 4 pictures per record and their are 60 records. Each
records has its own page. The pictures are around 3 megs each. I have tried
them as wmf files, but still get the same random printing.

The report crashes when I try to look at all 60 pages. I get the printing
errors when I cut it down to 1 record.

 

[Gina Whipp]

Well, that is kind large for a picture, I probably would have gone with .png
or .jpg but still not sure that is the issue. What code are you using to
display the pictures? I have a report that shows four pictures per page and
it's well over 100 pages long, no issues so far. So maybe the issue is the
code?

 

[nebros]

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.ImageName.Picture = Me.[CPPic]
Me.imagename2.Picture = Me.[SitePic]
Me.Imagename3.Picture = Me.[WWPic]
Me.imagename4.Picture = Me.[VVPic]
End Sub

 

[Gina Whipp]

I am assuming Me.[CPPic] is the path to the picture? But before we go about
changing your code, try putting your code in the "Private Sub
Detail_Print(Cancel As Integer, PrintCount As Integer)" section of the
report.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.ImageName.Picture = Me.[CPPic]
Me.imagename2.Picture = Me.[SitePic]
Me.Imagename3.Picture = Me.[WWPic]
Me.imagename4.Picture = Me.[VVPic]
End Sub

Well, that is kind large for a picture, I probably would have gone with
.png
or .jpg but still not sure that is the issue. What code are you using to
display the pictures? I have a report that shows four pictures per page
and
it's well over 100 pages long, no issues so far. So maybe the issue is
the
code?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

 

[nebros]

Unfortunately that did not work. You are correct in assuming that CPPic is
the path to the picture.

I am assuming Me.[CPPic] is the path to the picture? But before we go about
changing your code, try putting your code in the "Private Sub
Detail_Print(Cancel As Integer, PrintCount As Integer)" section of the
report.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.ImageName.Picture = Me.[CPPic]
Me.imagename2.Picture = Me.[SitePic]
Me.Imagename3.Picture = Me.[WWPic]
Me.imagename4.Picture = Me.[VVPic]
End Sub

Well, that is kind large for a picture, I probably would have gone with
.png
or .jpg but still not sure that is the issue. What code are you using to
display the pictures? I have a report that shows four pictures per page
and
it's well over 100 pages long, no issues so far. So maybe the issue is
the
code?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
The report prints, but it will sometimes print 2, 3, or 4 of the
pictures
on
the page. Their are 4 pictures per record and their are 60 records.
Each
records has its own page. The pictures are around 3 megs each. I have
tried
them as wmf files, but still get the same random printing.

The report crashes when I try to look at all 60 pages. I get the
printing
errors when I cut it down to 1 record.


:

Nebros,

Might help to get an answer if you tell what akes you think that...
Are
you
getting some specific error message? Is it taking a long time to
print
and
you think it should be shorter? Do you see them in the report?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
I am using access 2003 with win 2k pro. I have a table that keeps
the
path
to the pictures, and I am using the VB approach to displaying them
on
the
report. They are large photos and I believe I am running out of
memory.

Does anyone have a quickfix or a fix at all>

 

[Gina Whipp]

Unfortunatley, I am on site all day today but will check later tonihgt. If
no one has gotten back to you I'll send you the code I got from Microsoft's
site, hasn't let me down yet!

Gina Whipp

Unfortunately that did not work. You are correct in assuming that CPPic is
the path to the picture.

I am assuming Me.[CPPic] is the path to the picture? But before we go about
changing your code, try putting your code in the "Private Sub
Detail_Print(Cancel As Integer, PrintCount As Integer)" section of the
report.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.ImageName.Picture = Me.[CPPic]
Me.imagename2.Picture = Me.[SitePic]
Me.Imagename3.Picture = Me.[WWPic]
Me.imagename4.Picture = Me.[VVPic]
End Sub



:

Well, that is kind large for a picture, I probably would have gone with
.png
or .jpg but still not sure that is the issue. What code are you using to
display the pictures? I have a report that shows four pictures per page
and
it's well over 100 pages long, no issues so far. So maybe the issue is
the
code?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
The report prints, but it will sometimes print 2, 3, or 4 of the
pictures
on
the page. Their are 4 pictures per record and their are 60 records.
Each
records has its own page. The pictures are around 3 megs each. I have
tried
them as wmf files, but still get the same random printing.

The report crashes when I try to look at all 60 pages. I get the
printing
errors when I cut it down to 1 record.


:

Nebros,

Might help to get an answer if you tell what akes you think that...
Are
you
getting some specific error message? Is it taking a long time to
print
and
you think it should be shorter? Do you see them in the report?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
I am using access 2003 with win 2k pro. I have a table that keeps
the
path
to the pictures, and I am using the VB approach to displaying them
on
the
report. They are large photos and I believe I am running out of
memory.

Does anyone have a quickfix or a fix at all>

 

[Gina Whipp]

Here is the link to the Microsoft webpage to tell/show you how to display
pictures.. http://support.microsoft.com/kb/285820/en-us Post back if you
have any issues. I use this on my reports and forms and have never had a
problem.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

Unfortunately that did not work. You are correct in assuming that CPPic
is
the path to the picture.

I am assuming Me.[CPPic] is the path to the picture? But before we go
about
changing your code, try putting your code in the "Private Sub
Detail_Print(Cancel As Integer, PrintCount As Integer)" section of the
report.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.ImageName.Picture = Me.[CPPic]
Me.imagename2.Picture = Me.[SitePic]
Me.Imagename3.Picture = Me.[WWPic]
Me.imagename4.Picture = Me.[VVPic]
End Sub



:

Well, that is kind large for a picture, I probably would have gone
with
.png
or .jpg but still not sure that is the issue. What code are you using
to
display the pictures? I have a report that shows four pictures per
page
and
it's well over 100 pages long, no issues so far. So maybe the issue
is
the
code?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
The report prints, but it will sometimes print 2, 3, or 4 of the
pictures
on
the page. Their are 4 pictures per record and their are 60 records.
Each
records has its own page. The pictures are around 3 megs each. I
have
tried
them as wmf files, but still get the same random printing.

The report crashes when I try to look at all 60 pages. I get the
printing
errors when I cut it down to 1 record.


:

Nebros,

Might help to get an answer if you tell what akes you think that...
Are
you
getting some specific error message? Is it taking a long time to
print
and
you think it should be shorter? Do you see them in the report?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
I am using access 2003 with win 2k pro. I have a table that keeps
the
path
to the pictures, and I am using the VB approach to displaying
them
on
the
report. They are large photos and I believe I am running out of
memory.

Does anyone have a quickfix or a fix at all>

 

[Stephen Lebans]

Here are some steps you must follow to eliminate/reduce the error you
are encountering.
Items #4 and #5 resolve this issue 90% of the time. :

1) Defrag your Hard drive. The temp printer output files Access
generates can be very large when they contain images.


2) Make sure the drive you point your Virtual Memory Manager to has
several hundred MB's of free space.


3) If you are still using Win9x then make sure you reboot before
printing.


4) You must turn off the "Loading Image" dialog via the Registry
solution here:
http://www.mvps.org/access/api/api0038.htm
If you are using NT or higher you will have to update both
HKEY_LOCAL_MACHINE and HKEY_CURRENT_USER


5) Load the Images into the Image control from the Detail Section's
Print event NOT THE FORMAT EVENT.


If you follow the above steps and your Report still fails then here are
a couple of more solutions:


6) Upgrade to the latest version of Windows at the very least. Better
yet, upgrade to Access 2003 as well.
or
7) Use the PrintOUt method to only print out a limited number of pages
at a time. Repeat as required.
or
8) THis solution seems to look after most of the memory issues. At
runtime convert the Images to Bitmap format prior to loading them into
the Image control. Here is some sample code:



--

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