如何通过后续日期字段设置警报弹出窗口？ [英] How to set an alert pop up window via a follow up date field?

问题描述

早上好！


我在表/查询中有一个跟进日期字段......


不是参数查询（我可以做那个，但那是'其他的东西）。这将基于具有后续日期的一个字段运行。因此，如果今天在后续日期字段中，那么当交换机（表格）打开时，将打开一条消息（最好是报告）。


谢谢！


亲切的问候，

Faith

Good morning!

I have a follow up date field in a table/query...

Not a parameter query (I can do a that but that''s for something else). This would run based on that one field with the follow up date in it. So if today is in the follow up date field then a message (preferably a report) would open up when the Switchboard (form) is opened.

Thank you!

Kind regards,
Faith

推荐答案

如果我理解你要做什么，那就添加表单的on open事件的一些代码应该可以解决问题。请考虑以下事项：

If I understand what you''re trying to do, then adding some code to the on open event of the form should do the trick. Consider the following:

展开 | 选择 | Wrap | 行号

这太好了，谢谢你们的哇哇！


这里有更多我意识到我忽略了在字节中查询...


有两个表 - 联系人和电话。呼叫和联系人与[RecId]相关（如果有任何帮助）。


呼叫表中有[FollowUp]日期。呼叫和联系人在查询qrySearch中加入。


感谢您的帮助！


亲切的问候，

Faith

That''s great, thank you gnawoncents!

Here''s more that I realize I neglected to place in my query on Bytes...

There are two tables - Contacts and Calls. Calls and Contacts are related by [RecId] (if that''s any help).

The calls table has the [FollowUp] date in it. Calls and Contacts are joined in a query "qrySearch".

Thank you for the assistance!

Kind regards,
Faith

信仰，


我很乐意提供帮助。我看到你提供了更多信息，它现在适合你，还是需要进一步帮助根据你的数据改进代码？让我们知道，我们很乐意提供帮助。

Faith,

I''m glad to help. I see you gave some more info, is it working for you now, or do you need further assistance refining the code based on your data? Let us know and we''ll be glad to help.

这篇关于如何通过后续日期字段设置警报弹出窗口？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！