Rocky Smolin
rockysmolin at bchacc.com
Wed Apr 14 22:54:28 CDT 2010
Could you put the account numbers in a table or write a query to get all the account numbers? Then make that table or query the record source for the report with the account number as a bound field on the report? Print the report once - it will print x number of pages depending on how many account numbers are in the record source. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Wednesday, April 14, 2010 7:51 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] changing report caption via code for display in printque BTW this is an actual ACCESS post! ;o) Access 2003 to be exact. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Wednesday, April 14, 2010 8:56 PM To: _DBA-Access Subject: [AccessD] changing report caption via code for display in print que I'm working on making niceties for an application which generates about 30,000 sheets to be printed by a Imagerunner 110 device. This device uses a Linux controller box to que/hold/start the jobs. Since there are so many jobs it would be nice to be able to distinguish them while in the que. So I'm attempting to have the account number of each client show up in the caption of the report when printed in order to have the account number show in the print que of the printer. Depending on the report it should appear something like: Order Form - 029384 In my procedural code I use this type of command to print various reports: DoCmd.OpenReport "rptOrderForm", acViewNormal I placed this in the report's module expecting it to accomplish this task: Private Sub Report_Open(Cancel As Integer) Me.Caption = Me.Caption & " - " & CurrentAcct() End Sub The report will display the caption as I intended if opened in a preview window and then it will display it in the print que once printed but it will not display it if opened with acViewNormal which sends it directly to the printer. Anyone have an idea of how I can achieve the intended results? Tia, John B. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com