å ä¸ºä½ æ²¡æç»åºè¡¨ç»æåçªä½çå ·ä½è¦æ±ï¼ä¸ºäºè¯´ææ¹ä¾¿ï¼åå°ç¤ºä¾ä¸ç®äºç¶ï¼
1ã表å称å æ¬âæµè¯è¡¨âï¼âä½è âåâè¯ä¹¦ç¼ç â两个å段ãç»æå¾å¦ä¸ï¼
2ãçªä½å æ¬å个æªç»å®ææ¬æ¡ï¼å称ä¸å¯¹åºæ ç¾åï¼åä¸ä¸ªå为âä¿åæ°æ®âçæé®ãå¦ä¸å¾ï¼
3ãä¸å¾ä¸å½å ¥æ¾ç¤ºçæ°æ®ï¼ç¶åç¹å»âä¿åæ°æ®âæé®ãâæµè¯è¡¨âçæ°æ®ååå¦ä¸ï¼
4ãçªä½ä¸âä¿åæ°æ®âæé®çãåå»äºä»¶ã代ç 为ï¼
Private Sub ä¿åæ°æ®_Click()
On Error GoTo MyErr
' å®ä¹åé并èµå¼
Dim i, m, n, k As Integer
Dim zsid As String
m = Val(Me.å¼å§ç )
n = Val(Me.ç»æç )
k = Len(Me.å¼å§ç )
' æ£æ¥æ°æ®å½å
¥æ¯å¦æ£ç¡®
If IsNull(Me.ä½è
) Or IsNull(Me.éç¨ç ) Or IsNull(Me.å¼å§ç ) Or IsNull(Me.ç»æç ) Then
MsgBox "æ°æ®æªä¿åï¼è¯·æä¿¡æ¯å¡«åå®æ´åéè¯...", 64 + 0 + 4096, "æ³¢æ¶å·¥ä½å®¤"
Exit Sub
ElseIf k <> Len(Me.ç»æç ) Then
MsgBox "å¼å§ç ä¸ç»æç ä½æ°ä¸ä¸è´ï¼è¯·éæ°è¾å
¥...", 64 + 0 + 4096, "æ³¢æ¶å·¥ä½å®¤"
Exit Sub
ElseIf m > n Then
MsgBox "å¼å§ç ä¸è½å¤§äºç»æç ï¼è¯·éæ°è¾å
¥...", 64 + 0 + 4096, "æ³¢æ¶å·¥ä½å®¤"
Exit Sub
End If
' å¼å§ä¿åæ°æ®
For i = m To n
' 计ç®å¹¶æ ¼å¼åè¯ä¹¦ç¼ç
zsid = Me.éç¨ç & Right(Left(Me.å¼å§ç , k - Len(m)) & i, k)
' ç¨INSERTè¯å¥åå
¥æ°æ®
CurrentDb.Execute "INSERT INTO æµè¯è¡¨ VALUES ('" & Me.ä½è
& "', '" & zsid & "')"
Next i
Exit Sub
' åçæªç¥é误åçå¤ç
MyErr:
MsgBox "é误类åï¼" & Err.Description, 64 + 0 + 4096, "æ³¢æ¶å·¥ä½å®¤"
End Sub
Access 中的窗体是一种数据库对象,可用于创建数据库应用程序的用户界面。“绑定”窗体直接连接到表或查询之类的数据源,可用于输入、编辑或显示来自该数据源的数据。或者也可以创建“未绑定”窗体。
本回答被提问者采纳