473,326 Members | 2,168 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How to print duplex Access Report

7
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)

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "myreport", acViewPreview,,,acHidden
  2.  
  3. Reports("myreport).Printer.Duplex = acPRDPHorizontal
  4.  
  5. DoCmd.OpenReport "myreport", acViewPreview
But have no clue how to actually put it into access. Thanks in advance for helping out a newbie
Feb 26 '13 #1

✓ answered by zmbd

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"
Feb 26 '13 #2
NewVBA
7
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
Feb 27 '13 #3
NewVBA
7
@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
Feb 27 '13 #4
Rabbit
12,516 Expert Mod 8TB
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.
Feb 27 '13 #5
NewVBA
7
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
Feb 27 '13 #6
Rabbit
12,516 Expert Mod 8TB
I don't know what a unit footer is but just put two page breaks in the group footer. It works for me.
Feb 27 '13 #7
NewVBA
7
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?
Feb 27 '13 #8
zmbd
5,501 Expert Mod 4TB
NewVBA:
If you would, please review the information within the following links.
It is very importaint that the standard names/terms be used... not only so that the Experts can understand your question, but also, so that you can understand the answers given to you.

> Introduction to reports
> Create reports for a new database - Online Class offered by MS
> Description of frequently used terms in Microsoft Access
> Database design basics
Feb 27 '13 #9
NewVBA
7
I will do that. Thank you for the information
Feb 27 '13 #10
Rabbit
12,516 Expert Mod 8TB
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.
Feb 27 '13 #11
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!!!!!
Feb 27 '13 #12
NewVBA
7
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
Feb 27 '13 #13

Sign in to post your reply or Sign up for a free account.

Similar topics

1
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
3
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...
0
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...
2
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...
15
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...
1
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...
1
by: Alexeye2008 | last post by:
Hi everyone! Is it possible to print an Access Report from vb6 code?pls help me!!
1
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...
0
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...
2
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
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
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...
1
isladogs
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...
0
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...
0
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...
1
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...
0
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
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.