![]() ![]() |
|
利用追加查询来实现自增序号的示例 | |
作者:佚名 文章来源:不详 点击数 更新时间:2008/7/28 12:15:34 文章录入:杜斌 责任编辑:杜斌 | |
|
|
代码: 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 相关链接: 更多信息请访问:计算机等级考试站 计算机等级考试在线题库 计算机等级考试论坛 |
|
![]() ![]() |