By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,307 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,307 IT Pros & Developers. It's quick & easy.

Multiple invoice prints

P: 67
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.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "rptConfirmation", ReportDest, , "[tblSales]![DateOfVisit] Between [Forms]![frmInvoicePrint]![From Date] And [Forms]![frmInvoicePrint]![To Date]"
  2. DoCmd.OpenReport "rptParentLetter", ReportDest, , "[tblSales]![DateOfVisit] Between [Forms]![frmInvoicePrint]![From Date] And [Forms]![frmInvoicePrint]![To Date]"
  3. DoCmd.OpenReport "rptInvoice", ReportDest, , "[tblSales]![DateOfVisit] Between [Forms]![frmInvoicePrint]![From Date] And [Forms]![frmInvoicePrint]![To Date]"
Jul 3 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 904
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 ('InvoicePrinted') 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.


Jul 3 '09 #2

P: 67
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.


Jul 3 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.