Multiple invoice prints

**mshmyob** · Jul 3 '09, 11:55 AM

Hello Wayneyh

What I have done for my invoice applications is have the user confirm that an invoice has printed properly. If they click on the 'Yes' button I update a field I have in the table ('InvoicePrinte d') to indicate that invoice has printed. Having a user OK that an invoice has printed properly is the best way for audit control.

Any subsequent prints of that invoice has the word 'DUPLICATE' as a 'watermark' across that invoice so it can never be mistaken for the original.

I also never allow the invoice to be edited after the Invoice has been checked off as printed.

This procedure has never failed me or the clients and accountants appreciate it as it ensures a proper audit.

cheers,

Originally posted by Wayneyh

Hi all

My problem is as follows. At present we can print multiple invoices by means of a Form with a from date textbox and a to date textbox. After inputting the dates required we click a button called btnSearch. How do i check a check box for each invoice to show that it has been printed. Below is the piece of code for the date range. Any ideas will be appreciated.

Code:

DoCmd.OpenReport "rptConfirmation", ReportDest, , "[tblSales]![DateOfVisit] Between [Forms]![frmInvoicePrint]![From Date] And [Forms]![frmInvoicePrint]![To Date]"
DoCmd.OpenReport "rptParentLetter", ReportDest, , "[tblSales]![DateOfVisit] Between [Forms]![frmInvoicePrint]![From Date] And [Forms]![frmInvoicePrint]![To Date]"
DoCmd.OpenReport "rptInvoice", ReportDest, , "[tblSales]![DateOfVisit] Between [Forms]![frmInvoicePrint]![From Date] And [Forms]![frmInvoicePrint]![To Date]"

**Wayneyh** · Jul 3 '09, 12:21 PM

Thanks mshmyob

I thought about doing it that way but was just trying to save a bit more time.

The way you suggest is the better way i think.

Regards

Wayne

Multiple invoice prints

Multiple invoice prints

Comment

Comment