View Single Post
  #1 (permalink)  
Old December 19th, 2005, 03:50 AM
air_salak air_salak is offline
Registered User
 
Join Date: Dec 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Run-time Error: Type missmatch

Hi all,

I'm using Access 2002/XP for my MS Access simple dB project. I have a simple form and when I click on the button, it will trigger the codes below. However, I always receive this Message:

"Run-time error 13: Type Missmatch"


My coding:

Option Compare Database
Option Explicit
Dim dbs As Database
Dim rsUser As Recordset
Dim bolVerify As Boolean

strLogin = Me.txtLogin
strPsd = Me.txtPassword
Set dbs = CurrentDb
Set rsUser = New Recordset
Set rsUser = dbs.OpenRecordset("SELECT * from userlogin")

My userlogin table consist of few text fields. I don't know how to solve this problem. Please help me out. Thanks.
Reply With Quote