7,762
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command1_Click()
Form7.Show 1
End Sub
双击Mshflexgrid1,加载窗体8(会员修改)。
Private Sub MSHFlexGrid1_DblClick()
If MSHFlexGrid1.Rows > 2 Then
Form8.Show 1
Else
Exit Sub
End If
End Sub
form7"确定”按钮
Private Sub Command2_Click()
......
Unload Form6
Form6.Show
Unload Form7
End Sub
form8"确定"按钮
Private Sub Command2_Click()
......
Unload Form6
Form6.Show
Unload Form8
End Sub
Private Sub Command2_Click()
Adodc1.RecordSource = "select * from 会员管理"
Adodc1.Refresh
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("会员编号") = Text1.Text
Adodc1.Recordset.Fields("会员姓名") = Text2.Text
Adodc1.Recordset.Fields("首字母") = Text3.Text
If Text4.Text = "" Then
Adodc1.Recordset.Fields("会员生日") = CDate("1601 - 1 - 1")
Else
Adodc1.Recordset.Fields("会员生日") = CDate(Text4.Text)
End If
Adodc1.Recordset.Fields("电话") = Text5.Text
Adodc1.Recordset.Fields("会员分组") = Combo1.Text
Adodc1.Recordset.Fields("消费总额") = Text6.Text
Adodc1.Recordset.Fields("可用积分") = Text7.Text
Adodc1.Recordset.Fields("最后消费日期") = CDate("1601-1-1")
Adodc1.Recordset.Update
Unload Form6
Form6.Show
Unload Form7
End Sub
Private Sub Command2_Click()
Adodc1.RecordSource = "select * from 会员管理 where 会员编号='" & Text1.Text & "'"
Adodc1.Refresh
Adodc1.Recordset.Fields("会员编号") = Text1.Text
Adodc1.Recordset.Fields("会员姓名") = Text2.Text
Adodc1.Recordset.Fields("首字母") = Text3.Text
If Text4.Text = "" Then
Adodc1.Recordset.Fields("会员生日") = CDate("1601 - 1 - 1")
Else
Adodc1.Recordset.Fields("会员生日") = CDate(Text4.Text)
End If
Adodc1.Recordset.Fields("电话") = Text5.Text
Adodc1.Recordset.Fields("会员分组") = Combo1.Text
Adodc1.Recordset.Fields("消费总额") = Text6.Text
Adodc1.Recordset.Fields("可用积分") = Text7.Text
Adodc1.Recordset.Fields("最后消费日期") = CDate("1601-1-1")
Adodc1.Recordset.Updatef
Unload Form6
Form6.Show
Unload Form8
End Sub