报告&电子邮件 [英] Reports & Email

问题描述

我一直在四处寻找，但我得到了一些信息但不是我真正需要的信息。


我有一个包含多个值的数据库，一个是日期。从这个日期过去四天后，我收到一条警告信息。有没有办法显示哪些表单目前有此警告并显示在某处，如报告或其他形式。


如果有可能，那么我可以通过我的smtp服务器通过电子邮件发送它吗？


非常感谢，

Dollarstar

I''ve been looking around and I got some info but not to what I really need.

I have a Database with several values, one being a date. When four days have passed from this date I get a warning message. Is there a way to to display which forms have this warning at present and display it somewhere, like in a report or another form.

Also if that is possible is there away I can get that to be emailed via my smtp server?

Many thanks,

Dollarstar

推荐答案

没有更多信息我不能肯定但我认为你需要一个查询。


将相关表单添加到查询中，包括主键（或您想要的任何字段）和日期。在您需要的日期条件下< Date（） - 4


只需将其添加到报告中（如果您愿意/需要，请使用向导）


至于电子邮件，我在这里这样做，它会拍摄报告的快照，将其保存为PDF然后将其附加到电子邮件中。

如果你愿意，我可以发布代码吗？

Well without more info I can''t say for sure but I think you need a query.

Add the relevant form to a query, including the primary key (or whatever fields you want) and the date. In the Conditions under the date you''ll need "<Date()-4"

The just add it to a report (use the wizard if you like/need)

As for the emailing, I do that here, it takes a snapshot of the report, saves it as a PDF then attaches it to an email.
I can post the code if you like?

我收到了一个查询。我需要发送详细信息。我只是这一刻做了一个报告，它的确有效！


哦，是的，关于代码，我不喜欢编码方面。


很抱歉让事情进一步复杂化，但有没有办法让它每周自动通过电子邮件将报告发送给某人？

I got a query. With the details I need sending. I''ve just this minute made a report, and it works!

Oh and yes please about the code, I''m not to great with the coding side.

Sorry to complicate things further, but is there a way to get it to automatically email the report to someone weekly?

这里需要三部分代码。一个是有点大（我道歉..）...

我会尽力解释。


这第一件需要自己进入一个模块。一个简单的模块 - 新 - 复制&粘贴将在这里发挥作用。

There are three parts of code needed here. One is kinda large (I apologise..)...
I''ll try and explain as well as I can.

This first piece needs to go in a module all of its own. A simple Module - New - Copy & Paste will do the trick here.

展开 | 选择 | Wrap | 行号

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