UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Limit Pages In Docmd.outputto, Access 2016    
 
   
whitechair
post Jun 27 2019, 02:47 PM
Post#1



Posts: 491
Joined: 26-June 08



Is there a way to limit the number of pages in a DoCmd.OutPutTo? The rport can get over 50 pages long, but I really only need the first 5 pages.

Here's the code I currently have:
CODE
DoCmd.OpenReport "rptPreviousMonthViolations", acViewPreview, , "[DOT] =" & vDOT
DoCmd.OutputTo acReport, "rptPreviousMonthViolations", acFormatPDF, vFileName1, False
DoCmd.Close acReport, "rptPreviousMonthViolations"


--------------------
Jeff Moseler
Access 2007
Go to the top of the page
 
Dan Dungan
post Jun 27 2019, 03:02 PM
Post#2



Posts: 319
Joined: 20-July 10
From: chatsworth, ca


Will the DoCmd.PrintOut method do what you need?

--------------------
Dan
Go to the top of the page
 
whitechair
post Jun 28 2019, 09:31 AM
Post#3



Posts: 491
Joined: 26-June 08



It might, except that it would require the user to input a file location to create and save the PDF and I would like to avoid that.

Is there a way to skip that part?

--------------------
Jeff Moseler
Access 2007
Go to the top of the page
 
Dan Dungan
post Jun 28 2019, 02:04 PM
Post#4



Posts: 319
Joined: 20-July 10
From: chatsworth, ca


I don't know. I've never used it. Maybe someone else here has experience with it.

--------------------
Dan
Go to the top of the page
 
Phil_cattivocara...
post Jun 28 2019, 11:20 PM
Post#5



Posts: 318
Joined: 2-April 18



QUOTE
...it would require the user to input a file location to create and save the PDF and I would like to avoid that.

Is there a way to skip that part?
Do you refer to DoCmd.PrintOut? How do you use that? What is the destination printer for that?

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
whitechair
post Jul 1 2019, 03:58 PM
Post#6



Posts: 491
Joined: 26-June 08



I typically use the Microsoft print to PDF driver. If there is another option that doesn't require the file naming, let me know.

--------------------
Jeff Moseler
Access 2007
Go to the top of the page
 
Phil_cattivocara...
post Jul 2 2019, 03:31 AM
Post#7



Posts: 318
Joined: 2-April 18



I have not found anything about Microsoft print to PDF that suppress file name manual input.
You should be able to do everything with PDFCreator but, of course, this means you have to install another software, nothing native.
Probably you can do the same with other virtual PDF printer but I do not know all of them.

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    18th August 2019 - 11:22 AM