Help with CutePDF

I think I've read every post here regarding Access reports to PDF, but I
can't solve my problem.

I have code that works fine to create a PDF file from a report using a
unique name that becomes the PDF filename. What I need is an automated
process that will create the PDF file and then open it for viewing. I can
create it. I can open it for viewing. But I can't automate or override the
CutePDF dialog box that wants me to press Enter to save the file. I have to
press Enter, and then click another button on my form that opens the
hyperlink. What I want is a single click that executes the job stream without
user intervention required.

What am I missing?

I believe that's a limitation in CutePDF.

You could try PDF995 http://www.pdf995.com or you can take a look at what
Stephen Lebans has at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in message
...
I think I've read every post here regarding Access reports to PDF, but I
can't solve my problem.

I have code that works fine to create a PDF file from a report using a
unique name that becomes the PDF filename. What I need is an automated
process that will create the PDF file and then open it for viewing. I can
create it. I can open it for viewing. But I can't automate or override the
CutePDF dialog box that wants me to press Enter to save the file. I have
to
press Enter, and then click another button on my form that opens the
hyperlink. What I want is a single click that executes the job stream
without
user intervention required.

What am I missing?

Thanks, Doug.

I'll give it a shot. This is new to me and I was happy I made it work. It
was actually very easy, and I hope the switch to pdf995 is easy too. The
price is right. )

Nancy

"Douglas J. Steele" wrote:

I believe that's a limitation in CutePDF.

You could try PDF995 http://www.pdf995.com or you can take a look at what
Stephen Lebans has at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in message
...
I think I've read every post here regarding Access reports to PDF, but I
can't solve my problem.

I have code that works fine to create a PDF file from a report using a
unique name that becomes the PDF filename. What I need is an automated
process that will create the PDF file and then open it for viewing. I can
create it. I can open it for viewing. But I can't automate or override the
CutePDF dialog box that wants me to press Enter to save the file. I have
to
press Enter, and then click another button on my form that opens the
hyperlink. What I want is a single click that executes the job stream
without
user intervention required.

What am I missing?

Stephen's solution is priced right as well... g

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in message
news
Thanks, Doug.

I'll give it a shot. This is new to me and I was happy I made it work. It
was actually very easy, and I hope the switch to pdf995 is easy too. The
price is right. )

Nancy

"Douglas J. Steele" wrote:

I believe that's a limitation in CutePDF.

You could try PDF995 http://www.pdf995.com or you can take a look at what
Stephen Lebans has at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in message
...
I think I've read every post here regarding Access reports to PDF, but I
can't solve my problem.

I have code that works fine to create a PDF file from a report using a
unique name that becomes the PDF filename. What I need is an automated
process that will create the PDF file and then open it for viewing. I
can
create it. I can open it for viewing. But I can't automate or override
the
CutePDF dialog box that wants me to press Enter to save the file. I
have
to
press Enter, and then click another button on my form that opens the
hyperlink. What I want is a single click that executes the job stream
without
user intervention required.

What am I missing?

Yes. I looked at it and felt it was over my head. I got lost in the
ReadMeFirst file.

"Douglas J. Steele" wrote:

Stephen's solution is priced right as well... g

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in message
news
Thanks, Doug.

I'll give it a shot. This is new to me and I was happy I made it work. It
was actually very easy, and I hope the switch to pdf995 is easy too. The
price is right. )

Nancy

"Douglas J. Steele" wrote:

I believe that's a limitation in CutePDF.

You could try PDF995 http://www.pdf995.com or you can take a look at what
Stephen Lebans has at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in message
...
I think I've read every post here regarding Access reports to PDF, but I
can't solve my problem.

I have code that works fine to create a PDF file from a report using a
unique name that becomes the PDF filename. What I need is an automated
process that will create the PDF file and then open it for viewing. I
can
create it. I can open it for viewing. But I can't automate or override
the
CutePDF dialog box that wants me to press Enter to save the file. I
have
to
press Enter, and then click another button on my form that opens the
hyperlink. What I want is a single click that executes the job stream
without
user intervention required.

What am I missing?

I actually bought PDF995 for $9.95US and I'm very happy with it. It was easy
to setup to print from inside Access with a lot of control over the outcome.

Gitche Gumee wrote:
Thanks, Doug.

I'll give it a shot. This is new to me and I was happy I made it
work. It was actually very easy, and I hope the switch to pdf995 is
easy too. The price is right. )

Nancy

"Douglas J. Steele" wrote:

I believe that's a limitation in CutePDF.

You could try PDF995 http://www.pdf995.com or you can take a look at
what Stephen Lebans has at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in
message ...
I think I've read every post here regarding Access reports to PDF,
but I can't solve my problem.

I have code that works fine to create a PDF file from a report
using a unique name that becomes the PDF filename. What I need is
an automated process that will create the PDF file and then open it
for viewing. I can create it. I can open it for viewing. But I
can't automate or override the CutePDF dialog box that wants me to
press Enter to save the file. I have to
press Enter, and then click another button on my form that opens the
hyperlink. What I want is a single click that executes the job
stream without
user intervention required.

What am I missing?

--

Joe Cilinceon

Hi Joe.

I tried PDF995 today, and unless I pay the $9.95 I'll get the popup ads
which defeat the purpose of trying to do what CutePDF can't. It's not that I
can't afford it, but I'm at the point where I'll be reinventing the wheel for
my little enterprise which involves only a single user...my husband.

