自动生成条目 [英] Automatic entry generation

问题描述

我希望有一个表格，其中通过表格将新的文件分配给新的文件。归档号码将合并4个字段以创建数字。使用alphameric系统将是理想的，因此从第一个字段ex开始需要较短的时间。高湖= HL后跟一个数字被分配到文件类型rom teh文件类型字段，然后是破折号，后跟文件夹编号和子文件夹的字母。

我希望这是有道理的。我的编码经验很少，我甚至不知道从哪里开始，所以任何帮助都会非常感激。


谢谢

Hi,

I would like to have a form where a filing number is assigned to a new document being entered into the system via a form. The filing number will combine 4 fields to create a number. Using the alphameric system would be ideal so short froms would be required from the first field ex. High lake= HL followed by a number being assisgned to a file type rom teh file type field and then a dash followed by a folder number and a letter for a sub folder.
I hope this made sense. I have little coding experience and I am not even sure where to start so any assistance at all would be really really appreciated.

Thank you

推荐答案

我想要一个表格，其中一个新文件被分配了一个文件编号通过表格进入系统。归档号码将合并4个字段以创建数字。使用alphameric系统将是理想的，因此从第一个字段ex开始需要较短的时间。高湖= HL后跟一个数字被分配到文件类型rom teh文件类型字段，然后是破折号，后跟文件夹编号和子文件夹的字母。

我希望这是有道理的。我的编码经验很少，我甚至不知道从哪里开始，所以任何帮助都会非常感激。


谢谢

Hi,

I would like to have a form where a filing number is assigned to a new document being entered into the system via a form. The filing number will combine 4 fields to create a number. Using the alphameric system would be ideal so short froms would be required from the first field ex. High lake= HL followed by a number being assisgned to a file type rom teh file type field and then a dash followed by a folder number and a letter for a sub folder.
I hope this made sense. I have little coding experience and I am not even sure where to start so any assistance at all would be really really appreciated.

Thank you

我们需要有关这4个字段的更多信息，这些字段将包含新文档的文件编号：

1. 字段名称
2. 字段数据类型
3. 4个字段中每个字段的示例字段数据
4. 要合并字段值的序列
5. 一次将这4个字段中的值组合起来创建文件编号，您肯定这个新文件编号是唯一的吗？
6. 文件编号是否为表的Primry密钥？
7. 文件编号字段的名称是什么？
8. 等...........

我们需要有关这4个字段的更多信息，这些字段将包含新文档的文件编号：

1. 字段名称
2. 字段数据类型
3. 4个字段中每个字段的示例字段数据
4. 要合并字段值的序列
5. 将这4个字段的值组合在一起创建文件编号后，您是否肯定这个新文件编号是唯一的？
6. 文件编号是否为Primry Key表？
7. 文件编号字段的名称是什么？
8. 等...........

好​​的谢谢你的回复。以下是您要求的其他信息：


1）财产，文件类型，主要文件名和子文件名


2） PROPERTY和FILE TYPE是组合框，MAIN和SUB SILE NAME是文本框。


3）你想怎么样？


4）是的，它需要是唯一的，并且这个新的文件编号系统每一个都是独特的。另外一件事是，添加的每个新文件都需要关联下一个相应的数字。（希望这是有意义的）只是这样，当添加一个新文件时，将根据它自动分配适当的唯一文件编号。从前4个字段和下一个相应的文件编号中选择哪个值。


5）是的文件编号将是唯一的


6）新字段的名称将为FILE NUMBER


我非常感谢您的时间和精力，我不希望这一切都是为我而写的。我的问题是我不熟悉编码方面我理解它背后的逻辑（大多数情况下）我基本上只是寻找任何人可以给予的任何帮助，无论是代码，提示还是方向。


再次感谢

Ok thanks for the response. Here is the rest of the info you requested:

1)PROPERTY, FILE TYPE, MAIN FILE NAME AND SUB FILE NAME

2)PROPERTY and FILE TYPE are combo boxes, MAIN and SUB SILE NAME are text boxes.

3)How would you like this???

4)Yes it will need to be unique and with this new file numbering system each will be unique. One other thing will be that each new file added will need to have the next corresponding number associated.(hope that makes sense) It is just so that when a new file is added, the proper unique filing number will be assigned to it automatically depending on which values are chosen from teh previous 4 fields and the next corresponding filenumber number.

5)Yes the file number will be unique

6) the name of the new field will be FILE NUMBER

I really appreciate your time and effort and I do not expect this whole thing to be written for me. My problem is I am not good with teh coding aspect I understand the logic behind it all (for the most part) I am basically just looking for any assistance anyone could give whether it is code, tips or direction.

Thank you again

好​​的谢谢你的回复。以下是您要求的其他信息：


1）财产，文件类型，主要文件名和子文件名


2） PROPERTY和FILE TYPE是组合框，MAIN和SUB SILE NAME是文本框。


3）你想怎么样？


4）是的，它需要是唯一的，并且这个新的文件编号系统每一个都是独特的。另外一件事是，添加的每个新文件都需要关联下一个相应的数字。（希望这是有意义的）只是这样，当添加一个新文件时，将根据它自动分配适当的唯一文件编号。从前4个字段和下一个相应的文件编号中选择哪个值。


5）是的文件编号将是唯一的


6）新字段的名称将为FILE NUMBER


我非常感谢您的时间和精力，我不希望这一切都是为我而写的。我的问题是我不熟悉编码方面我理解它背后的逻辑（大多数情况下）我基本上只是寻找任何人可以给予的任何帮助，无论是代码，提示还是方向。


再次感谢

Ok thanks for the response. Here is the rest of the info you requested:

1)PROPERTY, FILE TYPE, MAIN FILE NAME AND SUB FILE NAME

2)PROPERTY and FILE TYPE are combo boxes, MAIN and SUB SILE NAME are text boxes.

3)How would you like this???

4)Yes it will need to be unique and with this new file numbering system each will be unique. One other thing will be that each new file added will need to have the next corresponding number associated.(hope that makes sense) It is just so that when a new file is added, the proper unique filing number will be assigned to it automatically depending on which values are chosen from teh previous 4 fields and the next corresponding filenumber number.

5)Yes the file number will be unique

6) the name of the new field will be FILE NUMBER

I really appreciate your time and effort and I do not expect this whole thing to be written for me. My problem is I am not good with teh coding aspect I understand the logic behind it all (for the most part) I am basically just looking for any assistance anyone could give whether it is code, tips or direction.

Thank you again

这将是基本逻辑，应该包含在Form的BeforeUpdate（）事件中。我不确定你希望如何生成下一个相应的数字以及它应该放在这个序列中的哪个位置。如果你愿意的话，请回复我。

This would be the basic logic and should be contained in the BeforeUpdate() Event of the Form. I''m not exactly sure how you want the next corresponding number to be generated and where it should be placed in this sequence. Get back to me on this, if you wish to.

展开 | 选择 | Wrap | 行号

这篇关于自动生成条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！