Reports :: Printing Twice As Many Pages As Necessary

Feb 25, 2014

I have a report where the detail section, holding 4 subreports, takes up 5 inches in the middle of the page between the header and footer. We want the entire 5 x 8 area enclosed in a box on every page. I have tried to achieve this by putting a line in the Detail_Format section:

Code:
boxDetail.Height = 5 * 1440 * Pages

However, when I run the report, I get pages 1/3 correctly, then 2/3 and 3/3 with no detail section or box, and then pages 4/3, 5/3, and 6/3 with blank detail sections and no box. If it's a 1-page report, the same - page 1/1 is perfect and page 2/1 is blank, no data and no box. I also sometimes (but not always) get overflow errors from the Detail_Format event.

I know it's not a margin error because that would be every other page, and the page count wouldn't be doing that. (Still, I have scrupulously checked every margin, and they all look fine.) Getting this look on the report is a priority. Any way to achieve the same result with the box without causing the missing data and extra pages?

View Replies


ADVERTISEMENT

Reports :: Printing Multiples Of Specific Pages

Mar 28, 2013

How would I go about printing multiple pages of a certain page in a report. My goal is to get them to collate together. Please see example below:

I have 7 operation codes (A-G), but I need multiple copies of each within a set:

Below is how I would like to print it out:

A, A, B, C, D, D, A, E F, G

Also, not sure if it matters, but the report has a subreport to print the appropriate rework code on the back of every sheet (2 sided printing)

This will be the same every time, and I have made a tbl in the db with the order I require.

View 1 Replies View Related

Reports :: Chart Report Printing Additional Pages?

Oct 1, 2014

I've got a report, which on the screen is three chrts and a page break in between. Page is set up to print landscape.

When I print the report or save to pdf it adds a lot of pages in between 2 and 3. It seems to be of chart no.2 getting smaller and smaller. I've attached a copy of the pdf so you can see what I mean.

its doing this on all my reports.

View 7 Replies View Related

Printing Problem: 2 Pages Per Sheet

Oct 7, 2005

When I print reports, Access is printing 2 pages per sheet, making the text VERY small. However, EVERY setting that I can find, whether the main printer setup or the Access program itself, shows that it's supposed to print only ONE per page.

The only program that this occurs with is Access. Is there a setting somewhere that I'm missing? Thanks.

View 6 Replies View Related

Printing Multiple Pages On A Report

Feb 11, 2008

With Access XP, I have a simple two page report (with a subreport included). When I go to print it, it prints out about 32 copies.

Of course, in the Windows print que, it is set to one copy.

There has to be some setting in the report causing this.

Thanks

View 9 Replies View Related

Modules & VBA :: Restrict Printing Rights To Users - Print Blank Pages

Feb 10, 2014

I've been asked to make sure only certain users in my database are able to print anything (i.e. Administrators). Is there any option/property to do this?

I have already built in User Access controls using the ctl.Tag property. The only way I can think off the top of my head is when a 'general user' uses it, to ensure that every control is displayed 'on screen only'. This of course doesn't stop them printing - just makes them print blank pages!

View 12 Replies View Related

Modules & VBA :: Printing Code Slowing Down Printing Reports?

Feb 25, 2014

I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.

This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)

So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.

So all I had to do was say:

Code:
PrintMe("Invoice","InvoiceID",iID)

and a report would print to exactly how I wanted... but it's just too slow!

See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.

Code:
Function PrinterOK(sPrinterName As String) As Boolean
Dim MyPrinter As Printer
PrinterOK = False
For Each MyPrinter In Printers
If MyPrinter.DeviceName = sPrinterName Then
PrinterOK = True
Exit Function
End If
Next
End Function

I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.

View 1 Replies View Related

Reports :: How To Set Number Of Pages Within Report

Jul 10, 2013

I have already created a summary report that is one page long, however, every time I view my report in report view, export to PDF or print, the report has duplicate copies! Not blank pages. Just duplicate copies of my one page. The report is generating hundreds (about 700) of the same exact page. How do I force my report to have just one page.

View 3 Replies View Related

Formatting Text For Access Reports AND Web Pages

Nov 21, 2007

These days more and more of my databases are wanting to be accessed via the web as well as from MS Acess. I guess this is the norm these days but in most of our (office) dbs it's just 'web for web's sake' and there is no real need to access it outside of Ms Access.

