|
Private Sub Command0_Click()
Dim rs As ADODB.Recordset
Dim str As String
Dim i As Integer
Dim j As Integer
Dim rs1 As ADODB.Recordset
Dim str1 As String
Set rs = New ADODB.Recordset
Set rs1 = New ADODB.Recordset
str = "select * from 表2"
rs.Open str, CurrentProject.Connection, adOpenKeyset, adLockReadOnly
str1 = "select * from 表3"
rs1.Open str1, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
If rs.EOF Then Exit Sub
rs.MoveLast
rs.MoveFirst
Do Until rs.EOF
j = rs(1) \ 1200
If j > 0 Then
For i = 1 To j
rs1.AddNew
rs1(1) = 1200
rs1.Update
Next i
If rs(1) - 1200 * j <> 0 Then
rs1.AddNew
rs1(1) = rs(1) - 1200 * j
rs1.Update
End If
Else
rs1.AddNew
rs1(1) = rs(1)
rs1.Update
End If
rs.MoveNext
Loop
DoCmd.OpenTable "表3"
rs.Close
rs1.Close
Set rs = Nothing
Set rs1 = Nothing
End Sub
用这个拆分记录的函数如何修改为按姓名拆分,请各位老师帮助!谢谢! |
|