Saving as PDF in 2007

[Dustin R]

I am needing to output reports from access to PDF. This seems to be a
simple task with the PDF/XPS add-in and it works fine maually. BUT
when I use it in code with the OutputTo it takes 15 minuites to save a
report that when done manually takes < 1 min. I have found that I can
get it to achieve the same time frame if I open the report first then
call the code but this only works when I manually open the report.
When I try doing OpenReport in preview mode then run this code from a
form it still takes forever and almost locks up. Is there any way to
get the quick effect and still have it all done through the form?

 

[UpRider]

Dustin, don't know why it takes so long - below code works VERY fast form
me. The report is already open in preview...

DoCmd.OutputTo ObjectType:=acOutputReport, _
ObjectName:=argRPT, _ 'the report we are working with
outputformat:=acFormatPDF, _
outputfile:=strReportFile, _ 'path (drive, folder & name)
to put pdf in.
autostart:=True

UpRider

 

[Dustin R]

that code is doing the same thing for me

I am thinking that this has more to do with my QBF that I added since
that is when the report started taking longer to open as well...

 

[Dustin R]

ok figured it out.. it was from my OR clauses in the join (made it
easier to achieve my goal but obviously causes a problem when it takes
a 5 second query and makes it a 5 minuite one.)