dbTalk Databases Forums  

Another Access Bug?

comp.databases.ms-access comp.databases.ms-access


Discuss Another Access Bug? in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Phil
 
Posts: n/a

Default Another Access Bug? - 10-21-2011 , 04:02 PM






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

Reply With Quote
  #2  
Old   
Phil
 
Posts: n/a

Default Re: Another Access Bug? - 10-21-2011 , 04:55 PM






On 21/10/2011 22:02:55, "Phil" wrote:
Quote:
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

Reply With Quote
  #3  
Old   
Patrick Finucane
 
Posts: n/a

Default Re: Another Access Bug? - 10-22-2011 , 01:10 PM



On Oct 21, 4:55*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
Quote:
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
What if the error number is not 2220?

Reply With Quote
  #4  
Old   
Phil
 
Posts: n/a

Default Re: Another Access Bug? - 10-23-2011 , 03:14 AM



On 22/10/2011 19:10:59, Patrick Finucane wrote:
Quote:
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?

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

Reply With Quote
  #5  
Old   
Patrick Finucane
 
Posts: n/a

Default Re: Another Access Bug? - 10-23-2011 , 07:36 AM



On Oct 23, 3:14*am, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
Quote:
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
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?

Reply With Quote
  #6  
Old   
Phil
 
Posts: n/a

Default Re: Another Access Bug? - 10-24-2011 , 05:27 PM



On 23/10/2011 13:36:46, Patrick Finucane wrote:
Quote:
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

Think the error routine should trap any problems, end anyway, I'm loading the
same picture each time.

Tried your suggestion, and no errors in the code
Print is the same as the preview.

Interestingly the size of the logo I used in the OP was 63K
I have increased this to 87k and pages 1 to 3 only prints the first 8 out of
the 14 logos, and page 4 prints 5 out of the 8 logos.

I closed an irrelevant form and tried again on 3 occassions, one after
another I got
14,8,5,5
14,5,5,5
11,8,5,5

So I definately get the feeling there are 3 factors at work. One is to do
with the file size. Can one have something to do with the picture quality?
Maybe another factor is what other background processes are running on the
computer which is giving the variable results. Looking at the picture
properties, I have a picture of 327K which runs perfectly. The properties
show the Horizontal and Vertical resolution of 96 dpi. The trouplesome
pictures have a resolution of 480 dpi, so I guess that is picture quality
variable nailed down.

Phil

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.