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