![]() | |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have a continuous report to print placr name that has a picture and a name. The picture is the same ineach case. The report is 2 columns with 7 names in each column and there are 52 names to print so 3 complete pages and most of a 4th page. Basic code Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error GoTo FindLogo_Err Me.Logo.Picture = Nz(PlaceNamesLogoPath) Exit Sub FindLogo_Err: If Err = 2220 Then If PictureNotFound = False Then MsgBox "The picture " & PlaceNamesLogoPath & " can not be found" End If Logo.Picture = "(none)" PictureNotFound = True Resume Next End If End Sub Problem is missing logos. Have tried previewing the report 30 or 40 times now. With 1 exception the first page prints OK Sometimes the second page prints OK, but frequently the 3 bottom logos are missing. The third page the 3 bottom logos are always missing Forth Page is always OK (Only 10 labels anyway). In ReportView all is OK. I supect a BUG Any ideas? Phil |
#3
| |||
| |||
|
|
On 21/10/2011 22:02:55, "Phil" wrote: I have a continuous report to print placr name that has a picture and a name. The picture is the same ineach case. The report is 2 columns with 7 names in each column and there are 52 names to print so 3 complete pages and most of a 4th page. Basic code Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error GoTo FindLogo_Err Me.Logo.Picture = Nz(PlaceNamesLogoPath) Exit Sub FindLogo_Err: If Err = 2220 Then If PictureNotFound = False Then MsgBox "The picture " & PlaceNamesLogoPath & " can not be found" End If Logo.Picture = "(none)" PictureNotFound = True Resume Next End If End Sub Problem is missing logos. Have tried previewing the report 30 or 40 times now. With 1 exception the first page prints OK Sometimes the second page prints OK, but frequently the 3 bottom logos are missing. The third page the 3 bottom logos are always missing Forth Page is always OK (Only 10 labels anyway). In ReportView all is OK. I supect a BUG Any ideas? Phil I think it has something to do with the size of the Jpeg image as well as some unknown factor. Certainly there are problems with files over 500K, but most files at about 400K are OK. The one I had the problem with is only 63K, but a high quality. What other factors could be involved with JPegs Phil |
#4
| |||
| |||
|
|
On Oct 21, 4:55*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote: On 21/10/2011 22:02:55, "Phil" wrote: I have a continuous report to print placr name that has a picture and a name. The picture is the same ineach case. The report is 2 columns with 7 names in each column and there are 52 na mes to print so 3 complete pages and most of a 4th page. Basic code Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error GoTo FindLogo_Err Me.Logo.Picture = Nz(PlaceNamesLogoPath) Exit Sub FindLogo_Err: If Err = 2220 Then If PictureNotFound = False Then MsgBox "The picture " & PlaceNamesLogoPath & " can not be found" End If Logo.Picture = "(none)" PictureNotFound = True Resume Next End If End Sub Problem is missing logos. Have tried previewing the report 30 or 40 tim es now. With 1 exception the first page prints OK Sometimes the second page prints OK, but frequently the 3 bottom logos are missing. The third page the 3 bottom logos are always missing Forth Pag e is always OK (Only 10 labels anyway). In ReportView all is OK. I supect a BUG Any ideas? Phil I think it has something to do with the size of the Jpeg image as well as some unknown factor. Certainly there are problems with files over 500K, but most files at abou t 400K are OK. The one I had the problem with is only 63K, but a high quali ty. What other factors could be involved with JPegs Phil What if the error number is not 2220? |
#5
| |||
| |||
|
|
On 22/10/2011 19:10:59, Patrick Finucane wrote: On Oct 21, 4:55*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote: On 21/10/2011 22:02:55, "Phil" wrote: I have a continuous report to print placr name that has a picture and a name. The picture is the same ineach case. The report is 2 columns with 7 names in each column and there are 52na mes to print so 3 complete pages and most of a 4th page. Basic code Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error GoTo FindLogo_Err Me.Logo.Picture = Nz(PlaceNamesLogoPath) Exit Sub FindLogo_Err: If Err = 2220 Then If PictureNotFound = False Then MsgBox "The picture " & PlaceNamesLogoPath & " can not be found" End If Logo.Picture = "(none)" PictureNotFound = True Resume Next End If End Sub Problem is missing logos. Have tried previewing the report 30 or 40 tim es now. With 1 exception the first page prints OK Sometimes the second page prints OK, but frequently the 3 bottom logos are missing. The third page the 3 bottom logos are always missing Forth Pag e is always OK (Only 10 labels anyway). In ReportView all is OK. I supect a BUG Any ideas? Phil I think it has something to do with the size of the Jpeg image as wellas some unknown factor. Certainly there are problems with files over 500K, but most files at abou t 400K are OK. The one I had the problem with is only 63K, but a high quali ty. What other factors could be involved with JPegs Phil What if the error number is not 2220? Woops Good point, but I suspect that is not the problem as the picture has loaded successfully for the majority of the place name labels and print out OK. They all have the same picture. Thanks Phil |
#6
| |||
| |||
|
|
On Oct 23, 3:14*am, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote: On 22/10/2011 19:10:59, Patrick Finucane wrote: On Oct 21, 4:55*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote: On 21/10/2011 22:02:55, "Phil" wrote: I have a continuous report to print placr name that has a picture an d a name. The picture is the same ineach case. The report is 2 columns with 7 names in each column and there are 52 na mes to print so 3 complete pages and most of a 4th page. Basic code Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error GoTo FindLogo_Err Me.Logo.Picture = Nz(PlaceNamesLogoPath) Exit Sub FindLogo_Err: If Err = 2220 Then If PictureNotFound = False Then MsgBox "The picture " & PlaceNamesLogoPath & " can not be found" End If Logo.Picture = "(none)" PictureNotFound = True Resume Next End If End Sub Problem is missing logos. Have tried previewing the report 30 or 40 tim es now. With 1 exception the first page prints OK Sometimes the second page prints OK, but frequently the 3 bottom log os are missing. The third page the 3 bottom logos are always missing Forth Pag e is always OK (Only 10 labels anyway). In ReportView all is OK. I supect a BUG Any ideas? Phil I think it has something to do with the size of the Jpeg image as well as some unknown factor. Certainly there are problems with files over 500K, but most files at a bou t 400K are OK. The one I had the problem with is only 63K, but a high qu ali ty. What other factors could be involved with JPegs Phil What if the error number is not 2220? Woops Good point, but I suspect that is not the problem as the picture has load ed successfully for the majority of the place name labels and print out OK. They all have the same picture. Thanks Phil It does seem strange that in one view format if displays, the other doesn't. Maybe put a print.debug line like debug.print "ok " & PlaceNamesLogoPath just before the exit sub line and the first line in the error rounding change OK to Not OK. BTW, if in preview it doesn't display does it display if printed? Hi Patrick |
![]() |
| Thread Tools | |
| Display Modes | |
| |