可能的功能创建 [英] Possible function creation

问题描述

我在bytes社区的帮助下一直在研究时间表数据库！我有一个主窗体，显示四个员工姓名，每个名称下有两个按钮（登录，退出）。编码如下：

I have been working on a timesheet database with the help of the bytes community! I have the main form displaying four employees names with 2 buttons under each name (sign in, sign out). The coding is the following:

展开 | 选择 | Wrap | 行号

推荐答案

所以，你真的有 四种 类型的工作日：

So, you really have four types of work days:

1. 全天工作
2. 1/2天假期
3. 1/2天生病
4. 1/2天个人

我会有一个包含两个字段的小表（tblWorkTypes）：ID，WorkType。它将有四个记录：

I would Have a small table (tblWorkTypes) with two fields: ID, WorkType. It would have four records:

展开 | 选择 | Wrap | 行号

我想是的......我可以通过它来解决看看它是怎么回事......我需要将tbl_master中的WorkType字段索引到新表中的字段吗？


此外，这也许值得一提。我正在使用的计算机是触摸屏，这就是为什么我一直犹豫不要远离组合框，因为它们在小型触摸屏笔记本电脑上使用起来更难...是否有可能保持我所拥有的骨头与是/没有msgbox并弹出我的其他表格？我的日期形式有三个按下的大按钮，对于那些人来说很容易......我一直在尝试，到目前为止失败的是根据点击退出的人的方式打开当前记录的表格（因为我们有那里的编码）当他们点击日期类型时，它会将数据添加到表格中。这有意义吗？

I think so... and I can work through it to see how it goes... would i need to index the WorkType field in tbl_master to the field in the new table?

Also, perhaps this is something of importance to mention. The computer i am using is touchscreen that is why i have been hesitant to stay away from the combo boxes as they are harder to use on a small touchscreen laptop... would it be possible to keep the bones of what I have with the yes/no msgbox and pop up my other form? My type of day form had three large buttons to press that were easy for the guys... what i have been trying, and failing so far was to have the form open to the current record based on who clicked sign out (since we have the coding in there) and when they click on the type of day it will then add the data to the table. Does that make sense?

如果你有一个触摸屏，你可以增加组合框的字体大小。因为这是Access中的默认设置，所以没有任何意义可以保持微小。


另一种选择（再次，因为你的员工人数有限），是有选择权的组有四个大按钮，表示工作日类型。在有人尝试注销后，该选项组变为可见，他们按下标识工作类型的选项组按钮，然后他们实际注销。这将是一个三击系列：员工退出的按钮，工作类型的按钮，按下OK按钮。这一切都很简单，我不觉得太复杂。您需要的大部分内容基本上都在那里。


等待hepp ....

If you have a touchscreen, you can increase the font size of the combo boxes. No sense in keeping things tiny just because that is the default in Access....

Another option (again, since you have a limited number of employees), is to have an option group with four large buttons indicating the work day type. After someone tries to sign out, that option group becomes visible, they depress the option group button that identifies the work type and then they actually sign out. It would be a three-click series: push button for employee sign out, push button for work type, push OK button. It would all be pretty straight-forward, and I don''t think too complex. Much of what you would need for that is essentially there.

Standing by to hepp....

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