J
J.Alladien
Dear All,
I am working on my products catalog and I have 2 dtbases; one uses the OLE
method, the other one the "path to picture method"! (tot qty pics: abt
1000-1200)
I have to deliver my whole catalog in a PDF file to a printing-office in
order for them to print HARD COPIES for my clients!
In the db that uses the "path to picture method" ,I get the following
error when scrolling in my report-preview mode when I scroll past lets say
after the 280th page (from 310 total);pls note that all pics are loaded fine
till page 280!
"my DB doesn't support the format of the file F:\jetzza\1012.jpg or the
file is too large;try converting the file to bmp or Gif format"
This goes on till the last page, the code being used in the report is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error GoTo Err_cmdClose_Click
'set the picture path
Me.ImgStock.Picture = pathname & "\" & Me.txtStockGraph
Exit_cmdClose_Click:
Exit Sub
Err_cmdClose_Click:
If Err.Number = 2220 Then 'can't find the file
Resume Next
Else
MsgBox Err.Description
Resume Exit_cmdClose_Click
End If
End Sub
When I try to convert my report to a PDF file ,it gets an error stopping
around page 280 ,if I try to convert it in bits lets say from pg 1-50 ,51-
-100 etc I get he same error!
My "OLE " db however has no problems ,works fine even better the then my
other DB .the above only applies to the reports ,Forms are no problem at all
in both databases!
Is there a solution to this problem? Am I the only one having this problem?
The problem is I think primarely when the pictures get loaded on the report!
Is there a code that has a solution to this problem!
Please help!
I am working on my products catalog and I have 2 dtbases; one uses the OLE
method, the other one the "path to picture method"! (tot qty pics: abt
1000-1200)
I have to deliver my whole catalog in a PDF file to a printing-office in
order for them to print HARD COPIES for my clients!
In the db that uses the "path to picture method" ,I get the following
error when scrolling in my report-preview mode when I scroll past lets say
after the 280th page (from 310 total);pls note that all pics are loaded fine
till page 280!
"my DB doesn't support the format of the file F:\jetzza\1012.jpg or the
file is too large;try converting the file to bmp or Gif format"
This goes on till the last page, the code being used in the report is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error GoTo Err_cmdClose_Click
'set the picture path
Me.ImgStock.Picture = pathname & "\" & Me.txtStockGraph
Exit_cmdClose_Click:
Exit Sub
Err_cmdClose_Click:
If Err.Number = 2220 Then 'can't find the file
Resume Next
Else
MsgBox Err.Description
Resume Exit_cmdClose_Click
End If
End Sub
When I try to convert my report to a PDF file ,it gets an error stopping
around page 280 ,if I try to convert it in bits lets say from pg 1-50 ,51-
-100 etc I get he same error!
My "OLE " db however has no problems ,works fine even better the then my
other DB .the above only applies to the reports ,Forms are no problem at all
in both databases!
Is there a solution to this problem? Am I the only one having this problem?
The problem is I think primarely when the pictures get loaded on the report!
Is there a code that has a solution to this problem!
Please help!