如何保留从记录到记录的文本框中输入的值？ [英] How do I retain the value that is entered into a text box from record to record?

问题描述

我有一个表格，一次输入大约50-100条记录，所有记录都需要相同的批号。所有其他数据都需要更改，但我希望能够保留从记录到记录的批次编号，直到我准备好输入新批次。现在，我没有这个表单背后的代码，一切都是通过宏设置的。从我所看到的，这不可能在一个宏观中完成。我假设我需要一些代码。任何帮助将不胜感激。在此先感谢!!

I have a form that will have about 50 - 100 records entered at a time all needing the same batch number. All the other data will need to change, but I would like to be able to retain that batch number from record to record until I am ready to enter a new batch. Right now, I have no code behind this form, everything is set up through macros. From what I''ve seen, this can''t be done in a macro. I''m assuming I''ll need some code. Any help would be greatly appreciated. Thanks in advance!!

推荐答案

首先关闭：

1.您如何输入此数据。 （即你是从XLS文件导入的吗？）

1a。如果你是进口的，怎么样？ （正在使用的方法）

2.批号是否应该是默认值？


你需要更具体，关于什么你在做什么以及你是怎么做的。


-AJ

First off:
1. How are you entering this data. (i.e. are you importing it from a XLS file?)
1a. if you are importing, how? (Method being used)
2. Is the batch number supposed to be a default value perhaps?

You need to be a lot more specific, on what you are doing and how you are doing it.

-AJ

这两种数据正在输入。这个数据库中有大约15个表格供多个代理商使用。个人信息已经由访问中的表格预先填充，但其余信息将被手动输入。这样做的方式是我们有一个慈善活动，捐赠者用他们想要给出的形式填写他们的表格。在扫描时扫描的表格上有条形码，程序根据条形码扫描定位人员。从那里输入批号以及捐赠的金额。一些表格没有预先填充，因此个人信息，批号和捐赠金额都是手动输入的。批号由预先打印的批次报告卡确定，该报告卡上已有一个数字，代理商仅输入该批次的总金额。因此，批次将返回到这些表格中，以将各个金额与批次总金额联系起来。希望这会将其清除一点点。如果没有，请随时让我解释更多。

That data is being entered two ways. There are about 15 forms or so in this database for multiple agencies. The personal information is already prepopulated by tables within access, but the rest of the info will be manually entered. The way this works is we have a charitable campaign and donors fill out their form with the amont they want to give. There is a bar code on the form that is scanned in and upon scanning, the program locates the person based on the bar code scan. From there the batch number is entered along with the amounts donated. A couple of the forms are not prepopulated so the personal info, batch number and amounts donated are all entered manually. The batch number is determined by a preprinted batch report card that already had a number on it and the agency only enters the total amounts for that batch. So, the batch is then entered back into these forms to tie the individual amounts to a batch number total amount. Hopefully this clears it up a little bit. If not, feel free to ask me to explain more.

在将数据输入表单时处理批处理数据一致性的最简单方法是设置 .DefaultValue 控件（TextBox）的属性为使用代码所需的值。

The easiest way to handle consistency of data across a batch while entering data into a form is to set the .DefaultValue property of the control (TextBox) to the value required using code.

这篇关于如何保留从记录到记录的文本框中输入的值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！