473,320 Members | 2,112 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,320 software developers and data experts.

A97 - 5 records in a recordsource query cause 5 pages to print out

MLH
If I wanted 2 of each page, could I make them print out
2 of first page, 2 of second page, 2 of third page, 2 of
fourth page and 2 of 5th page? Or, do I have to run the
openreport method twice which, of course, gives me 2
stacks containing pages 1-5 each?
Nov 13 '05 #1
10 1743
To get 2 of each page, in the print setup dialog (File|Print) set the number
of copies to 2 and collate to No. To get the pages printed in order (2
sets), set the number of copies to 2 and collate to Yes.

--
Wayne Morgan
MS Access MVP
"MLH" <CR**@NorthState.net> wrote in message
news:m6********************************@4ax.com...
If I wanted 2 of each page, could I make them print out
2 of first page, 2 of second page, 2 of third page, 2 of
fourth page and 2 of 5th page? Or, do I have to run the
openreport method twice which, of course, gives me 2
stacks containing pages 1-5 each?

Nov 13 '05 #2
MLH
Thanks, Wayne. Is this something that I can save with the report, so
that when I roll out a runtime distro to a client, their prints will
come out in the desired manner?

To get 2 of each page, in the print setup dialog (File|Print) set the number
of copies to 2 and collate to No. To get the pages printed in order (2
sets), set the number of copies to 2 and collate to Yes.


Nov 13 '05 #3
MLH
Wayne, apparently setting copies=2 and collate to NO
is a 1-time thing when printing a report. It is not saved
with a report when I make those selections while in
report design view, print the report with those settings
in place then save it.

Maybe there's a way to dynamically modify printer settings
with the OpenReport method or OpenReport action. But I
didn't see any when I looked.
Nov 13 '05 #4
The page setup settings can be saved if you set them in report design view
and save the report, but these are just printer settings. One option would
be to make a copy of the printer and set the copy's default print settings
in the printers control panel applet to the desired settings then choose
which printer to use.

--
Wayne Morgan
MS Access MVP
"MLH" <CR**@NorthState.net> wrote in message
news:rj********************************@4ax.com...
Thanks, Wayne. Is this something that I can save with the report, so
that when I roll out a runtime distro to a client, their prints will
come out in the desired manner?

To get 2 of each page, in the print setup dialog (File|Print) set the
number
of copies to 2 and collate to No. To get the pages printed in order (2
sets), set the number of copies to 2 and collate to Yes.

Nov 13 '05 #5
The PrintOut method in newer versions of Access will allow this. I'll have
to load Access 97 and take a look to see what it has. I found this article
which may help, Access 97 does have a PrintOut method, but it appears that
it may have some limitations. However, they show an example using PrintOut
that may work for you by specifying which pages you want printed and it what
order.

http://support.microsoft.com/default...b;en-us;179315

--
Wayne Morgan
MS Access MVP
"MLH" <CR**@NorthState.net> wrote in message
news:tb********************************@4ax.com...
Wayne, apparently setting copies=2 and collate to NO
is a 1-time thing when printing a report. It is not saved
with a report when I make those selections while in
report design view, print the report with those settings
in place then save it.

Maybe there's a way to dynamically modify printer settings
with the OpenReport method or OpenReport action. But I
didn't see any when I looked.

Nov 13 '05 #6
Ok, I loaded Access 97 and the PrintOut method is there. I had to set a
Reference to "Microsoft Visual Basic for Applications Extensibility" to find
it. Looking at the help file, it appears to have the same settings that the
new versions have. You can type PrintOut in a code window, place the cursor
in the word, then press F1 to get the help for it.

--
Wayne Morgan
MS Access MVP
"MLH" <CR**@NorthState.net> wrote in message
news:tb********************************@4ax.com...
Wayne, apparently setting copies=2 and collate to NO
is a 1-time thing when printing a report. It is not saved
with a report when I make those selections while in
report design view, print the report with those settings
in place then save it.

Maybe there's a way to dynamically modify printer settings
with the OpenReport method or OpenReport action. But I
didn't see any when I looked.

Nov 13 '05 #7
MLH
Thx much, Wayne. I'll check on it when I get back.
Gotta go for now.

Nov 13 '05 #8
MLH <CR**@NorthState.net> wrote in
news:ph********************************@4ax.com:
Thx much, Wayne. I'll check on it when I get back.
Gotta go for now.


