这可能吗？ [英] Is this Possible?

问题描述

我有一张跟踪缺席和重新分配员工职位的表格。表单中的关键字段是EmployeeID，JobNumber，HiredEmployeeeID，DayOfWeek，ShiftID。


我们所做的是当一个emplyye召唤病人等时，我们将填补空缺，而另一名员工则来自谁做了一个不那么重要的任务的转变。


我希望能够进入HiredEmployeeId字段的员工进行检查运行以查看员工是否正在使用相同的shiftID和根据我称之为tblJobsPicked的表格的一天，然后让我的员工EmployeeID在我完成我的入职后输入作为表格的新条目。这可能吗？


谢谢

I have a form that tracks absentee and and reaassigning employees positions. The key fields in the form are EmployeeID, JobNumber, HiredEmployeeeID, DayOfWeek, ShiftID.

What we do is that when an emplyye calls out sick etc we will fill the vacancy wiith another employee from the shift who works a less important assignment.

I would like to be able to enter an employee into the HiredEmployeeId field have a check run to see if the employee is working the same shiftID and day according to a table I have called tblJobsPicked and then have that employees EmployeeID entered as a ne entry into the form after I complete my entry I started. Is this possible???

Thanks

推荐答案

是的。


问候，

Scott

Yes.

Regards,
Scott

''开个玩笑，但是你的问题要求得到答案！ :-)


你的要求确实是可能的。


只要想到我的头脑，你就需要一些东西就像测试员工是否在工作的一小段代码一样，如果评估为true，则将他们的employeeID插入到病态员工的插槽中。你是怎么写VBA代码的？


问候，

Scott

''Scuse the joke, but your question demands a pat answer! :-)

What you are asking is indeed possible.

Just thinking off the top of my head, you''ll need something like a little piece of code that tests if the employee is on the job or not, then if this evaluates true plug their employeeID into the sick employee''s slot. How are you at writing VBA code?

Regards,
Scott

''开个玩笑，但是你的问题要求得到答案！ :-)


你的要求确实是可能的。


只要想到我的头脑，你就需要一些东西就像测试员工是否在工作的一小段代码一样，如果评估为true，则将他们的employeeID插入到病态员工的插槽中。你是怎么写VBA代码的？


问候，

Scott

''Scuse the joke, but your question demands a pat answer! :-)

What you are asking is indeed possible.

Just thinking off the top of my head, you''ll need something like a little piece of code that tests if the employee is on the job or not, then if this evaluates true plug their employeeID into the sick employee''s slot. How are you at writing VBA code?

Regards,
Scott

谢谢你回复。

我在编写VBA代码时感到很失望。在我离开的时候，我自我教导，并没有走得太远。如果您有任何建议或启动想法，我会非常欠您的债务。

谢谢

Dan

Thank you for the reply.
I am losy at writing VBA code. I am self teaching myself as I go, and have not gotten too far. If you have any suggestions or starting ideas, I would be greatly in you debt.
Thank you
Dan

这篇关于这可能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！