自动创建记录 [英] Automatic creation of records
问题描述
我似乎已经解决了弹出提醒的问题,但是点击勾选框后仍然需要一些自动创建记录的帮助。
我的表格如下
代码钥匙
房产地址
检查日期日期
检查完成是/否勾选框
通过查询进行检查
评论备忘录
检查是否完成了四分之一
一旦检查完成,我需要一条新记录添加了当前记录中的所有详细信息,但更改为将来3个月的日期。
认为需要使用VB执行此操作,但对VB知之甚少。我将如何处理它以及代码是什么。
非常感谢任何帮助。
Rafik
I seem to have solved the problem of pop up reminder but still need some help with automatically creating records once a tick box is clicked.
My form is as follows
CODE Key
PROPERTY Address
INSPECTION DATE Date
INSPECTION DONE Yes/No tick box
INSPECTION BY Lookup
COMMENTS Memo
Inspections are done quarterley
Once an inspection is done i need a new record to be added on with all the details as in the current record but the date to change to 3 months into the future.
Think need to do this using VB but have very little knowledge of VB. How would i go about it and what is the code.
Any help will be very much appreciated.
Rafik
推荐答案
当你想要添加新记录时运行这样的代码:
Run some code like this when you want add the new record:
如果你想要添加三个月你需要改变
If you want to add three months you need to change
@DonRayner
或:
@DonRayner
Or :
这篇关于自动创建记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!