Results 1 to 3 of 3
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313

    Embed Invoice Print within Statement Print

    I am converting from a Procedural type system where when they print a Customer's Statement, if requested, the open invoices for the Statement that just printed will also print. These invoices are intermixed with the Statements so it is easy for the operator to take the Statement and, since the Invoices are printed right after the Statement, the invoices and stuff them in an envelope. Is there a way for the Statement program to close the printer at the end of a customer's statement and call the Invoice Print program to print the Invoices that correspond the the Statement that just printed. Then when the invoice print report is done, open the printer to print the next Statement? Both Statements and Invoices are printed on stock paper so there is no need to prompt the operator to change forms.

    Thanks, Eddie

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Open recordset of customers. In loop structure, print statement, print invoices for current record, move to next record, repeat print.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313
    Thanks. That worked like I want it to. I appreciate your suggestion.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-03-2012, 03:15 PM
  2. Print all reports from a select statement
    By TimMoffy in forum Programming
    Replies: 4
    Last Post: 05-31-2012, 01:58 AM
  3. Replies: 5
    Last Post: 10-26-2011, 02:59 PM
  4. Replies: 0
    Last Post: 02-22-2011, 05:04 AM
  5. Error when trying to print or print preview
    By TriAdX in forum Reports
    Replies: 8
    Last Post: 08-25-2009, 08:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums