系统地OutPut访问报告到PDF [英] Systemically OutPut Access Report To PDF

问题描述

全部，


我已经厌倦地浏览新闻组以寻找一种方式

以系统方式将Access 97报告输出到pdf文件Adobe Acrobat的完整

版本。我希望用户能够单击一个按钮，并且

将Access报告保存为pdf，保存在我指定的目录中。

程序员。


我看过John Baker的一篇帖子，宣传了一个网站，其中有一个mde

，可以在任何数据库中引用，但30天后需要一个

注册费。有人必须做过这种类型的自动化。任何

帮助将不胜感激。


问候，


Mark C.

All,

I have exhaustingly been looking through the newsgroups in search of a way
to systemically output an Access 97 report to a pdf file using the full
version of Adobe Acrobat. I want the user to be able to click a button and
have the Access report saved as a pdf in a directory specified by me the
programmer.

I have seen a posting by John Baker promoting a web-sight that has an mde
that one can reference in any database but after 30 days requires a
registration fee. Someone must have done some automation of this type. Any
help would be much appreciated.

Regards,

Mark C.

推荐答案

" Mark C" <他****** @ yahoo.com>写道：

"Mark C" <he******@yahoo.com> wrote:

我已经筋疲力尽地通过新闻组寻找一种方式
使用完整的
版本系统地将Access 97报告输出到pdf文件Adobe Acrobat。我希望用户能够单击一个按钮，并将Access报告保存为pdf，保存在我指定的目录中。
程序员。

I have exhaustingly been looking through the newsgroups in search of a way
to systemically output an Access 97 report to a pdf file using the full
version of Adobe Acrobat. I want the user to be able to click a button and
have the Access report saved as a pdf in a directory specified by me the
programmer.

从Microsoft Access中创建PDF文件
http： //www.granite.ab.ca/access/pdffiles.htm


Tony

-

Tony Toews，Microsoft Access MVP

请仅在新闻组中回复，以便其他人可以阅读整个消息主题。

Microsoft Access Links ，提示，提示&会计系统
http://www.granite.ab.ca /accsmstr.htm

Access可以通过报告做三件事：

它可以打印/预览，它可以'' OutputTo''，它可以将设计导出为文本。


打印/预览意味着在Windows画布上绘制报表，并将

图元文件发送到打印机驱动程序或屏幕驱动程序。


OutputTo表示（意味着）向导循环遍历报表并以不同的格式导出

详细信息。 br $>
SaveAsText只导出设计信息，而不是数据。


由于Access中没有内置PDF导出向导，因此唯一的方法是

从报告中获取PDF格式

（a）编写自己的代码来制作PDF / Postscript文档。

（b）使用打印机驱动程序写入PDF / Postscript文档。

（c）使用PDF cr eator将接受文本/富文本/ HTML / Excel / Word

文件


（a）是闻所未闻的，（c）真的很狡猾因为OutputTo向导

臭名昭着地错误估算了文本的大小并截断了字段。


只剩下（b）。 Acrobat的完整版本附带Distiller。

Distiller是自动化程度较高的程序之一，因为Acrobat

是跨平台的。


（大卫）

" Mark C" <他****** @ yahoo.com>在消息中写道

news：zN ******************** @ comcast.com ...

Access can do three things with a report:
It can print/preview, it can ''OutputTo'', it can export the design as text.

Print/Preview means drawing the report on a windows canvas, and sending the
metafile either to a printer driver or to a screen driver.

OutputTo means (meant) a wizard loops through the report and exports the
details in a different format.

SaveAsText only export the design information, not data.

Since there is no PDF export wizard built into Access, the only ways you can
get PDF from a report are
(a) Write your own code to make PDF/Postscript documents.
(b) Use a printer driver that writes to a PDF/Postscript document.
(c) Use a PDF creator that will accept a Text/Rich Text/HTML/Excel/Word
document

(a) is unheard of, and (c) is really dodgy because the OutputTo wizard
notoriously miscalculates the size of text and truncates fields.

That leaves only (b). The full version of Acrobat comes with Distiller.
Distiller is one of the more difficult programs to automate, because Acrobat
is cross platform.

(david)
"Mark C" <he******@yahoo.com> wrote in message
news:zN********************@comcast.com...

全部，

我已经厌倦地浏览新闻组，寻找一种方法，使用完整的Adobe Acrobat版本将Access 97报告系统地输出到pdf文件。我希望用户能够点击一个按钮，并将Access报告保存为pdf，保存在我指定的程序员目录中。

我看过一个帖子作者：约翰·贝克（John Baker）宣传一个网站，其中包含一个可以在任何数据库中引用的网站，但30天后需要一个
注册费。有人必须做过这种类型的自动化。任何
帮助将不胜感激。

问候，

Mark C.

All,

I have exhaustingly been looking through the newsgroups in search of a way
to systemically output an Access 97 report to a pdf file using the full
version of Adobe Acrobat. I want the user to be able to click a button and
have the Access report saved as a pdf in a directory specified by me the
programmer.

I have seen a posting by John Baker promoting a web-sight that has an mde
that one can reference in any database but after 30 days requires a
registration fee. Someone must have done some automation of this type. Any
help would be much appreciated.

Regards,

Mark C.

2004年7月17日星期六21:11:41 -0700，Mark C <他****** @ yahoo.com>写道：


在控制面板打印机部分添加新打印机。从

Acrobat获取驱动程序。将其命名为PDF打印机。


创建一个运行宏的按钮，以打印模式打开报告。

在我的情况下，我第一次运行宏打开一个窗口并给我一个选择

哪个打印机要使用。选择PDF打印机。单击*打印*。当打印完成后，Acrobat将打开，为文件命名并保存或使用

默认名称，即报告的名称。关闭Acrobat。在Access中仍然打开报告

，单击文件/保存。下次单击宏

按钮时，您唯一需要做的就是给PDF文件命名。


Chuck

....

On Sat, 17 Jul 2004 21:11:41 -0700, "Mark C" <he******@yahoo.com> wrote:

Add a new printer in the control panel printer section. Get the driver from
Acrobat. Name it PDF printer.

Make a button that runs a macro that opens the report in print mode.
In my case, the first time I ran the macro a window opened and gave me a choice
of which printer to use. Chose PDF printer. Click *print*. When the printing
is done, Acrobat will open, give the file a name and save it or use the
default name which is the name of the report. Close Acrobat. With the report
still open in Access, click file/save. The next time you click on the macro
button, the only thing you will have to do is give the PDF file a name.

Chuck
....

全部，

我一直在寻找新闻组寻找方式/>使用完整的Adobe Acrobat版本将Access 97报告系统地输出到pdf文件。我希望用户能够点击一个按钮，并将Access报告保存为pdf，保存在我指定的程序员目录中。

我看过一个帖子作者：约翰·贝克（John Baker）宣传一个网站，其中包含一个可以在任何数据库中引用的网站，但30天后需要一个
注册费。有人必须做过这种类型的自动化。任何
帮助将不胜感激。

问候，

Mark C。

All,

I have exhaustingly been looking through the newsgroups in search of a way
to systemically output an Access 97 report to a pdf file using the full
version of Adobe Acrobat. I want the user to be able to click a button and
have the Access report saved as a pdf in a directory specified by me the
programmer.

I have seen a posting by John Baker promoting a web-sight that has an mde
that one can reference in any database but after 30 days requires a
registration fee. Someone must have done some automation of this type. Any
help would be much appreciated.

Regards,

Mark C.

这篇关于系统地OutPut访问报告到PDF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！