Create Button to Print Report to PDF

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kaygeejo - 19 Mar 2008 02:28 GMT

I am using Access 2007 and I have created a report, and I would like to have
a command button that would
open a print dialog so that the user can choose to print the report to any
printer they should choose, including a PDF.

I was able to create a command button in a FORM, but could not do the same
in the REPORT. I am familiar with macros in programs such as Word, but they
are not the same in Access.

How can I accomplish this?

Thanks!
kaygeejo

Reply to this Message

Larry Linson - 19 Mar 2008 04:14 GMT

Display the Report in PrintPreview mode, and let the user control the
printer... you don't have to do it. All my users WANT to see the Report
before deciding to or not to Print it.

At least through Access 2003, interaction is not possible with Reports, so
you cannot install a working Command Button on the Report itself.

Larry Linson
Microsoft Office Access MVP

>I am using Access 2007 and I have created a report, and I would like to
>have
[quoted text clipped - 11 lines]
> Thanks!
> kaygeejo

Reply to this Message

Pampas58 - 20 Mar 2008 00:20 GMT

Here's a couple of sites that I found looking for something else that may be
of help in your quest:

http://www.lebans.com/reporttopdf.htm
http://www.groupacg.com/

Hope they give you some help.

Good Luck,

Pampas58

>I am using Access 2007 and I have created a report, and I would like to have
>a command button that would
[quoted text clipped - 9 lines]
>Thanks!
>kaygeejo

Reply to this Message