Anyway, I've automated it to three clicks, which I (he) can live with. 1)
generate the report, programmatically build the PDF filename, "print" to
CutePDF, and close the report. 2) Save the PDF. 3) Open the PDF for viewing
or printing or emailing. It's good enough for now.

"Joe Cilinceon" wrote:

I actually bought PDF995 for $9.95US and I'm very happy with it. It was easy
to setup to print from inside Access with a lot of control over the outcome.

Gitche Gumee wrote:
Thanks, Doug.

I'll give it a shot. This is new to me and I was happy I made it
work. It was actually very easy, and I hope the switch to pdf995 is
easy too. The price is right. )

Nancy

"Douglas J. Steele" wrote:

I believe that's a limitation in CutePDF.

You could try PDF995 http://www.pdf995.com or you can take a look at
what Stephen Lebans has at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in
message ...
I think I've read every post here regarding Access reports to PDF,
but I can't solve my problem.

I have code that works fine to create a PDF file from a report
using a unique name that becomes the PDF filename. What I need is
an automated process that will create the PDF file and then open it
for viewing. I can create it. I can open it for viewing. But I
can't automate or override the CutePDF dialog box that wants me to
press Enter to save the file. I have to
press Enter, and then click another button on my form that opens the
hyperlink. What I want is a single click that executes the job
stream without
user intervention required.

What am I missing?

--

Joe Cilinceon

Another you might want to check out is PrimoPDF. It is another free PDF
system though I have it I've not messed with it much. You can download it at
www.PrimoPDF.com It does have a popup that gives the option to print to
screen, printer, etc. It also has the option to launch or not lauch the
viewer after its finished printing.

Gitche Gumee wrote:
Hi Joe.

I tried PDF995 today, and unless I pay the $9.95 I'll get the popup
ads which defeat the purpose of trying to do what CutePDF can't. It's
not that I can't afford it, but I'm at the point where I'll be
reinventing the wheel for my little enterprise which involves only a
single user...my husband.

Anyway, I've automated it to three clicks, which I (he) can live
with. 1) generate the report, programmatically build the PDF
filename, "print" to CutePDF, and close the report. 2) Save the PDF.
3) Open the PDF for viewing or printing or emailing. It's good enough
for now.

"Joe Cilinceon" wrote:

I actually bought PDF995 for $9.95US and I'm very happy with it. It
was easy to setup to print from inside Access with a lot of control
over the outcome.

Gitche Gumee wrote:
Thanks, Doug.

I'll give it a shot. This is new to me and I was happy I made it
work. It was actually very easy, and I hope the switch to pdf995 is
easy too. The price is right. )

Nancy

"Douglas J. Steele" wrote:

I believe that's a limitation in CutePDF.

You could try PDF995 http://www.pdf995.com or you can take a look
at what Stephen Lebans has at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in
message ...
I think I've read every post here regarding Access reports to PDF,
but I can't solve my problem.

I have code that works fine to create a PDF file from a report
using a unique name that becomes the PDF filename. What I need is
an automated process that will create the PDF file and then open
it for viewing. I can create it. I can open it for viewing. But I
can't automate or override the CutePDF dialog box that wants me to
press Enter to save the file. I have to
press Enter, and then click another button on my form that opens
the hyperlink. What I want is a single click that executes the job
stream without
user intervention required.

What am I missing?

--

Joe Cilinceon

--

Joe Cilinceon

Thank you. I'll take a look.

"Joe Cilinceon" wrote:

Another you might want to check out is PrimoPDF. It is another free PDF
system though I have it I've not messed with it much. You can download it at
www.PrimoPDF.com It does have a popup that gives the option to print to
screen, printer, etc. It also has the option to launch or not lauch the
viewer after its finished printing.

Gitche Gumee wrote:
Hi Joe.

I tried PDF995 today, and unless I pay the $9.95 I'll get the popup
ads which defeat the purpose of trying to do what CutePDF can't. It's
not that I can't afford it, but I'm at the point where I'll be
reinventing the wheel for my little enterprise which involves only a
single user...my husband.

Anyway, I've automated it to three clicks, which I (he) can live
with. 1) generate the report, programmatically build the PDF
filename, "print" to CutePDF, and close the report. 2) Save the PDF.
3) Open the PDF for viewing or printing or emailing. It's good enough
for now.

"Joe Cilinceon" wrote:

I actually bought PDF995 for $9.95US and I'm very happy with it. It
was easy to setup to print from inside Access with a lot of control
over the outcome.

Gitche Gumee wrote:
Thanks, Doug.

I'll give it a shot. This is new to me and I was happy I made it
work. It was actually very easy, and I hope the switch to pdf995 is
easy too. The price is right. )

Nancy

"Douglas J. Steele" wrote:

I believe that's a limitation in CutePDF.

You could try PDF995 http://www.pdf995.com or you can take a look
at what Stephen Lebans has at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Gitche Gumee" wrote in
message ...
I think I've read every post here regarding Access reports to PDF,
but I can't solve my problem.

I have code that works fine to create a PDF file from a report
using a unique name that becomes the PDF filename. What I need is
an automated process that will create the PDF file and then open
it for viewing. I can create it. I can open it for viewing. But I
can't automate or override the CutePDF dialog box that wants me to
press Enter to save the file. I have to
press Enter, and then click another button on my form that opens
the hyperlink. What I want is a single click that executes the job
stream without
user intervention required.

What am I missing?

--

Joe Cilinceon

--

Joe Cilinceon