|
修改字段“包装箱号”为长整型或者其它数值型数据类型。网速不给力,不传附件了,代码如下:- Private Sub Command10_Click()
- Dim rst As New ADODB.Recordset
- Dim rst2 As New ADODB.Recordset
- Dim s As Long
- s = 1
- If Me.箱包装数量 > 0 Then
- rst.Open "temp", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
- rst2.Open "tblPacklistdetail", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
- For j = 1 To rst2.RecordCount
- For i = 1 To rst2("订单数量") / rst2("箱包装数量")
- rst.AddNew
- rst("产品号") = rst2("产品号")
- rst("产品描述") = rst2("产品描述")
- rst("订单数量") = rst2("订单数量") / rst2("箱包装数量")
- rst("包装箱号") = s
- rst("箱包装数量") = rst2("箱包装数量")
- rst("包装号") = rst2("包装号")
- rst.Update
- s = s + 1
- Next
- rst2.MoveNext
- Next
- End If
- rst.Close
- MsgBox "Done"
- End Sub
复制代码 请好好理解变量的【生命周期】。 |
|