Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print One Page of Multi-Page Report

Status
Not open for further replies.
churdle

churdle

Programmer
Joined
Apr 2, 2000
Messages
7
Location
US
I have a long Report that is generated....i'd like to just print one page (the page currently viewed by user)....is it possible?<br><br><br>thanks<br><br><br>churdle
 
Sort by date Sort by votes
Look at <br>DoCmd.PrintOut acSelection, PageFrom, PageTo, acHigh, Copies<br><br>
 
Upvote 0 Downvote
The DoCmd.PrintOut is what you need to look at.<br><br>Use a variable to get the number of copies wanted from a TextBox and plug that in for the copies parameter. Have your print button call this code with the On Click Event. <br><br>DoCmd.PrintOut acPrintAll, , , , Copies<br><br>Bob Crawford<br>
 
Upvote 0 Downvote
Sorry! My post above was a reply to another message. Please disregard.<br><br>Bob Crawford
 
Upvote 0 Downvote
Thanks loads guys..i'll give it a try
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A
  • Locked
  • Question Question
Print Table attachment
Replies
2
Views
548
andre.meyer
A
lmcate
  • Locked
  • Question Question
How to Open ACCESS (MDB) from an HTML Page
Replies
2
Views
5K
lmcate
lmcate
renigar
  • Locked
  • Question Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar
lameid
  • Locked
  • Question Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
1K
lameid
lameid
Bubba002
  • Locked
  • Question Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top