I wouldn't use the PrintOut method.

If you have a report that you *always* want double copies, one way
to do it is to embed it twice as a subrreport in another report,
with the data source of the parent report being exactlyl the same,
and the link being on the base table's PK field.

Another alternative that's substantially easier is to use the report
detail's Print event to decide whether or not you want to go to the
next record or not. You could do something like this:
Static lngCount As Long

If lngCount = 0 Then ' you are on the record the first time
Me.NextRecord = False
lngCount = lngCount + 1
Else ' you're on the record the second time
lngCount = 0
End If

If you wanted 3 copies, you change lngCount = 0 to lngCount = 2.

You could also make the number of copies dynamic, if you liked.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #9
Thanks David. Allen Brown has another method for handling the multiple
copies. He says it works better than the code method because the code method
can mess up if you don't print all pages.

Here is a link to that example:
http://www.allenbrowne.com/ser-39.html

While either of these will handle the number of copies, it doesn't handle
the collate option.

--
Wayne Morgan
MS Access MVP
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn*********************************@216.196.9 7.142...
MLH <CR**@NorthState.net> wrote in
news:ph********************************@4ax.com:
Thx much, Wayne. I'll check on it when I get back.
Gotta go for now.


I wouldn't use the PrintOut method.

If you have a report that you *always* want double copies, one way
to do it is to embed it twice as a subrreport in another report,
with the data source of the parent report being exactlyl the same,
and the link being on the base table's PK field.

Another alternative that's substantially easier is to use the report
detail's Print event to decide whether or not you want to go to the
next record or not. You could do something like this:
Static lngCount As Long

If lngCount = 0 Then ' you are on the record the first time
Me.NextRecord = False
lngCount = lngCount + 1
Else ' you're on the record the second time
lngCount = 0
End If

If you wanted 3 copies, you change lngCount = 0 to lngCount = 2.

You could also make the number of copies dynamic, if you liked.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #10
"Wayne Morgan" <co***************************@hotmail.com> wrote in
news:Z_*****************@newssvr25.news.prodigy.ne t:
Thanks David. Allen Brown has another method for handling the
multiple copies. He says it works better than the code method
because the code method can mess up if you don't print all pages.

Here is a link to that example:
http://www.allenbrowne.com/ser-39.html
OK, I hadn't thought about that issue. But it seems to me that it
ought to be fixable by checking the page number. But, then again,
maybe that won't work either.
While either of these will handle the number of copies, it doesn't
handle the collate option.


That's true. There's no real way to do that, except to print the
report twice. Since the reports are identical, that can easily be
done with multiple instances of the same report (multiple report
instances do become a problem if the datasets are not identical).

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: DD | last post by:
I have a mainform with a subform. > The main form has a dropdown box "chooseMonth", in the afterupdate event > i requery the subform so all records with the same date are viewed. > Now i only want...
0
by: Jason | last post by:
I have a primary form which is used to enter/edit data in a table named Test_Results. On this primary form there is a subform which displays site addresses. This subform is linked to the primary...
0
by: Jason | last post by:
I would like to be able to place a command button on a primary (parent) form that opens up a subform. I want to use this subform to search for or limit the recordset of data in the primary form. ...
0
by: Jason | last post by:
I would like to be able to place a command button on a primary (parent) form that opens up a subform. I want to use this subform to search for or limit the recordset of data in the primary form. ...
3
by: Stewart | last post by:
Hi all! My (relatively small) database holds data on staff members and the projects (services) that they are assigned to. In my form frmStaff, I have a list of staff members - it is a...
10
by: Robert | last post by:
How do you get an accurate count of the number of records returned from a query when using linked tables. I have an access 2003 database as a front end to another access 2003 database that...
7
by: underground | last post by:
I have a problem that I've spent countless hours on and I'm more than certain this is a obviuos issue to an expert but I am still learning. I have a paging script that I have modified to display a...
3
by: Arne Reed | last post by:
I work at a Community College. I have been using Access for 4 years to track the number and destinations of transcripts we mail out at students' (and former students' requests). It has worked...
6
by: Dave | last post by:
On my form I have combo boxes. These combo boxes, after updating them, populate respective listboxes that are located below the combo boxes on the same form. I am trying to use a "generate...
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...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.