dialog box "was print successful?"

[Guest]

I would like to check a "checkbox" when a good copy of report prints. The
checkbox is used in queries to qualify details in future reports. A dialog
popup would be nice, but is unecessary. If the checkbox were check
automatically when the report prints, that would be wonderful.

 

[Douglas J. Steele]

Since all Access is capable of knowing is that you initiated the Print
command, but not that the print was actually successful, I don't agree that
the popup is unnecessary. Lots of things could go wrong while printing
(insufficient toner, so that the print is illegible, problems with the paper
feeder so that the report isn't printed straight on the page, etc., etc.)

I'd show code do set the boolean field(s) to True if the print job is
successful, but it's unclear from your post what you want to update. In
general, you'd use something like:

If MsgBox("Was the Print job successful?", _
vbYesNo + vbQuestion) = vbYes Then

' code to update the underlying table(s). Something like:
CurrentDb.Execute "UPDATE MyTable " & _
"Set Printed = True", dbFailOnError

End If

 

[Guest]

Thank you. This looks like it will do what I want. I will try it and get back
with you.