90天弹出窗口 [英] 90 Day Popup

问题描述

您好我是构建Access数据库的新手。我正在为我的客户创建数据库。是否有人能够帮助我创建一个弹出提醒，它将在输入记录后90天出现？


谢谢

Hello I am pretty new to building Access databases. I am in the process of creating a database for a customer of mine. Would anyone be able to assist me in creating a popup reminder that will appear 90days after a record as has been entered?

Thank you

推荐答案

你对VBA或宏了解多少？你将不得不使用其中一个。


基本上你会计算90天前发生的所有记录，如果计数大于0，你打开表单。

How much do you know about VBA or macros? You''re going to have to use one or the other.

Basically you do a count of all records that occured 90 days prior and if the count is larger than 0, you open a form.

我对vba和宏并不熟悉。我知道它们是什么，它们做了什么以及如何完成某项任务。我确信有适当的信息或指导，我可以搞清楚。我用vba做过的事情就是创建一个自动为我的雇主安装打印机的脚本。

I am not really familiar with vba and macros. I know what they are and what they do and how some task are accomplished. Im sure with the proper information or guidance i could figure it out. Only thing I have ever done with vba is create a script to automatically install printers for my employer.

嗯，基本设置如下：


1）您有一个主菜单表单，在数据库打开时打开。这是通过工具>设置的。启动。


2）在表单的On Open事件中，运行一个DCount（帮助文件可以为您提供语法）。


3）如果DCount大于0，那么你将使用DoCmd.OpenForm（帮助文件也可以为你提供语法）。

Well, the basic set up is this:

1) You have a main menu form that opens when the database opens. This is set up through Tools > Startup.

2) In the On Open event of the form, runs a DCount (the help files can give you the syntax for that).

3) If the DCount is larger than 0, then you would use DoCmd.OpenForm (the help files can give you the syntax for this as well).

这篇关于90天弹出窗口的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！