Lablels Report won't print

  • Thread starter pubdude2003 via AccessMonster.com
  • Start date
P

pubdude2003 via AccessMonster.com

I got this marvelous code for printing labels a user posted on accessmonster.
com but the code seems to be preventing the report from actually printing.
Can't PDF or send to my Canon printer.

This code appears in the OnPrint event and I assume it's what's preventing
the printing. It previews fine just won't print.

Static intMyPrint As Integer
If PrintCount <= Forms!form3.Text13 And [SkipControl] = "Skip" Then
Me.NextRecord = False
Me.PrintSection = False
intMyPrint = 0
Else
[SkipControl] = "No"
Me.PrintSection = True
Me.NextRecord = True
intMyPrint = intMyPrint + 1

If intMyPrint Mod Forms!form3.Text14 = 0 Then
Me.NextRecord = True
intMyPrint = 0
Else
Me.NextRecord = False
End If
End If
 
P

pubdude2003 via AccessMonster.com

always just after I post...

Since it's an OnPrint event it's looking to the form for the values for the
actual printing. The db's been programmed to close that form once the Preview
is up. Problem solved, I will push the form values to a text box on the
report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top