加班表格提交并保存 [英] Overtime form submit and save

问题描述

Hello Everyone，


我被要求在Ms Access中创建一个允许员工注册加班的表单。我创建了一个一次持续2周的表单。现在我被要求添加允许用户输入日期然后保存它的功能。保存完成后，用户可以随意更改输入的小时数。这是允许直到实际班次的24小时。在这种情况下，不允许更改。此外，还添加了一个提交按钮。按下时，也不允许更改。我一直在努力如何使提交功能发生，该功能允许在轮班前24小时进行换档。任何帮助是极大的赞赏。我很绝望....谢谢，理查德

Hello Everyone,

I have been asked to create a form in Ms Access that allows employees to signup for overtime. I created a form that goes by 2 week periods at a time. Now I have been asked to add functionality that allows the user to enter the date then save it. When the save is done, the user is able to change the hours entered at will. This is to be allowed up until 24 hours of the actual shift. In this case, No changes are allowed. Also, a submit button has been added. When it is pressed, no changes are allowed either. I have been struggling on how to make the submit function happen with the feature that allows shift chages up till 24 hours before the shift. Any help is greatly appreciated. I am desperate....Thanks, Richard

推荐答案

我认为提交是指按钮必须在某处更新标志。

表单上控件的BeforeUpdate事件过程将检查当前日期/时间并将其与正在更新的项目的日期/时间进行比较。如果它少于24小时，则取消设置为真。否则，检查提交更新的标志。如果为TRUE，则Cancel也设置为TRUE。如果这些条件都不满足则更新继续进行。

这有帮助吗？

I would think that the "Submit" button would have to update a flag somewhere.
The BeforeUpdate Event Procedures of the controls on the form would check check the current Date / Time and compare it with the Date / Time of the item being updated. If it is less than 24 hours before, then Cancel is set to true. Otherwise, the flag updated by the commit is checked. If that is TRUE then Cancel is also set to TRUE. If neither of these conditions are met then the update proceeds.
Does that help?

我有一个想法，但对我来说仍然不是很清楚。提交类a更新前的函数，其中两个日期是相同的？如何取消实施？谢谢，理查德

I have an idea but it still is not very clear to me. The submit class a before update function where the two dates are conpared? how would cancel be implemented? Thanks, Richard

我错了，我的意思是提交调用该函数，我怎么能实现保存按钮，以便用户可以根据需要更改他们的小时数？

My wrong, I mean the submit calls the function, how could i implement the save button so that the users can change their hours as needed ?

这篇关于加班表格提交并保存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！