Hello,
I have my report set up correctly. In print view it looks good. When I send it to the printer to print duplex, it prints front to back and ignores the page ejects. I’m not well versed in VBA; I'm looking for code and how to insert it into the right access area. I’ve seen code (if this is going into the right direction) - DoCmd.OpenReport "myreport", acViewPreview,,,acHidden
-
-
Reports("myreport).Printer.Duplex = acPRDPHorizontal
-
-
DoCmd.OpenReport "myreport", acViewPreview
But have no clue how to actually put it into access. Thanks in advance for helping out a newbie
Ahhh.. hit tab and enter...
Yes, printer settings can also botch things.
If you have your printer set to print two per page, front and back, then you have four "pages" per sheet of paper.
So In one report I have, with the printer setup as above, the first 61 pages for Company "A" print on 17 sheets of paper with page 61 on the front left side of the paper and the next company ( "B" ) on the right side of the paper (sheet 17).
What I suspect you'd want in this situation is that Company "B" start on a new sheet of paper (sheet 18).
So... try the following: Duplex reports: start groups on an odd page
>>>Note, this would be for 1 page per sheet of paper. To solve the situation I have described would take an additional amount of magic as with 2 pages per sheet, you get 2 odd pages per sheet so the break is supper special!!!!!
12 7117 zmbd 5,501
Expert Mod 4TB
I don't understand what you mean by "page ejects"
Sorry for the confusion. When I send the document to the printer to print duplex, it doesn't seperate each group when the group changes, it just prints all of it together front to back. Does that make sense? Thanks for the patience
@zmbd
I think I replied incorrectly, I appoligze. Sorry for the confusion in my post. When I send the document to the printer to print duplex, it doesn't seperate each group when the group changes, it just prints all of it together front to back. Does that make sense? Thanks for the patience
Do you mean that it's not putting in a page break on a new group? Or it's not going to a new sheet on a new group?
You should be aware that a sheet of paper has two pages. If you want each group to go on a new sheet, you just need to insert two page breaks after each group.
Rabbit
sorry hit the wrong button. Not my day. It's not going to a new sheet on a new group. I put 2 page breaks after the unit footer and page footer. No go
I don't know what a unit footer is but just put two page breaks in the group footer. It works for me.
Rabbit
Unit is what I grouped on and created a footer. I put the page breaks in the group footer and it still does not break each group. I set the Lexmark printer to print duplex, could it be the printer?
I will do that. Thank you for the information
Well, it could be your printer. I mocked up a report. Put in a group, put page breaks in the group footer, and printed it in duplex and it came out fine.
zmbd 5,501
Expert Mod 4TB
Ahhh.. hit tab and enter...
Yes, printer settings can also botch things.
If you have your printer set to print two per page, front and back, then you have four "pages" per sheet of paper.
So In one report I have, with the printer setup as above, the first 61 pages for Company "A" print on 17 sheets of paper with page 61 on the front left side of the paper and the next company ( "B" ) on the right side of the paper (sheet 17).
What I suspect you'd want in this situation is that Company "B" start on a new sheet of paper (sheet 18).
So... try the following: Duplex reports: start groups on an odd page
>>>Note, this would be for 1 page per sheet of paper. To solve the situation I have described would take an additional amount of magic as with 2 pages per sheet, you get 2 odd pages per sheet so the break is supper special!!!!!
Thank you.. Thank you.. Thank you ALL. I've been searching for ever. This works. One last stupid question please, since I am so new at this site, and have clicked so many buttons to reply etc. Where is the "choose as best answer button", I think I clicked it before, but I did not mean to. I want this to be the best answer. Again sorry for my lack of knowledge
Sign in to post your reply or Sign up for a free account.
Similar topics
by: El_Embozador |
last post by:
Hi , please can you tell how i can print an MS ACCESS Report form visual
basic, i ned a sample code ..
Thanks
|
by: Nicola |
last post by:
Hi Everyone,
I am new to programming and would like to know how to
open an access Report from within vb 6. I am trying to write a program
to organise cross stitch threads. I have found out how...
|
by: KohlerTommy |
last post by:
In my application I need to give the user the ability to print duplex if the
selected printer supports duplex printing. Many of the printer options do
not make much sense in my application, and...
|
by: G |
last post by:
I am trying to duplicate the printing of a shortcut-print of an access
report in my NT Scheduled Tasks. I can now print the report manually
very easily by right-clicking on a shortcut to the access...
|
by: Mark C |
last post by:
All,
I have exhaustingly been looking through the newsgroups in search of a way
to systemically output an Access 97 report to a pdf file using the full
version of Adobe Acrobat. I want the user...
|
by: Hemant Trivedi |
last post by:
Hi I am Hemant
Hello to everone
Now I want to discuss a problem I am facing in Ms-Access report and I want solution of it can U help me?
My Problem is
I want to print an invoice through...
|
by: Alexeye2008 |
last post by:
Hi everyone! Is it possible to print an Access Report from vb6 code?pls help me!!
|
by: sonicfun2006 |
last post by:
I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. I’m trying to...
|
by: nilesh tayde |
last post by:
how can i pass parameter to print access report by giving parameter as Report File Name,Query,PrinterName,Number of copies to be print
my code is
Function fPrintRemoteReport(strMDB As...
|
by: damola |
last post by:
Please how can i print ms access invoice(report) faster
It takes a lot of time for it to print through a bixolon thermal printer
thanks in advance for your help
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |