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>