寻求可靠的插件或其他解决方案来创建A97和A的RTF文件。 A2.0 ??? [英] Seeking reliable Add-In or other solution to create RTF files from A97 & A2.0???
问题描述
任何人都尝试过可靠的东西。需要实现
sol''n才能通过写字板可靠地创建RTF的Access报告可读
。
" MLH" < CR ** @ NorthState.net>在消息中写道
news：53 ******************************** @ 4ax.com ...任何人都尝试过可靠的东西。需要实现
sol''n才能可靠地创建由写字板提供的Access报告的RTF。
它不是我想要做很多事情，但是对于一些报告我有什么地方
甚至快照格式有时会丢弃数据我使用文件I / O命令循环
通过我的查询并将我自己的数据和RTF标签写入文件，然后将该
文件附加到电子邮件中。我必须在互联网上找到RTF规范的副本，并且还需要在写字板中制作简单的RTF文件，然后用
检查NotePad中的标签。
每份报告都是一项承诺，但结果却是一份快速而完美的RTF
文件。比其他格式要小一点。我发现我甚至可以用这种方法包含嵌入的图像，这是另一个奖励。
听起来很有希望...你愿意分享吗？你工作的一些成果。似乎它将是一个相当大的项目。
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxx
2003年9月17日星期三12:50:32 -0500，Rick Brandt < RB ***** @ Hunter.Com>
写道：
" MLH" < CR ** @ NorthState.net>在消息中写道
新闻：53 ******************************** @ 4ax.com .. < blockquote class =post_quotes>任何人都尝试过可靠的东西。需要实现
sol''n才能可靠地创建由写字板提供的Access报告的RTF。
这不是我想要的东西要做很多事情，但是对于一些报告，我有甚至快照格式有时会丢弃数据我使用文件I / O命令来循环查询并编写我自己的数据和RTF标签到文件，然后将该
文件附加到电子邮件。我必须在互联网上找到RTF规范的副本，并且还在写字板中制作简单的RTF文档然后检查NotePad中的标签。
每份报告都是一项承诺，但结果却是一份快速而完美的RTF文件。比其他格式要小一点。我发现我甚至可以用这种方法包含嵌入的图像，这是另一个好处。
" MLH" < CR ** @ NorthState.net>在消息中写道
news：dd ******************************** @ 4ax.com ...听起来很有希望......你愿意分享你工作的一些成果吗？好像它将是一个相当大的项目。
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxx
它比耗时更耗时。从一个例程开始，只需将报告的所有数据写入标准文本文件即可。这仍将涉及添加行返回和制表符等的
，以获得看起来像
报表而不是表格的基本布局。完成后，您可以修改程序，在文件顶部添加
RTF标头标记。我看起来像这样...
{\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ margl720\margr720\margt720\margb720\psz1
{\ colortbl
\\\\\ green0 \ blue {/ / >
\ red255 \ green255 \ blue255;
\ red255 \ green0 \ blue05;
\\\\\ green255 \ blue05 ;
\\\green0 \ blue245;}
{\ ttonttbl
\f0 \fcharset0 \ fnil Arial;
\f1 \fcharset0 \ fnil Arial Narrow;}
以下是报告标题的示例...
{\\\\\\\\\\\\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ $ b如果您将上面的两个字符串粘贴到NotePad文件中，然后用写字板打开它
您将看到标题以及我如何指定字体，字体大小，字体颜色和
使该段居中。文件的构建从
那里开始。创建一个简单文本文件的原始例程只需要在适当的位置添加适当的RTF标记以生成布局
并且看起来很理想。
您只想一步一步，并在每次更改后进行验证。
最难的事情之一是确保每个开口支撑{有一个相应的
结束括号}并在适当的位置。否则你会得到不正确的输出（或者
根本没有输出）。显然，一些报告设计比其他报告设计更容易使用这个
方法。
Anyone tried something reliable. Need to implement
sol''n to reliably create RTF''s of Access reports readable
by WordPad.
"MLH" <CR**@NorthState.net> wrote in message
news:53********************************@4ax.com...Anyone tried something reliable. Need to implement
sol''n to reliably create RTF''s of Access reports readable
by WordPad.
It''s not something I would want to do a lot of, but for a few reports I had where
even Snapshot Format was sometimes dropping data I used the File I/O commands to loop
through my query and write my own data and RTF tags to a file and then attach that
file to an Email. I had to find a copy of the RTF spec on the internet and also
experimented quite a bit with making simple RTF documents in WordPad and then
examining the tags in NotePad.
Each report was a bit of an undertaking, but the result was a fast and perfect RTF
document. Quite a bit smaller than the other formats as well. I found I could even
include embeded images with this method which was another bonus.
Sounds promising... would you be willing to share some of the
fruits of your labors. It seems as though it''ll be quite a project.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxx
On Wed, 17 Sep 2003 12:50:32 -0500, "Rick Brandt" <RB*****@Hunter.Com>
wrote:
"MLH" <CR**@NorthState.net> wrote in message
news:53********************************@4ax.com.. .Anyone tried something reliable. Need to implement
sol''n to reliably create RTF''s of Access reports readable
by WordPad.
It''s not something I would want to do a lot of, but for a few reports I had where
even Snapshot Format was sometimes dropping data I used the File I/O commands to loop
through my query and write my own data and RTF tags to a file and then attach that
file to an Email. I had to find a copy of the RTF spec on the internet and also
experimented quite a bit with making simple RTF documents in WordPad and then
examining the tags in NotePad.
Each report was a bit of an undertaking, but the result was a fast and perfect RTF
document. Quite a bit smaller than the other formats as well. I found I could even
include embeded images with this method which was another bonus.
"MLH" <CR**@NorthState.net> wrote in message
news:dd********************************@4ax.com...Sounds promising... would you be willing to share some of the
fruits of your labors. It seems as though it''ll be quite a project.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxx
It''s more time-consuming than difficult. Start out with a routine that just writes
all of the data for your report to a standard text file. This will still involve
adding line returns and tab characters etc., to get a basic layout that looks like a
report rather than a table. Once you have that you modify the procedure to add an
RTF header tag at the top of the file. Mine looks like this...
{\rtf1\ansi
\paperh15840\paperw12240
\margl720\margr720\margt720\margb720\psz1
{\colortbl
\red0\green0\blue0;
\red255\green255\blue255;
\red255\green0\blue0;
\red0\green255\blue0;
\red0\green0\blue255;}
{\fonttbl
\f0\fcharset0\fnil Arial;
\f1\fcharset0\fnil Arial Narrow;}
Here is an example then of a Report Header...
{\pard\plain\qc\fs36\b\f0\cf0\cb1ENGINEERING DEVIATION {\par}}
If you paste the two strings above into a NotePad file and then open it with WordPad
you will see the header and how I have specified a font, font size, font color, and
made the paragraph centered. The building of the document just progresses from
there. Your original routine that created a simple text file just needs to have
appropriate RTF Tagging added in at the appropriate locations to produce the layout
and look desired.
You just want to take it a step at a time and verify after each change. One of the
hardest things is making sure that every opening brace "{" has a corresponding
closing brace "}" and at the proper location. Otherwise you get incorrect output (or
no output at all). Obviously some report designs would lend themselves to this
method easier than others.
这篇关于寻求可靠的插件或其他解决方案来创建A97和A的RTF文件。 A2.0 ???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
