Recent content by sprijohn

Sweet!!!!!!!!! That worked like a charm! The report now works with any number of records from 0 to infinity (or until the toner or paper runs out). Now the issue is really solved Thank you again!

Success!!! After trying both suggested solutions which stopped the loop but did not print the additional blank lines I spent several hours learning how to use the watches window. I discovered that the error was in the timing of resetting the iLine variable to zero. By remarking out the "iLine =...

Back in December I thought I had this solved. The contributed solutions work well except that in the final DB the reports print based on parameter queries. Occasionally this results in a single record. My dilemma is that we need the resulting sign-in sheet even if it just has one record printed...

Thanks, JHB. Resizing did the trick. This problem in now finally solved! :):) Anybody know how to mark this thread as "Solved"? If anyone is interested in the final product please see attached file. The sign-in sheets are printing properly. Thanks again to all those who helped.

Sorry, my bad. I kept getting interrupted at work and I had too many tabs open. The site kept asking me to log in and when I did not see the first post I was afraid it was lost. I wasn't able to read the posting delay notice when I placed the original post because it flipped thorough too fast. I...

Thank You, Thank You, Thank You, JHB!!!:):):) Your Change in the code at the beginning of the Detail_Format Section got it to finally print (At least to a PDF). I did discover that Print Preview was allowing the report to never exit the module. Clicking on the next page icon created another...

Date is flowing correctly into each page. :):) Just need to pad the last page with blank lines to get 24 lines on it.

June7, I found the page break on the report and removed it. Multiple records are now printing on a page. And it is printing multiple pages. Thanks. I now need to change the data so that there are no duplicates. That will allow me to see which records are printing. Any suggestions on how to...

I'll look into that. The data table only has 25 records. Would the page break in details, which is suppose to only activate when 24 records have been printed on a given page, explain why it is printing hundreds and even thousands (I let it run once while printing to pdf) of pages?

rtpPTSB does work and creates reports exactly like I want in print preview. However, when you send it to a printer (or print to pdf) it runs the page count up as if it is stuck in a loop. I sent it to a printer once and it amassed 400 pages before I could stop the printer. If someone could help...

Sorry I Haven't responded sooner but work got extremely busy and I was not able to work on this until now. I created a new report called rptPTSBAWF to test the code. I removed the TotGrp field in the Header and hard coded a 24 in every instance of that field in the VBA code. When I ran the...

The report in question is rptPTSB. The original code is in rptRenewals_Multiple_Pages. I changed the variable sDocName in frmTestReports from "rptRenewals_Multiple_Pages" to "rptPTSB" to point to rptPTSB and set the default from 6 to 24 in the private sub cmdPreviewMultiple_Click(). Also, I am...

I am an Assessment Coordinator and Data Analyst for a school district in Wyoming, USA. My programming experience has mainly been in structured languages such as FORTRAN, Pascal, etc. My database experience is mostly self-taught and doing a lot of searches on the Internet.

I have a report that I am trying to print that adds blank lines if the number of records on a page is less than 24. The report work perfectly on screen but when I send it to the printer it prints thousands of extra pages. (I test it be printing to a pdf printer which I cancel once I see the page...