set rs=dbs.openrecord("select password from pass")
if text1.text=表pass中password字段记录 (请问这里的代码怎么写) then
form1.hide
form2.show
end if
改成:
set rs=dbs.openrecord("select password from pass where password='" & text1.text & "'")
'RecordCount大于0表示有此密码在数据库中
if rs.RecordCount>0 then
form1.hide
form2.show
end if
if text1.text=表pass中password字段记录 (请问这里的代码怎么写) then
form1.hide
form2.show
end if
改成:
set rs=dbs.openrecord("select password from pass where password='" & text1.text & "'")
'RecordCount大于0表示有此密码在数据库中
if rs.RecordCount>0 then
form1.hide
form2.show
end if
解决方案 »
- vba(office 2003/2007) .ActiveChart.ApplyCustomType ChartType:
- 非模式窗体弹出模式窗体出错~
- listview排序列首的▲或▼的箭头图标
- 关于文件操作的面试题
- 调查一下:大家国庆过的怎样,有那些活动?
- InstallShield 6.30拿分(2)
- 下标越界
- VB 遇见流氓软件劫持IE首页 因无权限 无法修改..求大神给API
- Help~~~~ 如何截获windows消息 ????????????????????
- 如何让鼠标在某程序窗口前禁止右击操作
- 怎样从快捷方式文件中查出对应的源文件路径???
- 我是一个VB 实学者我想学做管理软件请哪个有正义感的人介绍一点好的杂志和书 [email protected] QQ:31844006
form2.enabled = ture
form2.show
else
unload.me
end if
dim dbs as database
dim rs as record
set dba=opendatabase("d:\data.mdb")
set rs=dbs.openrecord("select password from pass")
rs.movefirst
do while not rs.recordset.eof then
if text.text= rs("pssword") then
form1.hide
form2.show
exit do
end if
rs.movenext
loop
end sub
if text1.text=表pass中password字段记录 (请问这里的代码怎么写) then
form1.hide
form2.show
end if
改成:
set rs=dbs.openrecord("select password from pass where password='" & trim(text1.text) & "'")
if not rs.eof then
form1.hide
form2.show
end if