[AccessD] changing report caption via code for display in printque

Gustav Brock Gustav at cactus.dk
Thu Apr 15 01:31:06 CDT 2010


Hi John

I have never tried, but a form can be opened a second time as a new instance of the first - perhaps you can do the same with a report? Open it first in preview with the adjusted caption for a client using one dummy record, then open as a second instance the actual report for direct print? At the close event of the report, close other instances of the report as well.

/gustav


>>> john at winhaven.net 15-04-2010 06:27 >>>
Hi Rocky,
I have a bound field on the report for the account number which comes from a
query. What I want to do is change the Report's caption to include the
current account number in the caption.

If you preview a report and then print it (pause your printer so you can
look at its que) you will see that the document name listed in the que is
the report's caption. When there are 9000 documents with that particular
name it becomes meaningless. So what I would like to do is change the
report's caption so that the document name in the print que becomes useful.

I just can't seem to figure out how to do this without previewing every
report, which, would be an absurd thing to do.

I recall seeing something about this in the past but I can't find the thread
now.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, April 14, 2010 10:54 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] changing report caption via code for display in
printque

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.






More information about the AccessD mailing list