电子邮件评论字段 [英] Email comment field

问题描述

我使用MS Access 2013并正在构建一个数据库，我是志愿者，由退伍军人组成。

我希望创建的第一个字段允许用户向我发送关于该特定退伍军人的评论或问题。它需要在报告上有一个电子邮件地址和评论框。那么我如何在设计视图中发送它？

我想要添加的另一个功能是：我希望能够扫描并将ob告附加到此人的记录中找到他们。这在MS Access 2013中是否可行？

谢谢。

解决方案

设计关系数据库首先要构建一个合适的表结构。假设你已经这样做了，下一部分是设计你的表格。

我认为你需要一个通过电子邮件发送评论或问题的表格。它可以使用宏或VBA来完成。例如，您可以在表单上添加一个按钮，供用户提交评论，而宏或代码会在电子邮件中将其作为附件或邮件正文发送给
。

将ob告的扫描图像添加到数据库中也可以通过几种方式完成。您可以使用"附件"字段将扫描图像附加到退伍军人的记录中。如果您希望Access控制扫描仪，可能需要一些代码
，具体取决于您的扫描仪硬件和软件。

希望它有帮助...... 

I use MS Access 2013 and am building a database, where I volunteer, consisting of war veterans.

The first field I hope to create is one that will allow for the user to send a comment or question about that particular veteran to me. It would need to have an email address and comment box on the report. So how do I sent this up in the design view?

Another feature I want to add is this: I would like to be able to scan and attach the obituary to the person's record as I find them. Is this possible in MS Access 2013?

Thank you.

解决方案

Hi,

Designing a relational database starts with building a proper table structure. Assuming you have done so, the next part is designing your forms.

I think you'll need a form for sending a comment or question through email. It can be accomplished using either a macro or VBA. For example, you might add a button on the form for the user to submit the comment and the macro or code will send it out in an email either as an attachment or in the body of the message.

Adding a scanned image of an obituary to the database can also be accomplished a couple of ways. You might use an Attachment field to attach the scanned image to a veteran's record. If you want Access to control the scanner, it might take some code depending on your scanner hardware and software.

Hope it helps... 

这篇关于电子邮件评论字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！