[AccessD] changing report caption via code for displayin printque

John Bartow john at winhaven.net
Thu Apr 15 00:26:01 CDT 2010


LOL! Yea, maybe two weeks - originally this thing took about two days to run
because the company supplied a huge flat file of the data. I have a feeling
it came from a structured database but the dba won't send it that way (job
security kind of a thing).

I put together a bunch of queries that split it back up, converted all of
the "text" fields back to numeric, date, etc and then indexed it properly
and now it runs in about an hour. Unfortunately not even the best
Imagerunner is going to keep up to that. That is one awesome printer by the
way. About the size of a freight train.

I think there's a way to code this in the module. That's what I'm after :o)

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

If you don't use a caption, I think the name of the report in the queue will
be the report's name, yes?  So could you rename the report before each run? 

Off the wall - output to a pdf with the file name you want, then print the
pdf from inside the access program. 

Brute force - open the report in design view, change the caption, run, open
in design view for the next account number, change the caption(...should
take about two weeks to run 30,000 reports that way, but you'd get there.)

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Wednesday, April 14, 2010 9:28 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] changing report caption via code for displayin
printque

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.

--
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

--
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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list