跟踪任务是否已关闭，然后允许用户打开新任务 [英] Tracking if the task is closed and then allow user to open new task
问题描述
大家好，
非常感谢你帮助我解决这么多问题。
----- -
我的应用程序差不多完成，只有一件事我觉得很有挑战性（或者可能无法弄清楚它的正确逻辑）。
在提出问题之前，我想概述一下。
有两种形式：
1）Form1
2）任务
On" Form1"他们是一个打开表格任务的按钮。
在表格任务上登录用户可以保存开始和结束时间。
虽然并不总是强制保存结束时间。
所有这些细节都存储在表：TasksD
字段如下：
ID（Autonu）
EmpId（数字）
开始（文字）
结束（文字）
持续时间（文字）
现在，当用户保存结束时间时，开始和结束时间之间的差异已在持续时间字段中计算和捕获。
我真正想要实现的是：
直到用户已保存上一个任务的结束时间，他/她无法打开表格任务。
我尝试实施一些逻辑，但他们没有满足要求。 br />
接受所有建议。 ：）
Hi All,
Thank you so much for helping me till now in solving so many issues.
-------
My application is almost done, just one thing which I find challenging (or may be am not able to figure out the proper logic for it).
Before heading to the question , I would like to give the overview.
There are 2 forms:
1) Form1
2) Tasks
On "Form1" their is a button which open form "Tasks".
On form "Tasks" the logged in user can save the starting and ending time.
While it is not always mandatory to save the ending time.
All these details are stored in Table : "TasksD"
Fields are like :
ID(Autonu)
EmpId(Numeric)
start(text)
end(text)
Duration(Text)
Now, when the user saves the end time, the difference between the start and end time is been calculated and captured in Duration field.
What I really want to achieve is:
Until the user has saved the end time of the previous task, he/she cant open the form "Tasks".
I tried implementing some logics but they are not serving the requirement.
All the suggestions are accepted. :)
推荐答案
如果他们无法打开任务表单，他们将如何输入结束时间？一种方法是计算他们拥有的没有End值的记录数。如果该数字大于0，则不要打开表格。
How would they enter the End time if they can''t open the Tasks form? One way would be to count how many records they have that don''t have an End value. If that number is greater than 0, then don''t open the form.
感谢Seth回复:)
回答你的问题。
如果用户只保存了开始时间，则可以保存结束时间。
我有一份报告，其中包含特定列（其工作方式类似于超链接），重定向到该特定任务并允许用户保存结束时间。
我真正想要的是绑定用户以节省结束时间首先，而不仅仅是开始新任务。
我尝试使用变量来检查表格中的持续时间。列，如果它是空的，否则不允许开始新的任务。
但它结果是翻牌。
你的建议听起来不错，请你再强调一下。
Thanks Seth for replying :)
Answer to your question.
If the user has saved only the start time , then the end time can be saved.
I have a report which have the particular column (which works like a hyperlink) which redirects to that particular task and allow the user to save the end time.
What I really want is bound the user to save the end time first and than only start new task.
I tried using a variable to check the table for the "duration" column, if it is Null than don''t allow otherwise allow to start new task.
But it turned out flop.
Your suggestion sounds good, can you please highlight it little more.
你提到在Form1上有一个打开任务表单的按钮。在该按钮的OnClick事件中，有一个If-Then-Else语句，该语句使用DCount（）函数来检查是否有任何记录没有设置End值。像这样：
You mentioned having a button on Form1 that opens the Tasks form. In that button''s OnClick event, have an If-Then-Else statement that uses the DCount() function to check if there are any records that don''t have the End value set. Something like this:
这篇关于跟踪任务是否已关闭，然后允许用户打开新任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
