这样试试
Private Sub cmdOK_Click()
username = txtUserName.Text
password = txtPassword.Text
Set cn = New Connection
Set rs = New Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=‘F:\db\用户列表.mdb’"
rs.Open "select * from 用户列表 where 用户名='" & username & "'", cn
Private Sub cmdOK_Click()
username = txtUserName.Text
password = txtPassword.Text
Set cn = New Connection
Set rs = New Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=‘F:\db\用户列表.mdb’"
rs.Open "select * from 用户列表 where 用户名='" & username & "'", cn
username = txtUserName.Text
password = txtPassword.Text
Set cn = New Connection
Set rs = New Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\db\用户列表.mdb"
rs.Open "select * from 用户列表 where 用户名='" & username & "'", cn格式一般为:select * from table where pamar='" & string & "'"
如果参数属于整数类型就可以写为:select * from table where pamar=" & PamarInteger
rs.Open "select * from 用户列表 where 用户名='" & username & "'", cn
可还是不行阿,提示:语法错误(操作符丢失)在查询表达式‘用户名=’“中
这是怎么回事阿,高人救我
则提示说:至少一个参数没有被指定值
也是不行啊,求解
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Private Sub cmdOK_Click()
if adodc1.recordset("passwd")=textbox.text then
"你向显示的窗口".enabled = ture
"你向显示的窗口".show
else
msagebox "密码错误,请从新输入"end if
end sub
Private Sub Command1_Click()
If Text1.Text = rs.fields("你要比较的字段名") Then
MsgBox "可以进入下一页", vbInformation
Else
MsgBox "游客止步", vbInformation
End If
End Sub
'会不会是中文字段名的问题呢?
to pinktime 当然定义过了,不会这么弱者啦