利用追加查询来实现自增序号的示例
来源:优易学  2011-12-9 17:37:53   【优易学:中国教育考试门户网】   资料下载   IT书店
 代码:

  Private Sub cmdAdd_Click()

  '新增

  Dim i As Long

  i = Me.labNum.Tag

  With frmChild.Form

  .AllowAdditions = True

  .AllowEdits = True

  End With

  DoCmd.SetWarnings False

  DoCmd.RunSQL "INSERT INTO tblWords ( WordID ) SELECT '" & i & "' AS Num;"

  DoCmd.SetWarnings True

  Me.frmChild.Requery

  Me.labNum.Tag = i + 1

  End Sub

  Private Sub cmdEdit_Click()

  '修改

  With frmChild.Form

  .AllowEdits = True

  End With

  End Sub

  Private Sub cmdClose_Click()

  DoCmd.Close

  End Sub

  Private Sub Form_Load()

  '词汇库的记录数量

  Me.labNum.Tag = DCount("*", "tblWords") + 1

  End Sub

责任编辑:小草

文章搜索:
 相关文章
热点资讯
资讯快报
热门课程培训