[AccessD] changing report caption via code for display in print que

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