Marking a PO as Printed

  • Thread starter Thread starter Gary.
  • Start date Start date
G

Gary.

I am setting up a database to handle Company PO's.
I have every thing working but I need a way top mark a PO as printed so
that I will not be printed twice.
I think I need a command button the my form that will Mark a check box
indicating that the PO has printed and then print the PO
I don't want the box checked if the PO is just previewed
 
You can do what you suggest but ......
There is no way you can tell if something was actually printed. And what if
someone prints one but the printer jams or runs out of toner and they need to
print it again?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
First you need to a yes/no field to a relevant table (PO table?)..
then a checkbox on the form bound to the field, called chk1.
A command button:
Private Sub Command0_Click()
DoCmd.OpenReport "reportname", acViewPreview
If Not (Chk1.Value) Then
DoCmd.PrintOut acPrintAll
End If
End Sub

the user would update the checkbox after PO is printed or you can add coding
to update automatically in the above code like:
If Not (Chk1.Value) Then
DoCmd.PrintOut acPrintAll
me.chk1.value=true
End If

Damon
 
Gary. said:
I am setting up a database to handle Company PO's.
I have every thing working but I need a way top mark a PO as printed
so that I will not be printed twice.
I think I need a command button the my form that will Mark a check box
indicating that the PO has printed and then print the PO
I don't want the box checked if the PO is just previewed
Click to expand...

If you are just printing one at a time, just add a checkbox called "Printed"
and click on it to mark it.
There is no need for a separate button and if you need to reprint it you can
just uncheck it.
I base my printing on a query which will only print documents where Printed
= False.
If you are printing multiple PO's then you can
print all that are false.
Pop a message box to make sure they printed correctly (left over from the
days of line printeres, but still handy) and then run a query to mark them.
 
I use the same approach, except I generally use a datePrinted field instead
of a checkbox, in case it would be useful to know when it printed.
 
Back
Top