MS Access日期触发仿真 [英] MS Access Date triggers emulation

问题描述

我对Access完全陌生(对SQL Server有一定的经验).

I am completely new to Access (have some experience with SQL server).

我不确定在MS Access 2010中是否可能: 如果table.dateField之一是今天或更早的-需要发送有关该记录的电子邮件.

I am not sure if its even possible in MS Access 2010: if for one of table.dateField is today or earlier - need to send email about that record.

广泛挖掘并没有带来任何结果，这似乎是不可行的，但希望对此发表集体意见. 谢谢

Extensive digging doesn't bring any results, seems its not feasible, but wanted group opinion on that. Thank you

推荐答案

如果您的意思是说需要对表执行查询，那么该查询将管理有关每个有问题的行的发送电子邮件的执行-那我不认为你会很幸运；

If you are meaning that you need to execute say a query on a table, and that query will manage the execution of sending an email in respect of each offending row - then I dont think you'll have much luck;

您可以从访问权限中打开一个电子邮件窗口，但这不会自行发送电子邮件.

You can open an email window from access, but this won't send an email by itself.

您的后端使用什么?如果它很灵活，并且您将SQL Server用于后端，则可以使用实际的触发器来调用存储过程来发送所需的电子邮件.

What are you using for your backend? If it's flexible, and you used SQL server for the backend then you could use an actual trigger which calls a stored procedure to send the email required.

除此之外，我能想到的就是

Aside from this, all I can think of to do, would be

• 创建一个查询，查找要向其发送电子邮件的行；
• 创建一个.net可执行文件，该文件接收一组信息作为参数&根据这些数据发送您需要的电子邮件，
• 在应用程序中的表单上，使用计时器事件定期执行逻辑以打开查询，就像使用adodb.recordset一样，并遍历记录集，并为查询返回的每一行调用.net可执行文件. /li>

• create a query which finds the rows for which an email is to be sent;
• create a .net executable which receives a set of information as parameters & sends the email you require on the basis of that data,
• on a form in your application, use a timer event to periodically execute the logic to open the query, using like an adodb.recordset and loop through the recordset and call the .net executable for each row returned by the query.

希望这会有所帮助

这篇关于MS Access日期触发仿真的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！