Is Report Successfully Printed ?

[prakashwadhwani]

While making Vouchers in a form, I have a POST button which validates
& posts the transaction to the main Accounts File.

I also have a PRINT button which provides the user with a preview of
the "to be printed" Voucher & then prints it onto paper.

When the user clicks PRINT ... my code validates the voucher & prints
it. Now I have to POST the transaction ... but how do I know if the
voucher has printed correctly ? i.e. no paper jam or some such other
problem.

Rgds,
Prakash

[fredg]

On Fri, 29 Feb 2008 10:53:48 -0800 (PST), pr*************@gmail.com
wrote:

While making Vouchers in a form, I have a POST button which validates
& posts the transaction to the main Accounts File.

I also have a PRINT button which provides the user with a preview of
the "to be printed" Voucher & then prints it onto paper.

When the user clicks PRINT ... my code validates the voucher & prints
it. Now I have to POST the transaction ... but how do I know if the
voucher has printed correctly ? i.e. no paper jam or some such other
problem.

Rgds,
Prakash

There is only one sure fire method, and that is to walk over to the
printer, pick up the piece of paper, and look.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[prakashwadhwani]

On Feb 29, 11:05 pm, fredg <[e-mail]:

On Fri, 29 Feb 2008 10:53:48 -0800 (PST), [e-mail]
wrote:

While making Vouchers in a form, I have a POST button which validates
& posts the transaction to the main Accounts File.

I also have a PRINT button which provides the user with a preview of
the "to be printed" Voucher & then prints it onto paper.

When the user clicks PRINT ... my code validates the voucher & prints
it. Now I have to POST the transaction ... but how do I know if the
voucher has printed correctly ? i.e. no paper jam or some such other
problem.

Rgds,
Prakash

There is only one sure fire method, and that is to walk over to the
printer, pick up the piece of paper, and look.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thx Fred !! But what if after previewing the Report, the user clicks
the close button on the Access Toolbar or presses Ctrl-W to close the
preview window & DOES NOT print a hardcopy ?

Is there any way for me to trap this ?

Rgds,
Prakash.

[fredg]

On Fri, 29 Feb 2008 11:13:19 -0800 (PST), pr*************@gmail.com
wrote:

On Feb 29, 11:05 pm, fredg <[e-mail]:

>On Fri, 29 Feb 2008 10:53:48 -0800 (PST), [e-mail]
wrote:

>>While making Vouchers in a form, I have a POST button which validates
& posts the transaction to the main Accounts File.

>>I also have a PRINT button which provides the user with a preview of
the "to be printed" Voucher & then prints it onto paper.

>>When the user clicks PRINT ... my code validates the voucher & prints
it. Now I have to POST the transaction ... but how do I know if the
voucher has printed correctly ? i.e. no paper jam or some such other
problem.

>>Rgds,
Prakash

There is only one sure fire method, and that is to walk over to the
printer, pick up the piece of paper, and look.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thx Fred !! But what if after previewing the Report, the user clicks
the close button on the Access Toolbar or presses Ctrl-W to close the
preview window & DOES NOT print a hardcopy ?

Is there any way for me to trap this ?

Rgds,
Prakash.

So now you just wish to know if the report was SENT to the printer?

The value of intPreview you use is determined whether you have a
control in the report calculating [Pages].

Option Compare Database
Option Explicit
Dim intPreview As Integer

Private Sub Report_Activate()
intPreview = -1 ' Pages Not used
' intPreview = -2 ' Pages

End Sub
___________

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As
Integer)

If intPreview >= 0 Then ' If [Pages] not used
' If intPreview >= 1 Then ' If [Pages] used
MsgBox "Sent to the Printer"
Else
MsgBox "Not sent to the Printer"
End If
intPreview = intPreview + 1

End Sub

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Larry Linson]

<pr*************@gmail.comwrote in message
news:54**********************************@s13g2000 prd.googlegroups.com...

While making Vouchers in a form, I have a POST button which validates
& posts the transaction to the main Accounts File.

I also have a PRINT button which provides the user with a preview of
the "to be printed" Voucher & then prints it onto paper.

When the user clicks PRINT ... my code validates the voucher & prints
it. Now I have to POST the transaction ... but how do I know if the
voucher has printed correctly ? i.e. no paper jam or some such other
problem.

As far as I know, you cannot determine this. I have seen long reports
crushed, wadded, crumpled, and folded by a shared printer that did not even
stop the printer, much less return an error code. The only sure way that I
know is to print it on a local printer, verify manually that it printed
properly, and make a manual entry to indicate that it has been printed.

Larry Linson
Microsoft Office Access MVP

[Deano]

pr*************@gmail.comwrote in message
news:54**********************************@s13g2000 prd.googlegroups.com...

While making Vouchers in a form, I have a POST button which validates
& posts the transaction to the main Accounts File.

I also have a PRINT button which provides the user with a preview of
the "to be printed" Voucher & then prints it onto paper.

When the user clicks PRINT ... my code validates the voucher & prints
it. Now I have to POST the transaction ... but how do I know if the
voucher has printed correctly ? i.e. no paper jam or some such other
problem.

Rgds,
Prakash

I use a finance accounts package and when cheques have been printed it asks
if they were produced. Based on what the user responds the programme can
either reprint the cheques or move on. I think this is a sensible way to
proceed.

[prakashwadhwani]

On Mar 1, 3:08 am, "Deano" <[e-mail]:

[e-mail] in message

news:54**********************************@s13g2000 prd.googlegroups.com...

While making Vouchers in a form, I have a POST button which validates
& posts the transaction to the main Accounts File.

I also have a PRINT button which provides the user with a preview of
the "to be printed" Voucher & then prints it onto paper.

When the user clicks PRINT ... my code validates the voucher & prints
it. Now I have to POST the transaction ... but how do I know if the
voucher has printed correctly ? i.e. no paper jam or some such other
problem.

Rgds,
Prakash

I use a finance accounts package and when cheques have been printed it asks
if they were produced. Based on what the user responds the programme can
either reprint the cheques or move on. I think this is a sensible way to
proceed.

Hmmm. I think this makes the most sense ... putting the onus onto the
user to confirm & validate the accuracy of the print. I have a feeling
I may just use this, but I'll also have to provide the user with a "Re-
Print" option in the event of a print mishap. I was actually trying to
avoid the "Re-Print" module. :-)

Many thanks to all who have replied.

Best Rgds,
Prakash.