Dim A As String, l As Integer A = "00000001" l = Len(A) A = Val(A) + 1 A = Right(String(l, "0") & A, l)
完整點: Private Sub Command1_Click() Dim A As String A = "00000001" A = ADD_a(A, 1) 'A = A + 1 A = ADD_a(A, 100) 'A = A + 100 End Sub Sub ADD_a(A As String, i As Long) Dim l As Integer l = Len(A) A = Val(A) + i A = Right(String(l, "0") & A, l)
End Sub
[code=VB Private Sub Form_Load() Dim A As String A = "0000000" Dim i As Integer For i = 0 To 5 A = Format(Val(A) + 1, "0000000") Debug.Print A NextEnd Sub[/code]
Private Sub Form_Load() Dim A As String A = "0000000" Dim i As Integer For i = 0 To 5 A = Format(Val(A) + 1, "0000000") Debug.Print A NextEnd Sub
For i = 0 To 10 Debug.Print Format(i, "0000000") Next
Private Sub Form_Load() Dim A As String A = "0000000" Dim i As Integer For i = 0 To 5 A = Format(Val(A) + 1, "0000000") Debug.Print A Next
Private Sub Command1_Click() Dim A As Variant Dim i As Long A = "00000001" For i = 0 To 10 Debug.Print A A = A + 1 A = Format(A, "00000000") Next End Sub
如果A里面全是数字,将其转换为INT后再加一,然后按格式转换成STRING即可
楼上各位的代码都可参考.看来关键就是:按你的需求是否需要封装成函数(一般应该需要吧),封装时那个输出字符串的长度你打算怎么控制,是通过给出的"00000001"参数由函数自己算长度,还是通过给个 i As Long参数来控制
DIM A AS String A="00000001" Format(CInt (A) + 1, "00000000")
A = "00000001"
l = Len(A)
A = Val(A) + 1
A = Right(String(l, "0") & A, l)
Private Sub Command1_Click()
Dim A As String
A = "00000001"
A = ADD_a(A, 1) 'A = A + 1
A = ADD_a(A, 100) 'A = A + 100
End Sub
Sub ADD_a(A As String, i As Long)
Dim l As Integer
l = Len(A)
A = Val(A) + i
A = Right(String(l, "0") & A, l)
End Sub
[code=VB
Private Sub Form_Load()
Dim A As String
A = "0000000"
Dim i As Integer
For i = 0 To 5
A = Format(Val(A) + 1, "0000000")
Debug.Print A
NextEnd Sub[/code]
Private Sub Form_Load()
Dim A As String
A = "0000000"
Dim i As Integer
For i = 0 To 5
A = Format(Val(A) + 1, "0000000")
Debug.Print A
NextEnd Sub
Debug.Print Format(i, "0000000")
Next
Dim A As String
A = "0000000"
Dim i As Integer
For i = 0 To 5
A = Format(Val(A) + 1, "0000000")
Debug.Print A
Next
Dim A As Variant
Dim i As Long A = "00000001"
For i = 0 To 10
Debug.Print A
A = A + 1
A = Format(A, "00000000")
Next
End Sub
DIM A AS String A="00000001"
Format(CInt (A) + 1, "00000000")
conn.Open (connstring)
str0 = "select *from wc_tjxt.dbo.tj_tjdjb where DJRQ= '" & Trim(Text1.Text) & "' "
rs.Open str0, conn, 1, 3
rs.MoveFirst
conn.Execute "insert into wc_tjxt.dbo.tj_tjxj 怎么样把指针对应的那条记录插入到表里"
谢谢各位高手啊!!!!!!
conn.Open (connstring)
str0 = "select *from wc_tjxt.dbo.tj_tjdjb where DJRQ= '" & Trim(Text1.Text) & "' "
rs.Open str0, conn, 1, 3
rs.MoveFirst
conn.Execute "insert into wc_tjxt.dbo.tj_tjxj 怎么样把指针对应的那条记录插入到表里"
谢谢各位高手啊!!!!!!