本文介绍了我需要有关如何使表单自动生成数字的帮助的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 我有一张表格。有一个字段名称ECO编号。 我希望这个字段生成阿尔法编号,如ECO-0001,ECO-0002等,当我舔一个按钮创建一个新记录时。你可以帮帮我吗? 谢谢Hi,I have a form. There is a field name ECO Number.I want this field to generate the alpha number such as ECO-0001, ECO-0002 and so on when I lick on a button to create a new record. Could you please help me out?Thanks推荐答案 您的表名是tblECO,在此表中是一个名为[ECO Number] - {TEXT 8}的字段。 [ECO-Number]必须是顺序的,不能为NULL(必需=是),是主键或表中的唯一索引,并且具有ECO-XXXX的确切格式。 字段([ECO编号])已经播种,这意味着至少有一个单个格式ECO-XXXX的值存在于其中。 以下公共函数将生成下一个唯一的,Se你的退出ECO号码。 Your Table name is tblECO and in this Table is a Field named [ECO Number] - {TEXT 8}. [ECO-Number] must be sequential in nature, cannot be NULL (Required = Yes), is the Primary Key or is a Unique Index in the Table, and is of the exact Format of ECO-XXXX. The Field ([ECO Number]) is already seeded, meaning that at least a single Value of the Format ECO-XXXX exists in it. The following Public Function will generate the next Unique, Sequential ECO Number for you. 展开 | 选择 | Wrap | 行号 这篇关于我需要有关如何使表单自动生成数字的帮助的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
10-31 13:21