Bu hey that's what they want...

Problem with one such db is that a lot of the fields are memo fields and hold a LOT of text and they want to create MS Access reports/PDFs as well as have nicely formatted html for the text on the web pages.

I seem to be able to cater for one or the other but not both.

1. I can leave the memo fields as raw text and the reports/PDFs look fine with the report formatting, but on the web page there is no formatting and the text ends up in one block paragraph with no formatting.

2. Use a html control for the hmemo fields and store all the html tags within it. The web page looks nicely formatted but the html tags will show up in the PDFs!

I've tried various tag stripping tools but they seem to give unpredictable results.

I also don't want to just dump the PDFs on the web, as they will be static and it's just plain lazy!
(too many unnecessary PDFs on the web IMO)

Is there any way i can cater for both formats?

Many Thanks

View 1 Replies View Related

Reports :: Split Report Into Pages By A Group

Sep 19, 2013

I have a report that has a number of grouping levels.I would like the highest grouping level to determine a new page.

View 2 Replies View Related

Reports :: Form Prints Two Extra Pages

Aug 25, 2014

I have a form that looks and prints exactly as I want it to, except for two little things. These things are extra pages. They don't appear on the print preview, but they always show up on the printer and on the pdf file when I email it. One page is blank and the last page has "Page 1 of 1" at the bottom right corner of the page. I would always limiting the printing to one page.

View 7 Replies View Related

Reports :: Separate Pages By Unique Field?

Jul 29, 2013

I have a DB with all my patients and (among other things) all their referral source.

I would like to print a status report of all my patients, grouped by the referral source, and fax them to the appropriate offices. Easily done with the report wizard.

What I need to know is, how do I create one report, but force a new page for each referral source?

View 4 Replies View Related

Reports :: Split Data Into 2 Pages Per Record

Sep 20, 2013

My records are huge, with 2 memo fields. One memo field has the complete content of journal articles, so it's quite a lot of text. What I'd like to do is, per the title, split record data into 2 report pages each with the first page holding the summary field data and the second page holding the journal content only.

I've experimented with the page break functions, can grow / can shrink properties and some of the other things that would be relevant here but can never seem to get them to work.

View 1 Replies View Related

Reports :: Getting Report To Print / Create PDF Of All 3 Pages

Mar 10, 2015

I'm working with getting a 3 page report to print/create PDF of the 3 pages. Right now I have the formatting set up for the 3 pages but each is an individual report.Is there a way to combine the reports into a single report? I've been messing around with subreports but can't get it to display correctly.

View 3 Replies View Related

Reports :: Changing The Total Number Of Pages?

Feb 3, 2015

I have a report I want to generate in Access 2010. I have a text box with the following:

Code:

="Page " & [Page] & " of " & ([Pages]+[Forms]![ReportForm]![PageCount])

What I am attempting to do is increase the maximum number for the total number of pages in the report. As it reads right now when I go into print preview it looks like

"Page 1 of " That is all. It doesn't seem to calculate the new total number of pages. Yes the report form is open, and yes there is value in the PageCount in the Report Form.I had this working in another database, but this one isn't being as nice. The reason for adding to the total page count is because additional pages will be added to the report that aren't in the database. how to increase the total number of pages in the report.

View 1 Replies View Related

Reports :: Unable To Go Beyond 3 Pages Since Page Footer Is Not Moving Down

Apr 28, 2015

I was able to create only 3 pages in access report. I am not able to go beyond 3 pages since the page footer is not moving down, means I am not able to drag it down.

It is a simple report of resume with only text boxes. My report comes around 10 pages.

View 6 Replies View Related

Reports :: Send Only One Or Two Pages Of A Multi-page Report

Jun 29, 2013

Send only one or two pages of a multi-page report. I have a report that has three pages. I only want to send the first two as a pdf file. Can this be done with VBA? I know it can be done using Exporting Data on the External Data ribbon, but how can I do it via VBA?

View 4 Replies View Related

Reports :: Conditionally Expand Chart Onto Multiple Pages

Dec 13, 2013

Have a generic dashboard report with multiple charts in it. One in particular is a bar chart, but depending on what the dashboard is produced for, the bar chart may have too many bars in it to make it legible. Therefore I'd like to conditionally determine the number of bars (basically the number of records in the query) and then make the chart go from one page and continue onto another.

