ReportToPDF problem

  • Thread starter Thread starter Miha Abrahamsberg
  • Start date Start date
M

Miha Abrahamsberg

Hi!

I just wanted to check, if it's possible to open (print to pdf) filtered
report

(e.g. DoCmd.OpenReport "rptRacun", acViewPreview, , "[tblNakup.NakupID]=" &
strID)

with the ReportToPDF feature (by Stephen Leban)??

And how?


Thank you in advance!
 
Miha,

Have you donwloaded ReportToPDF by Stephen yet? Below is what you would
need behind a button but you realy need to download and read how to set it
up first. Real easy but you do want to do those steps first. Below is what
I use when filtering, same as always it's a seperate Call that actually does
the 'conversion'.

' Call our convert function
DoCmd.OpenReport "rptBoL", acViewPreview, ,
"[bolBillOfLadingID]=" & Me![cboBillOfLadingID]
DoCmd.Minimize
Call ConvertReportToPDF("rptBoL", , "c:\" & Me.cboBillOfLadingID
& ".pdf", False)
DoCmd.Close acReport, "rptBoL"


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
this works great !

Thank you


Gina Whipp said:
Miha,

Have you donwloaded ReportToPDF by Stephen yet? Below is what you would
need behind a button but you realy need to download and read how to set it
up first. Real easy but you do want to do those steps first. Below is
what I use when filtering, same as always it's a seperate Call that
actually does the 'conversion'.

' Call our convert function
DoCmd.OpenReport "rptBoL", acViewPreview, ,
"[bolBillOfLadingID]=" & Me![cboBillOfLadingID]
DoCmd.Minimize
Call ConvertReportToPDF("rptBoL", , "c:\" &
Me.cboBillOfLadingID & ".pdf", False)
DoCmd.Close acReport, "rptBoL"


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Miha Abrahamsberg said:
Hi!

I just wanted to check, if it's possible to open (print to pdf) filtered
report

(e.g. DoCmd.OpenReport "rptRacun", acViewPreview, , "[tblNakup.NakupID]="
& strID)

with the ReportToPDF feature (by Stephen Leban)??

And how?


Thank you in advance!
Click to expand...
Click to expand...
 
Glad to help...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Miha Abrahamsberg said:
this works great !

Thank you


Gina Whipp said:
Miha,

Have you donwloaded ReportToPDF by Stephen yet? Below is what you would
need behind a button but you realy need to download and read how to set
it up first. Real easy but you do want to do those steps first. Below
is what I use when filtering, same as always it's a seperate Call that
actually does the 'conversion'.

' Call our convert function
DoCmd.OpenReport "rptBoL", acViewPreview, ,
"[bolBillOfLadingID]=" & Me![cboBillOfLadingID]
DoCmd.Minimize
Call ConvertReportToPDF("rptBoL", , "c:\" &
Me.cboBillOfLadingID & ".pdf", False)
DoCmd.Close acReport, "rptBoL"


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

Miha Abrahamsberg said:
Hi!

I just wanted to check, if it's possible to open (print to pdf) filtered
report

(e.g. DoCmd.OpenReport "rptRacun", acViewPreview, ,
"[tblNakup.NakupID]=" & strID)

with the ReportToPDF feature (by Stephen Leban)??

And how?


Thank you in advance!
Click to expand...
Click to expand...
Click to expand...
 
Hi!

One more question:

- how could I "combine" two different reports (let's call them 'Report1'
and 'Report2') into a single PDF file ??

Thank you,

Miha


Gina Whipp said:
Miha,

Have you donwloaded ReportToPDF by Stephen yet? Below is what you would
need behind a button but you realy need to download and read how to set it
up first. Real easy but you do want to do those steps first. Below is
what I use when filtering, same as always it's a seperate Call that
actually does the 'conversion'.

' Call our convert function
DoCmd.OpenReport "rptBoL", acViewPreview, ,
"[bolBillOfLadingID]=" & Me![cboBillOfLadingID]
DoCmd.Minimize
Call ConvertReportToPDF("rptBoL", , "c:\" &
Me.cboBillOfLadingID & ".pdf", False)
DoCmd.Close acReport, "rptBoL"


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Miha Abrahamsberg said:
Hi!

I just wanted to check, if it's possible to open (print to pdf) filtered
report

(e.g. DoCmd.OpenReport "rptRacun", acViewPreview, , "[tblNakup.NakupID]="
& strID)

with the ReportToPDF feature (by Stephen Leban)??

And how?


Thank you in advance!
Click to expand...
Click to expand...
 
I believe the only way is to create a single report that combines them by
using them as subreports.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Miha Abrahamsberg said:
Hi!

One more question:

- how could I "combine" two different reports (let's call them 'Report1'
and 'Report2') into a single PDF file ??

Thank you,

Miha


Gina Whipp said:
Miha,

Have you donwloaded ReportToPDF by Stephen yet? Below is what you would
need behind a button but you realy need to download and read how to set
it up first. Real easy but you do want to do those steps first. Below
is what I use when filtering, same as always it's a seperate Call that
actually does the 'conversion'.

' Call our convert function
DoCmd.OpenReport "rptBoL", acViewPreview, ,
"[bolBillOfLadingID]=" & Me![cboBillOfLadingID]
DoCmd.Minimize
Call ConvertReportToPDF("rptBoL", , "c:\" &
Me.cboBillOfLadingID & ".pdf", False)
DoCmd.Close acReport, "rptBoL"


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

Miha Abrahamsberg said:
Hi!

I just wanted to check, if it's possible to open (print to pdf) filtered
report

(e.g. DoCmd.OpenReport "rptRacun", acViewPreview, ,
"[tblNakup.NakupID]=" & strID)

with the ReportToPDF feature (by Stephen Leban)??

And how?


Thank you in advance!
Click to expand...
Click to expand...
Click to expand...
 
Miha Abrahamsberg said:
- how could I "combine" two different reports (let's call them 'Report1'
and 'Report2') into a single PDF file ??
Click to expand...

Lebans solution has some code that allows you to combine PDF files
into one file.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Aha, it's "MergePDFDocuments". I didn't notice it before.

It works OK.

Thanks!

Miha
 
Back
Top