Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-05-2019, 11:06 PM   #1
bignose2
Newly Registered User
 
Join Date: May 2010
Posts: 169
Thanks: 0
Thanked 2 Times in 2 Posts
bignose2 is on a distinguished road
Print pages in reverse order to preview order?

Hi,

Is there an easy ish way to view a report print preview in one order, ie 1 to 10 but when press the print button they come out 10 to 1, basically ready stacked in correct order.

I like to view, page view & not report view, 1 to 10etc

I also don't want to have toe close & press a different print button

I imagine I could program this quite easy but my staff want to see what they are about to print but just click print if happy

I can open print preview & line after change the property order but this has no effect

Thanks is

bignose2 is offline   Reply With Quote
Old 11-06-2019, 12:00 AM   #2
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,292
Thanks: 115
Thanked 3,090 Times in 2,808 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Print pages in reverse order to preview order?

Suggest you set the default print order on your printer settings to print in reverse order.
..or use a printer that outputs the pages facing downwards.

IIRC you can also set the pages to print as e.g. From 100 to 1.
I don't think it matters if the From page value is larger than the max pages
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-09-2019, 10:17 AM   #3
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA, USA
Posts: 602
Thanks: 75
Thanked 63 Times in 63 Posts
vba_php is on a distinguished road
Re: Print pages in reverse order to preview order?

bignose,

why not ask your people why this is such a big deal? I've never encountered anyone who has asked this question. The time it takes to rearrange paper after it prints out is extremely marginal, isn't it?

vba_php is offline   Reply With Quote
Old 11-09-2019, 10:22 AM   #4
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,527
Thanks: 441
Thanked 841 Times in 812 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Print pages in reverse order to preview order?

This does it for Excel, perhaps you can adapt?

https://www.exceltip.com/printing-in...oft-excel.html
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
Old 11-09-2019, 11:13 AM   #5
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,292
Thanks: 115
Thanked 3,090 Times in 2,808 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Print pages in reverse order to preview order?

Quote:
Originally Posted by vba_php View Post
bignose,

why not ask your people why this is such a big deal? I've never encountered anyone who has asked this question. The time it takes to rearrange paper after it prints out is extremely marginal, isn't it?
Not if you are doing huge print runs e.g school reports, exam results etc where you may have lots of groups each with multiple pages in a print run.
Then it can be a big deal
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-09-2019, 11:17 AM   #6
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA, USA
Posts: 602
Thanks: 75
Thanked 63 Times in 63 Posts
vba_php is on a distinguished road
Re: Print pages in reverse order to preview order?

Quote:
Originally Posted by isladogs View Post
Not if you are doing huge print runs e.g school reports, exam results etc where you may have lots of groups each with multiple pages in a print run.
Then it can be a big deal
one of my first jobs was in a hospital as a temp employee. the manager once assigned me a task just like this, but it wasn't sorting the print jobs per se, it was "collating" them. but regardless, that hospital actually paid for a person to do this stuff! but maybe this OP's company doesn't have the money to hire people to do this work...


Last edited by vba_php; 11-09-2019 at 11:24 AM.
vba_php is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Print Preview of multiple pages mcescher Reports 14 03-26-2018 10:28 AM
Received quantity distributed based on order number and order date artefact Modules & VBA 5 02-09-2016 02:06 PM
Auto Filling an order checkbox based on whether order details have been ticked. Chill Theory and practice of database design 4 08-13-2015 01:51 PM
Report graph not in abc order/reverse abc/by y-value? Slowlearner Reports 1 05-07-2008 08:22 AM
Repeat Pages for Print Preview and Printing holt77386 Reports 0 08-23-2007 12:51 PM




All times are GMT -8. The time now is 08:36 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World