Automatically printing "Unprinted'" items

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have an invoicing Database in place. All is fine so
far.

I want to add a feature to allow batch printing of
invoices not yet printed.

I'm guessing that I need to create a field called "Print"
which has a default value of "N" and the populated
with "Y" upon printing ...the set up a report to print
all Invoices with a "N" Value in the "Print" field.

Any guidance??
Thank you
 
I have a routine like this. The process is that I print
(in batch) those items where the 'toPrint' check box is
true. I happen to preview the report, then print it and on
the OnClose event, I use a message box where I ask if the
reports printed out OK? (with a vbYesNo). I then have an
IF statement where if YES -it runs an update query to
change the 'toPrint' items to false, else nothing.
When they click NO, those reports will be printed again
the next time.

Hope the concept gets you where you want.

SteveD

-Original Message-----
 
Back
Top