473,505 Members | 16,940 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to print only page 1 of a multi-page report

MLH
DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

The above is the syntax I use in VBA to open & print most
reports. Suppose, though, I want to resrict the printout to
page 1 only. Ideas?
Sep 14 '06 #1
3 1258

MLH wrote:
DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

The above is the syntax I use in VBA to open & print most
reports. Suppose, though, I want to resrict the printout to
page 1 only. Ideas?
Did you read the help file yet? You know, under the F1 key? I went
into the VBA help and typed in PRINT and lo and behold, even I could
find it. Is the F1 key on your keyboard missing?

Exercise your fingers. Hit F1. you can ask it questions all day long
without it losing patience.

Sep 14 '06 #2
<pi********@hotmail.comschreef in bericht news:11**********************@b28g2000cwb.googlegr oups.com...

MLH wrote:
>DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

The above is the syntax I use in VBA to open & print most
reports. Suppose, though, I want to resrict the printout to
page 1 only. Ideas?
Did you read the help file yet? You know, under the F1 key? I went
into the VBA help and typed in PRINT and lo and behold, even I could
find it. Is the F1 key on your keyboard missing?

Exercise your fingers. Hit F1. you can ask it questions all day long
without it losing patience.
He has to look for the word 'printout' actually.
Oh I see, that's actually *exactly* what he asked...

Arno R
Sep 14 '06 #3
He has to look for the word 'printout' actually.
Oh I see, that's actually *exactly* what he asked...

Arno R
Now you've spoiled the test!!! I was waiting to see if he looked up
"print" in the help file if he would find it. Hard to believe MLH has
been participating in this NG since about 1997 and _still_ can't find
the help file. Amazing. But I guess Terry's "new user" code was right
on the money.

Sep 14 '06 #4

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

Similar topics

4
6367
by: vincent delft | last post by:
What will be the result if I have several threads that print to different buffers ? I have several threads, each one execute different python code. Just before the "exec" of this small python...
3
2638
by: James | last post by:
Hello, The PRINT command works fine on Query Analyzer. However, when I used it with other Database Client, eg: Aqua Data Studio, nothing got printed out. Is there a way to make it work? ...
3
13806
by: SpamProof | last post by:
I'd like to be able to print multiple documents are once using vb.net. What is the best way to do this with out having to print each document one at a time via a loop . Can't I send them all to...
2
4508
by: ywchan | last post by:
I have tried to print pdf by using gswin32 and call it through the process class but I can't change the paper orientation....no matter I have set dORIENT1 = true / false...it is printed as...
8
2769
by: Ronen Kfir | last post by:
I need to take as an input matrix N*M from stdin & print it as a matrix shape, something like: |6 8 2 4 7| |4 0 1 8 2| |3 1 5 2 6| |9 3 8 4 0| I don't have any idea how...
2
1690
by: chiara | last post by:
Hi! This is a piece of a code I wrote. It was perfectly working but now it is giving me some problems I can not understand. I scan a directory (ss_data) and I count its alaments. then I print...
21
4720
by: g.kanaka.raju | last post by:
Hi, I'm looking for a way to print ® in a C program. Could any of you help me out? Regards, Raju
0
1428
by: Paul | last post by:
Occasionally my users will try to perform an action and be presented with an exception raised directly from SQL Server, in example: SET @err = 'a user-friendly error condition message'...
3
8707
by: Stanley | last post by:
Hi all! I have trouble with printing rich text box that has multi fonts format. I have found some printing example in vb.net on web, but they can only print one font format!! I'm new to printing in...
1
1324
by: paul | last post by:
Hello, I am using a print preview control to display some multi coloured text. I render it fine it all looks great even does multiple pages OK. However when I press the print button on the print...
0
7103
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7307
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7370
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7021
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7478
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4701
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1532
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
755
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
409
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.