- Foxtable(狐表) (http://foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2)
---- 咨询如何实现自动生产SN码 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=191186)
-- 发布时间：2024/3/29 18:31:00
-- 咨询如何实现自动生产SN码
版主，您好！
我用EXCEL做了自动申请SN码的公式，请问狐表可以做吗？附件已上传
盒号 ： MBA0522412 （手动输入信息）通过矩阵和设定公式，实现如下SN码（1-20个循环）
| MBA05224121001-01 |
| MBA05224121001-02 |
| MBA05224121001-03 |
| MBA05224121001-04 |
| MBA05224121001-05 |
| MBA05224121001-06 |
| MBA05224121001-07 |
| MBA05224121001-08 |
| MBA05224121001-09 |
| MBA05224121001-10 |
| MBA05224121001-11 |
| MBA05224121001-12 |
| MBA05224121001-13 |
| MBA05224121001-14 |
| MBA05224121001-15 |
| MBA05224121001-16 |
| MBA05224121001-17 |
| MBA05224121001-18 |
| MBA05224121001-19 |
| MBA05224121001-20 |
| MBA05224121002-01 |
| MBA05224121002-02 |
| MBA05224121002-03 |
| MBA05224121002-04 |
| MBA05224121002-05 |
| MBA05224121002-06 |
| MBA05224121002-07 |
| MBA05224121002-08 |
| MBA05224121002-09 |
| MBA05224121002-10 |
| MBA05224121002-11 |
| MBA05224121002-12 |
| MBA05224121002-13 |
| MBA05224121002-14 |
| MBA05224121002-15 |
| MBA05224121002-16 |
| MBA05224121002-17 |
| MBA05224121002-18 |
| MBA05224121002-19 |
| MBA05224121002-20 |
| MBA05224121003-01 |
| MBA05224121003-02 |
| MBA05224121003-03 |
| MBA05224121003-04 |
| MBA05224121003-05 |
| MBA05224121003-06 |
| MBA05224121003-07 |
| MBA05224121003-08 |
| MBA05224121003-09 |
| MBA05224121003-10 |
| MBA05224121003-11 |
| MBA05224121003-12 |
| MBA05224121003-13 |
| MBA05224121003-14 |
| MBA05224121003-15 |
| MBA05224121003-16 |
| MBA05224121003-17 |
| MBA05224121003-18 |
| MBA05224121003-19 |
| MBA05224121003-20 |
| MBA05224121004-01 |
| MBA05224121004-02 |
| MBA05224121004-03 |
| MBA05224121004-04 |
| MBA05224121004-05 |
| MBA05224121004-06 |
| MBA05224121004-07 |
| MBA05224121004-08 |
| MBA05224121004-09 |
| MBA05224121004-10 |
| MBA05224121004-11 |
| MBA05224121004-12 |
| MBA05224121004-13 |
| MBA05224121004-14 |
| MBA05224121004-15 |
| MBA05224121004-16 |
| MBA05224121004-17 |
| MBA05224121004-18 |
| MBA05224121004-19 |
| MBA05224121004-20 |
| MBA05224121005-01 |
| MBA05224121005-02 |
| MBA05224121005-03 |
| MBA05224121005-04 |
| MBA05224121005-05 |
| MBA05224121005-06 |
| MBA05224121005-07 |
| MBA05224121005-08 |
| MBA05224121005-09 |
| MBA05224121005-10 |
| MBA05224121005-11 |
| MBA05224121005-12 |
| MBA05224121005-13 |
| MBA05224121005-14 |
| MBA05224121005-15 |
| MBA05224121005-16 |
| MBA05224121005-17 |
| MBA05224121005-18 |
| MBA05224121005-19 |
| MBA05224121005-20 |
。。。。。。
-- 发布时间：2024/3/30 9:14:00
--
根据什么规则生成？
-- 发布时间：2024/3/30 18:15:00
--
版主，您好！
盒号的SN码原则说明：MBA0522412主要关键字，后面1001~9999流水号，每个流水号-01、-02、-03、-04、-05、-06、-07、-08、-09、-10、-11、-12、-13、-14、-15、-16、-17、-18、-19、-20；
举例：
| MBA05224121001-01 |
| MBA05224121001-02 |
| MBA05224121001-03 |
| MBA05224121001-04 |
| MBA05224121001-05 |
| MBA05224121001-06 |
| MBA05224121001-07 |
| MBA05224121001-08 |
| MBA05224121001-09 |
| MBA05224121001-10 |
| MBA05224121001-11 |
| MBA05224121001-12 |
| MBA05224121001-13 |
| MBA05224121001-14 |
| MBA05224121001-15 |
| MBA05224121001-16 |
| MBA05224121001-17 |
| MBA05224121001-18 |
| MBA05224121001-19 |
| MBA05224121001-20 |
| MBA05224121002-01 |
| MBA05224121002-02 |
| MBA05224121002-03 |
| MBA05224121002-04 |
| MBA05224121002-05 |
| MBA05224121002-06 |
| MBA05224121002-07 |
| MBA05224121002-08 |
| MBA05224121002-09 |
| MBA05224121002-10 |
| MBA05224121002-11 |
| MBA05224121002-12 |
| MBA05224121002-13 |
| MBA05224121002-14 |
| MBA05224121002-15 |
| MBA05224121002-16 |
| MBA05224121002-17 |
| MBA05224121002-18 |
| MBA05224121002-19 |
| MBA05224121002-20 |
| MBA05224121003-01 |
| MBA05224121003-02 |
| MBA05224121003-03 |
| MBA05224121003-04 |
| MBA05224121003-05 |
| MBA05224121003-06 |
| MBA05224121003-07 |
| MBA05224121003-08 |
| MBA05224121003-09 |
| MBA05224121003-10 |
| MBA05224121003-11 |
| MBA05224121003-12 |
| MBA05224121003-13 |
| MBA05224121003-14 |
| MBA05224121003-15 |
| MBA05224121003-16 |
| MBA05224121003-17 |
| MBA05224121003-18 |
| MBA05224121003-19 |
| MBA05224121003-20 |
| MBA05224121004-01 |
| MBA05224121004-02 |
| MBA05224121004-03 |
| MBA05224121004-04 |
| MBA05224121004-05 |
| MBA05224121004-06 |
| MBA05224121004-07 |
| MBA05224121004-08 |
| MBA05224121004-09 |
| MBA05224121004-10 |
| MBA05224121004-11 |
| MBA05224121004-12 |
| MBA05224121004-13 |
| MBA05224121004-14 |
| MBA05224121004-15 |
| MBA05224121004-16 |
| MBA05224121004-17 |
| MBA05224121004-18 |
| MBA05224121004-19 |
| MBA05224121004-20 |
| ~~~~~~~~ |
-- 发布时间：2024/3/31 20:49:00
--
Dim s As String = "MBA0522412"
Dim a As Integer = 1000
Dim cnt As Integer = 20
For i As Integer = 1 To 5
For j As Integer = 1 To 20
output.show(s & (a + i) & format(j, "00"))
Next
Next
-- 发布时间：2024/4/1 15:47:00
--
版主，您好1
自己没认真钻研狐表，请问我用窗口设计按钮后，将上述函数放进去试，还是不行，请问哪里错了？谢谢！
此主题相关图片如下：示例.png
-- 发布时间：2024/4/1 16:07:00
--
这个代码只是把结果输出到命令窗口
-- 发布时间：2024/4/1 16:08:00
--
版主，您好！
附件示例2我新增了盒号自动生成表，建立了盒号关键字段、盒号全称两个列名称
此主题相关图片如下：示例2.png
此主题相关图片如下：示例2.png-- 发布时间：2024/4/1 16:11:00
--
然后呢？
-- 发布时间：2024/4/1 16:18:00
--
版主，您好！我试了，已经OK，谢谢您！
此主题相关图片如下：成功案例.jpg