View 4 Replies View Related

Reports :: Printing Separate Reports Into One Combined PDF Using VBA?

Jul 1, 2013

Currently I have five separate reports setup in Access 2010 (that are running off of five separate queries). Since they have different data/fields, I was unable to combine into one query & one report.

However, I print each to PDF and then combine using Acrobat Pro. Is there a way to combine in VBA and not have to do the step using Acrobat Pro?Function PrintReports()

DoCmd.OpenReport "Program_Summary_1", acViewPreview
DoCmd.OutputTo acOutputReport, "Program_Summary_1", "PDFFormat(*.pdf)", "C:DesktopPrintFiles" & "Program_Summary_1" & ".pdf", False
DoCmd.Close acReport, "Program_Summary_1"
DoCmd.OpenReport "Program_Summary_2, acViewPreview

[code]......

View 3 Replies View Related

Reports :: Printing Multiple Reports From One Button

Apr 23, 2014

I have a form that produces Year end accounts, therefore each page is totally different from one another, there are 10 reports per set of accounts.

I have created 10 buttons that out puts the desired report

Profit and Lost, Balance Sheet etc.....

What I would like now is a way to print all 10 reports with the click of a button, how can this be done...

View 7 Replies View Related

Reports :: Adjust Section Width To Avoid Blank Pages

Nov 18, 2014

I have set up a report in Access. However, when I look at it in print preview, I get the message that the section width is greater than the page width, and that some pages will be blank. It is obvious that the Detail Section is the issue, but I can't figure out how to reduce the section width. The detail section only contains a few text boxes that are well within the margins of the other sections.

How do I adjust the section width so there won't be any blank pages?

View 6 Replies View Related

Reports :: Reset Total Pages For Each Group In Access Report

Mar 3, 2013

I can not get my Access Report to give me a total number of pages by group. I've been able to have it give the correct page number per group but not the total number of pages in each group. I've looked at the threads and it appears that in order to get this, you must do a 2 part pass. 1st to get the page number and then to get the total papers per group.

I've used the code supplied and when I do a print preview, I get the message that it can not find the control, Me!ctlGrpPages. This is the control I created and placed in my page footer section of the report. I've also seen numerous references to the report, "Employee Sales by Country" in the Northwind database. I downloaded the database but could not find this report in the database.

View 3 Replies View Related

Reports- Printing

Nov 29, 2005

Hey all, I have a problem I was hoping that someone could help me with. I am trying to add my digital signature to my report. Since I have added an activeX Control to my form which display and stores my signauture, I would like to display it on my report as well (if it apperas with the record) So I added it like any other control to the report but when it is saved it is letters and numbers, so I have to make it back into a digital signature. Can anyone help me.Thanks

View 4 Replies View Related

Printing Reports In Excel

Jul 17, 2006

hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks on that button it opens another form with 3 options
1) Problems all report
2) problems resolved
3) Problems not resolved
Now what i really want is when a user clicks on Problems all report it should go directly into excel worksheet based on my query which i have assigned and the width, column should be perfect in excel so then a user can print. secondly same thing goes for problems resolved based on my query which wil show all the problems which have been resolved and should open it in excel with everything alligned and ready to print. i know it is possible and i have been able to just print Problems all based on report not with my query and the formatting was really bad. i need to print reports based on my query directly in Excel worksheet with everything perfectly formatted. any help will be really appreciated.
Thanks alot

View 1 Replies View Related

Reports Printing To My Own Printer

Jan 10, 2008

Good morning,

I've created a pretty powerful Access Database that pulls information out of some ODBC tables we have on our local server. Of course, I created the database and all the forms and reports on my work computer here. But, when I was finished, I sent that entire database out to probably 20 or 30 people in the company. On a daily basis, they run the same program from their own computer and they like to print/export/etc. the reports that are produced. However, I don't understand why those reports print our on my personal printer (the printer is on the network). If they have a default printer at their site, why wouldn't it print there? Also, I haven't included any printing macros or VBA coding. I'm tired of having 30 or 40 sheets of paper print out on my printer daily. Any suggestions?

View 3 Replies View Related

Reports :: Not All Data Is Being Printing Out

Jan 13, 2015

Not sure why this is doing this. When I print out my report, it will print most of the items, and leave some out. When I go back and check the information is in the database correctly, but it wont print out.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved