If MsgBox("你是确定吗?", vbYesNo, "请回答?") = vbYes Then ......
Else form2.show
End If
If MsgBox("你是确定吗?", vbYesNo, "请回答?") = vbYes Then ......
Else form2.show
End If
Private Sub Command1_Click() If Combo1.Text = "Admin" And Text1.Text = "123" Then SMIS_mdi.Show Unload Me ElseIf Combo1.Text = "User" And Text1.Text = "321" Then SMIS_mdi.Show Unload Me Else MsgBox "用户名或密码错误" Text1.Text = "" Text1.SetFocus End If End SubPrivate Sub Command2_Click() Unload Me End Sub
Private Sub Command1_Click() Dim strMessage As String strMessage = InputBox("请输入数据", "提示") MsgBox strMessage End Sub
form1(主窗体)中 设一public类型变量 strTemp Private Sub Command1_Click() Form2.Show vbModal if strTemp="" then msgbox "按下取消按钮" else msgbox "输入数据为:" & strTemp end if End Subform2(弹出窗口)中 Private Sub Command1_Click()'按下确认按钮 Form1.strTemp = text1.Text End SubPrivate Sub Command2_Click()'按下取消按钮 Form1.strTemp = "" End Sub
Private Sub Command10_Click() Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Set cnn = New ADODB.Connection ' 引用 ODBC driver 建立连接. cnn.ConnectionString = "driver={SQL Server};" & _ "server=dcser;uid=sa;pwd=;database=stxt" cnn.OpenadoConnection.Execute "Update Rs Set QQTS = 0" 请问这句要怎么改呢?
Private Sub Command10_Click() Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Set cnn = New ADODB.Connection ' 引用 ODBC driver 建立连接. cnn.ConnectionString = "driver={SQL Server};" & _ "server=dcser;uid=sa;pwd=;database=stxt" cnn.OpenadoConnection.Execute "Update Rs Set QQTS = 0" 请问这句要怎么改呢?错误信息424 要求对象
......
Else
form2.show
End If
......
Else
form2.show
End If
If Combo1.Text = "Admin" And Text1.Text = "123" Then
SMIS_mdi.Show
Unload Me
ElseIf Combo1.Text = "User" And Text1.Text = "321" Then
SMIS_mdi.Show
Unload Me
Else
MsgBox "用户名或密码错误"
Text1.Text = ""
Text1.SetFocus
End If
End SubPrivate Sub Command2_Click()
Unload Me
End Sub
Dim strMessage As String
strMessage = InputBox("请输入数据", "提示")
MsgBox strMessage
End Sub
设一public类型变量 strTemp
Private Sub Command1_Click()
Form2.Show vbModal
if strTemp="" then
msgbox "按下取消按钮"
else
msgbox "输入数据为:" & strTemp
end if
End Subform2(弹出窗口)中
Private Sub Command1_Click()'按下确认按钮
Form1.strTemp = text1.Text
End SubPrivate Sub Command2_Click()'按下取消按钮
Form1.strTemp = ""
End Sub
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cnn = New ADODB.Connection
' 引用 ODBC driver 建立连接.
cnn.ConnectionString = "driver={SQL Server};" & _
"server=dcser;uid=sa;pwd=;database=stxt"
cnn.OpenadoConnection.Execute "Update Rs Set QQTS = 0" 请问这句要怎么改呢?
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cnn = New ADODB.Connection
' 引用 ODBC driver 建立连接.
cnn.ConnectionString = "driver={SQL Server};" & _
"server=dcser;uid=sa;pwd=;database=stxt"
cnn.OpenadoConnection.Execute "Update Rs Set QQTS = 0" 请问这句要怎么改呢?错误信息424 要求对象
如果你想要例子程序,Call 俺
show后加参数 1使之打开变为模式窗口