让用户输入图片/绘图到每条记录的最佳方法是什么？ [英] Best way to let users input picture/drawing to each record?
问题描述
我是一个相当新的访问（使用2002）并且正在为工作设置数据库。
以及用户还需要制作流程图的每条记录
（之前，这些报告是用单词组成的，他们使用
自动形状来创建此图表）。我想知道什么是最好的方式
将它合并到数据库中。我已经读过关于如何将它们保存为数据库膨胀的大小，这是不可接受的，但是它需要很容易做到（不要单独生成单词文件）并让他们在路径中输入
类型...）是否有一种简单的方法可以让用户创建
流程图并链接（或嵌入一个小文件）到记录？
提前致谢！
（我不太了解vb，但我愿意尝试，如果我需要的话）
I''m fairly new to access (using 2002) and am setting up a DB for work.
along with each record the user also needs to make a flow diagram
(previously, these reports were composed in word and they used the
autoshapes to create this diagram). I was wondering what the best way
to incorporate this into the DB. I have read about how saving them as
pictures in the DB bloats the size, which is unacceptable, but it
needs to be easy to do (not making separate word file and have them
type in the path...) Is there an easy way to allow users to create
flow diagrams and link (or embed a small file) to the record?
Thanks in advance!
(I dont know much vb, but im willing to try it if i need to)
推荐答案
ch******@umbc.edu （格雷格）在留言新闻中写道：< f2 ************************** @ posting.google。 com> ...
ch******@umbc.edu (Greg) wrote in message news:<f2**************************@posting.google. com>...
我是一个相当新的访问（使用2002）并且正在为工作设置数据库。
以及用户还需要制作流程的每条记录图表
（之前，这些报告是用文字组成的，他们使用
自动形状来创建此图表）。我想知道将这个结合到数据库中的最佳方法是什么。我已经读过关于如何将它们保存为数据库中的图片膨胀的大小，这是不可接受的，但它需要很容易做（不要单独的文件文件，并让它们
类型在路径中......）是否有一种简单的方法可以让用户创建流程图并链接（或嵌入一个小文件）到记录中？
提前致谢！
（我不太了解vb，但我愿意尝试，如果我需要的话）
I''m fairly new to access (using 2002) and am setting up a DB for work.
along with each record the user also needs to make a flow diagram
(previously, these reports were composed in word and they used the
autoshapes to create this diagram). I was wondering what the best way
to incorporate this into the DB. I have read about how saving them as
pictures in the DB bloats the size, which is unacceptable, but it
needs to be easy to do (not making separate word file and have them
type in the path...) Is there an easy way to allow users to create
flow diagrams and link (or embed a small file) to the record?
Thanks in advance!
(I dont know much vb, but im willing to try it if i need to)
如果你使用OpenFile API提示用户怎么办？找到
文件然后只需将路径写入表中？然后你可以
将它显示为你表单中的超链接...
http://www.mvps.org/access/api/api0001.htm
"格雷格"写了
"Greg" wrote
以及用户还需要制作流程图的每条记录
（之前，这些报告都是用Word编写的，并且用过它们
自动形状来创建此图表）。
在Access中创建流程图没有内置的方法。但是，
Access可以启动另一个用于创建流程的应用程序
图表并存储图像。我会建议使用适当版本的Visio
，或者，也许是一种播放效果好的更通用的成像软件工具。与
访问。
我想知道将这个纳入数据库的最佳方式是什么。
along with each record the user also
needs to make a flow diagram
(previously, these reports were composed
in word and they used the
autoshapes to create this diagram).
There''s no built-in way to use to create flow diagrams in Access. But,
Access can start another application that you use to create the flow
diagrams and store the image. I''d suggest the appropriate version of Visio
or, perhaps, a more general imaging software tool that "plays well" with
Access.
I was wondering what the best way
to incorporate this into the DB.
http://accdevel.tripod.com 上的示例影像数据库说明了三个
处理Access中的图像的方法，下载包括一篇讨论选择方法的注意事项的文章。两个
方法不使用OLE对象，因此，避免数据库膨胀，以及与OLE对象中的图像相关的一些其他问题。
。
在这些示例中，为用户显示Windows公共对话框，以便用户输入图像文件，因此用户无需键入路径并且
文件名。
如果你在报告中打印图像，为了避免内存泄漏，你还要看看MVP Stephen Lebans'' http://www.lebans.com/printfailures.htm 。
PrintFailure.zip是一个Access97 MDB，其中包含一个报告，该报告在假脱机到打印机驱动程序之前的
访问格式化过程中失败。
此MDB还包含显示如何在打印之前将Image
控件的内容转换为位图文件的代码。这有助于缓解Out of
Memory。打印图像密集型报告时可能弹出的错误。
Larry Linson
Microsoft Access MVP
The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.
In these samples, the Windows Common Dialog is displayed for the user to
_select_ an image file, so the user does not have to type in the path and
filename.
If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans'' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.
Larry Linson
Microsoft Access MVP
谢谢你们的帮助！
a还有更多的问题出现了。我已经确定膨胀是不可接受的，因此OLE图片嵌入不再是一个选项。
但是，BLOB可能会工作。我尝试复制代码（和表单）为
导入图像作为BLOB，但我每次都会收到错误
运行：编译错误，sub或功能未定义并突出显示
字ahtAddFilterItem在代码中。我在示例db
代码中环顾四周，但似乎无法看到我遗漏的内容。这可能是一个像c ++中的#include一样的东西吗？
i已经改变了图像的存储方式，只需使用
用于扩展的数据和文本字段的OLE（实际上从示例中复制了
字段），因为每条记录只有1个。
对VB来说还是新的，所以在这方面的任何帮助都非常感谢！
再次感谢！
-Greg
" Larry Linson" <博***** @ localhost.not>在消息新闻中写道：< 3q ******************* @ nwrddc03.gnilink.net>。 ..
Thank you both for your help!
a few more questions have come up. I have decided the bloat is
unacceptable, so the OLE picture embeding is not an option anymore.
however, the BLOB might work. I tried copying the code (and form) for
importing an image as a BLOB, but i am getting errors every time it
runs: "compile error, sub or function not defined" and highlights the
word "ahtAddFilterItem" in the code. i looked around in the sample db
code but couldn''t seem to see what i was missing. Might it be
something like an #include in c++?
i have changed a little bit in how the image is stored, just using the
OLE for the data and text field for extension (actually copied the
fields from the sample), since there will only be 1 per record.
Very new to VB still, so any help in that area is greatly appreciated!
Thanks again!
-Greg
"Larry Linson" <bo*****@localhost.not> wrote in message news:<3q*******************@nwrddc03.gnilink.net>. ..
" Greg"写了
"Greg" wrote
>随着每个记录用户也
>需要制作流程图
> （之前，这些报告是由单词组成的
>并且他们使用
>自动形状来创建此图表。）
> along with each record the user also
> needs to make a flow diagram
> (previously, these reports were composed
> in word and they used the
> autoshapes to create this diagram).
没有内置 - 用于在Access中创建流程图的方式。但是，
Access可以启动另一个用于创建流程图和存储图像的应用程序。我会建议使用适当版本的Visio
，或者，也许是一个播放得很好的更通用的成像软件工具。
访问。
There''s no built-in way to use to create flow diagrams in Access. But,
Access can start another application that you use to create the flow
diagrams and store the image. I''d suggest the appropriate version of Visio
or, perhaps, a more general imaging software tool that "plays well" with
Access.
>我想知道什么是最好的方式
>将此结合到数据库中。
> I was wondering what the best way
> to incorporate this into the DB.
上的示例成像数据库http://accdevel.tripod.com 说明了在Access中处理图像的三种方法，下载内容包括一篇讨论选择方法的注意事项的文章。其中两种方法不使用OLE对象，因此避免了数据库膨胀，以及与OLE对象中的图像相关的一些其他问题。
在这些示例中，为用户显示Windows通用对话框以选择图像文件，因此用户无需键入路径和文件名。
如果要打印报告中的图像，为了避免内存泄漏，你还应该看到MVP Stephen Lebans''a rel =nofollowhref =http://www.lebans.com/printfailures.htmtarget =_ blank > http://www.lebans.com/printfailures.htm 。
PrintFailure.zip是一个Access97 MDB，其中包含一个报告，该报告在进行假脱机处理之前的访问格式化过程中失败打印机驱动程序。
此MDB还包含显示如何在打印之前将Image
控件的内容转换为位图文件的代码。这有助于减轻Out of
Memory。打印图像密集型报告时可能弹出的错误。
Larry Linson
Microsoft Access MVP
The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.
In these samples, the Windows Common Dialog is displayed for the user to
_select_ an image file, so the user does not have to type in the path and
filename.
If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans'' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.
Larry Linson
Microsoft Access MVP
这篇关于让用户输入图片/绘图到每条记录的最佳方法是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
