重新使用输入的最后一个值 [英] Re-using last value entered

问题描述

大家好，

这似乎应该很简单，但我无法理解。我有一个数据库，里面有一张所要求的测量服务订单表。我们在请求时输入数据。我有两个字段，我刚刚添加到表中，以便现场工作人员实际完成工作，一个叫做CREW，另一个是DATE_IN（用于日期字段）。我创建了一个表单供现场协调员使用，这使他只能在这两个字段中输入数据。它使用一个组合框来选择现有订单的文件编号，弹出地址，细分等数据，以便他可以验证他是否输入了正确的文件编号（但不允许他更改数据）。我想为他进一步简化事情，因为他每天早上都必须输入这些东西。我已经将DATE_IF字段设置为= Date（）。现在我要做的是让CREW字段自动保留他上次输入的值。例如，如果他从组合框中选择文件号2007-6577，则他输入Mike&史蒂夫"当CREW接受该领域的工作，然后他选择文件号2007-3845 ...我想要Mike&史蒂夫"自动进入CREW字段。这样他就可以继续选择某个工作人员正在拍摄的文件编号，直到他准备好输入新的工作人员和他们的一系列文件编号。我不能为船员创建一个组合框，因为谁继续工作人员并不总是相同。

Hi all,
This seems like something that should be simple, but I can''t figure it out. I have a database with a table of orders for surveying services requested. We enter the data at the time of the request. I have two fields that I just added to the table for when the field crew actually goes to do the job, one is called CREW and the other is DATE_IN (for date-in-field). I created a form for the field coordinator to use that allows him to enter the data in those two fields only. It uses a combo box for him to select the file number of the existing order, which pops up address, subdivision, etc. data so that he can verify that he entered the right file number (but doesn''t allow him to alter that data). I want to simplify things even further for him, because he will have to enter this stuff each morning. I already have the DATE_IF field set to =Date(). Now what I want to do is have the CREW field automatically keep the value that he last entered. For example, if he selects file number 2007-6577 from the combo box, then he enters "Mike & Steve" as the CREW taking the job in the field, then he selects file number 2007-3845...I want "Mike & Steve" to automatically be in the CREW field. That way he can just keep on selecting file numbers that a certain crew is taking, until he is ready to enter a new crew and their series of file numbers. I can''t create a combo box for the crew because who goes on what crew is not always the same.

推荐答案

大家好，

这看起来应该很简单，但我无法理解。我有一个数据库，里面有一张所要求的测量服务订单表。我们在请求时输入数据。我有两个字段，我刚刚添加到表中，以便现场工作人员实际完成工作，一个叫做CREW，另一个是DATE_IN（用于日期字段）。我创建了一个表单供现场协调员使用，这使他只能在这两个字段中输入数据。它使用一个组合框来选择现有订单的文件编号，弹出地址，细分等数据，以便他可以验证他是否输入了正确的文件编号（但不允许他更改数据）。我想为他进一步简化事情，因为他每天早上都必须输入这些东西。我已经将DATE_IF字段设置为= Date（）。现在我要做的是让CREW字段自动保留他上次输入的值。例如，如果他从组合框中选择文件号2007-6577，则他输入Mike&史蒂夫"当CREW接受该领域的工作，然后他选择文件号2007-3845 ...我想要Mike&史蒂夫"自动进入CREW字段。这样他就可以继续选择某个工作人员正在拍摄的文件编号，直到他准备好输入新的工作人员和他们的一系列文件编号。我不能为船员创造一个组合框，因为谁继续发挥作用并不总是相同的。

Hi all,
This seems like something that should be simple, but I can''t figure it out. I have a database with a table of orders for surveying services requested. We enter the data at the time of the request. I have two fields that I just added to the table for when the field crew actually goes to do the job, one is called CREW and the other is DATE_IN (for date-in-field). I created a form for the field coordinator to use that allows him to enter the data in those two fields only. It uses a combo box for him to select the file number of the existing order, which pops up address, subdivision, etc. data so that he can verify that he entered the right file number (but doesn''t allow him to alter that data). I want to simplify things even further for him, because he will have to enter this stuff each morning. I already have the DATE_IF field set to =Date(). Now what I want to do is have the CREW field automatically keep the value that he last entered. For example, if he selects file number 2007-6577 from the combo box, then he enters "Mike & Steve" as the CREW taking the job in the field, then he selects file number 2007-3845...I want "Mike & Steve" to automatically be in the CREW field. That way he can just keep on selecting file numbers that a certain crew is taking, until he is ready to enter a new crew and their series of file numbers. I can''t create a combo box for the crew because who goes on what crew is not always the same.

我上面有一个拼写错误，Date-In-Field字段叫做DATE_IF，而不是DATE_IN。

I have a typo above, the Date-In-Field field is called DATE_IF, not DATE_IN.

我上面有一个拼写错误，Date-In-Field字段被称为DATE_IF，而不是DATE_IN。

I have a typo above, the Date-In-Field field is called DATE_IF, not DATE_IN.

对不起，我一直回复自己，但我还有一个可能有帮助的澄清：


我更愿意拥有CREW字段自动填写与文件编号组合框字段中丢失焦点或更改后事件上输入的值相同的值，除非您有更好的想法。

此外，请记住使用最后的记录自动填充是不行的，因为这些不会按顺序排列。只有当它使用最后输入的内容时它才有效。

Sorry I keep replying to myself, but I have one more clarification that might help:

I would prefer to have the CREW field automatically fill in the same value as last entered on a lost-focus or after-change event from the File number combo box field, unless you have a better idea.
Also, keep in mind that it wouldn''t work for it to auto fill using the last record because these won''t be in that order. It would only work if it uses what was last entered.

我会根据你的CREW表创建一个frmCrew。

现在为订单添加一个子表单（接受向导中提交的建议链接！），您的所有用户需要做的就是转到正确的工作人员，Access将过滤子表单以显示所选CREW的行。


想法？


Nic; o）

I would create a frmCrew based on your CREW table.
Now add a subform for the orders (accept the proposed link filed in the wizard!) and all your user needs to do is to go to the correct crew and Access will filter the subform to show just the rows for the selected CREW.

Idea ?

Nic;o)

这篇关于重新使用输入的最后一个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！