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 RepliesI have a report , which i print every month and it consist of of more than 500 pages. This report is based on a Query called L_Inv2. i want to filter and loop this report based on the filed AccountReference with in the query. And save as PDF for individual accounts.
i have also created another query based on the L_Inv2, Called L_Inv4 which only got the record of account numbers as a AccountReference
i am trying to use below code but some how this is not working.
Code:
Private Sub Command43_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
[Code]....
I have a report that's oriented landscape. I have scaled and placed everything to fit on a 11" x 8.5" page (the current dimensions of the report are 10.375" x 7.75"). The Layout view shows that everything fits within the borders.
Despite all of this, Print view insists on including a second, blank page. And since the general user will initially be viewing it in Report view (which doesn't indicate 2 pages), then printing if they so desire, they won't know there's a blank page.If not, I'll just tell people to make sure to only print page 1 in the printer dialog box.
I have an access report that consists of numerous other subreports. My issue is that one last blank page prints at the very end of the report. All margins are sized correctly and have set the 'Force New Page' setting to 'None' for all Group Headings (I should mention that I have each subreport within it's own group heading...so a total of 8 subreports in 8 group headings). The odd thing is that I have the page #'s printing in the page footer and on the last page it's printing page + 1 of x pages (e.g. page 129 of 128). I have removed the report header and footer, but have the same result. None of the other subreports produce an extra page when run separately.
View 2 Replies View RelatedI have a multi-field search form with a tickbox that is tied to 2 queries that is tied to 2 reports. The form works great and I get all the results I want, but my report doesn't display on my monitor, it simply prints up! How can I get it to stop doing this and show only on my screen?
My code on the "run search" button is:
If Me.[OptionalCheckBox]=True Then
DoCmd.OpenReport "rptReport1" acViewNormal, acWindowNormal
Else
DoCmd.OpenReport "rptReport2" acViewNormal, acWindowNormal
We recently converted to Access 2010 after using 2000. This problem has suddenly appeared. It doesn't happen on every report but there is one in particular right now and I can't figure it out.The first page of the report is complete but it prints a second page containing only the page header and footer, the rest blank. There are only 2 detail records on the first page and plenty of blank space.
It's not the issue of the page overflowing onto extra pages because the page size bleeds beyond the margins. Everything is safely inside the set margins, and in fact as a test I brought the page width down to 4 inches with .5" margins and it still prints a second page.
I have a sub-report and the last row is highlight, however, there seems to be extra spacing after the last row. I removed all report/page header/footer so all what's left is the Detail section but I still have this white space after the last row.
View 5 Replies View RelatedThe first report example is what I get when I start on the main form and select an organization, run the report, opens report - BIG SPACE between the details and my footer section which holds a subform.
The second report is what I need it to look like, what's strange to me is I get the report correctly when I just run the report (I don't pass the organization into the report from the main form)
I tried changing the background color of the detail section and the footer section to figure out where my problem is but the space just stays white.
I have been modifying an existing report that was formatting and printing fine but since I modified it (adding some text boxes and moving some controls around), it is now adding a blank page.
For example, If the report was normally 2 pages long with page numbers, it is inserting a blank page without page number between page 1 and page 2......
I am creating a form that is a letter. This letter will get printed off a lot. A line at the bottom of the sheet makes it look tacky. I am told this line prints on our other databases also. How do you get rid of it? Our company uses access 97 :mad:
View 6 Replies View RelatedI have a report with an embedded subreport. It's set up in two columns, ordered across then down.
My problem is when column 1, row 1 section is taller than column 2, row 1 section. It creates a lot of extra white space as I fill in the rest of the report. Is there a way to eliminate that space or am I stuck?
i have a query that prints records from 3 different tables that match values entered through a combo box on a form.
here is the code (i know its messy):
SELECT Host_Countries.HostCountryName, Guest_Countries.GuestCountryName, Census_Data.ForeignBornTotal, IIS_Data.IISData, CoE_Data.ForeignCitizenship
FROM ((Host_Countries INNER JOIN (Guest_Countries INNER JOIN Census_Data ON Guest_Countries.GuestID = Census_Data.GuestID) ON Host_Countries.HostID = Census_Data.HostID) INNER JOIN IIS_Data ON (Guest_Countries.GuestID = IIS_Data.GuestID) AND (Host_Countries.HostID = IIS_Data.HostID)) INNER JOIN CoE_Data ON (Host_Countries.HostID = CoE_Data.HostID) AND (Guest_Countries.GuestID = CoE_Data.GuestID)
WHERE (((Host_Countries.HostID)=[Forms]![frmHostForm].[cboSelectHost]) AND ((Guest_Countries.GuestID)=[Forms]![frmHostForm].[cboSelectGuest]));
what i want it to do is to print what it shows, but then also have it print me the min and max values (the range of the data) in a new column as well. is this even possible? does anyone know what i mean? any help would be greatly appreciated.
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?
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 RelatedThese 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
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.
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 RelatedI 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?
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.
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 RelatedI 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.
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.
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 RelatedI'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.
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 RelatedI 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?