随机旋转工作时间表......可以吗？ [英] Random rotating work schedule...Can it be done??
问题描述
现在我已经注意到了;）这就是我想做的事情。我想设计Access以自动生成每月计划。这是抓住，我有三个班次（8-4,10-6和12-8）。每个工人每天轮流进行轮班。要手动完成它有点随机放置和非常严重。轮班只在星期一到星期五。
现在还有另一个问题。 8-4班次必须有2个人，而12-8班次只需要1个人。
如果有人能帮我这么做，我还有一个人。我希望能够指出需要的日子，并且在填写其余信息之前需要进行一些特定的转变。 （这并不重要，因为我总是可以导出日历并调整那些日子，但它会很好。）
我已经设置了一个像样的日历表单。我真正需要的是每天的子表单或查询或代码设计，它会给我这些结果。
提前感谢您的任何帮助，这个网站一直很棒帮助我的学习过程。
NICK
Hello Nick，
也许有人可以帮助你，但似乎你想要有人写几乎整个程序。如果您解释了应用程序的1个特定部分无法正常工作并发布所有相关信息和一些无效的代码，我认为您可能会得到更好的响应，然后我们可以通过这种方式缩小您的问题。
至于可以完成......答案是'是'。如果你已经正确设计了你的表结构几乎可以在Access中完成任何事情（自然地与数据库相关）。
欢呼，
现在我已经注意了;）这就是我想做的事情。我想设计Access以自动生成每月计划。这是抓住，我有三个班次（8-4,10-6和12-8）。每个工人每天轮流进行轮班。要手动完成它有点随机放置和非常严重。轮班只在星期一到星期五。
现在还有另一个问题。 8-4班次必须有2个人，而12-8班次只需要1个人。
如果有人能帮我这么做，我还有一个人。我希望能够指出需要的日子，并且在填写其余信息之前需要进行一些特定的转变。 （这并不重要，因为我总是可以导出日历并调整那些日子，但它会很好。）
我已经设置了一个像样的日历表单。我真正需要的是每天的子表单或查询或代码设计，它会给我这些结果。
提前感谢您的任何帮助，这个网站一直很棒帮助我的学习过程。
NICK
你好尼克，
也许有人可以帮助你，但似乎你想要有人写几乎整个程序。如果您解释了应用程序的1个特定部分无法正常工作并发布所有相关信息和一些无效的代码，我认为您可能会得到更好的响应，然后我们可以通过这种方式缩小您的问题。
至于可以完成......答案是'是'。如果你已经正确设计了你的表结构，几乎所有东西都可以在Access中完成（自然地与数据库相关）。
欢呼，
这就是我的困惑所在。我不确定如何设置正确的表结构。
我不想让任何人为我编写所有代码。我只是不知道如何开始使用它。
任何起点都会有所帮助。如果有人认为有帮助，我会更乐意发布我已经开始的数据库。
谢谢
尼克
我已经附上了迄今为止的内容。再次感谢大家。
这是开始发布它我们会检查出来给你一些指示。
欢呼，
这就是我困惑的地方。我不确定如何设置正确的表结构。
我不想让任何人为我编写所有代码。我只是不知道如何开始使用它。
任何起点都会有所帮助。如果有人认为有帮助，我会更乐意发布我已经开始的数据库。
谢谢
Nick
Now that I have your attention ;) Here''s what I would like to do. I would like to design Access to automatically generate a monthly schedule. Here''s the catch, I have three shifts (8-4,10-6, and 12-8). Each worker is rotated daily through these shifts. To do it by hand it is somewhat random placement and EXTREMELY TEDIOUS. The shifts are only Monday thru Friday.
Now heres another catch. The 8-4 shift has to have 2 people, and the 12-8 shift has to have only 1 person.
I have one more catch if anyone can help me even get this far. I want to be able to designate days off needed, and some specfic shift needed before filling in the rest of the info. (this is not as important as I can always export the calendar and adjust for those days, but it would be nice.)
I have a decent calendar form set up started. What I really need is either subform for each day or a query or code design that will give me these results.
Thank you in advance for any help, this site has always been a great help in my learning proccess.
NICK解决方案Hello Nick,
Maybe someone can help you but it appears you want someone to write almost the entire program. I think you may get a better response if you explained 1 specific part of the app that is not working and post all relevent information and some code that is not working and then we can narrow down your problem that way.
As for ''Can it be Done'' ... The answer is ''Yes''. If you have designed your table structure properly almost anything can be done in Access (related to databases naturally).
cheers,
Now that I have your attention ;) Here''s what I would like to do. I would like to design Access to automatically generate a monthly schedule. Here''s the catch, I have three shifts (8-4,10-6, and 12-8). Each worker is rotated daily through these shifts. To do it by hand it is somewhat random placement and EXTREMELY TEDIOUS. The shifts are only Monday thru Friday.
Now heres another catch. The 8-4 shift has to have 2 people, and the 12-8 shift has to have only 1 person.
I have one more catch if anyone can help me even get this far. I want to be able to designate days off needed, and some specfic shift needed before filling in the rest of the info. (this is not as important as I can always export the calendar and adjust for those days, but it would be nice.)
I have a decent calendar form set up started. What I really need is either subform for each day or a query or code design that will give me these results.
Thank you in advance for any help, this site has always been a great help in my learning proccess.
NICK
Hello Nick,
Maybe someone can help you but it appears you want someone to write almost the entire program. I think you may get a better response if you explained 1 specific part of the app that is not working and post all relevent information and some code that is not working and then we can narrow down your problem that way.
As for ''Can it be Done'' ... The answer is ''Yes''. If you have designed your table structure properly almost anything can be done in Access (related to databases naturally).
cheers,Thats exactly where my confusion is. I am not sure how to set the proper table structure.
I do not want to have anyone write all of the code for me. I am just stuck with no knowledge of how to even get off the ground with this.
Any starting point would be helpful. I would be more then happy to post the db I have started if anyone might think that is helpful.
Thanks
Nick
I have attached what I have Thus far. Thank you again everyone.
That''s a start post it and we''ll check it out and give you some pointers.
cheers,
Thats exactly where my confusion is. I am not sure how to set the proper table structure.
I do not want to have anyone write all of the code for me. I am just stuck with no knowledge of how to even get off the ground with this.
Any starting point would be helpful. I would be more then happy to post the db I have started if anyone might think that is helpful.
Thanks
Nick
这篇关于随机旋转工作时间表......可以吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
