Hi all
Please help me to my problem, I built a vb application that i used on my projects.
my problem encounter is on access database from visual basic.
i have a code of
'search userID to see if it exists
[CODE=vb]
Data1.Recordset .MoveFirst
usercode = Data1.Recordset .Fields("UserID ").Value
Do Until found Or Data1.Recordset .EOF
usercode = Data1.Recordset .Fields("UserID ").Value
If usercode = txtUserName.Tex t Then
found = True
user_name = usercode
'MsgBox user_id
Exit Do
Else
Data1.Recordset .MoveNext
End If
Loop
[/CODE]
I have a error on the code "data1.recordse t.movefirst"
error "object variable or with block variable not set"
Please help me
Thanks
Jonjon
Please help me to my problem, I built a vb application that i used on my projects.
my problem encounter is on access database from visual basic.
i have a code of
'search userID to see if it exists
[CODE=vb]
Data1.Recordset .MoveFirst
usercode = Data1.Recordset .Fields("UserID ").Value
Do Until found Or Data1.Recordset .EOF
usercode = Data1.Recordset .Fields("UserID ").Value
If usercode = txtUserName.Tex t Then
found = True
user_name = usercode
'MsgBox user_id
Exit Do
Else
Data1.Recordset .MoveNext
End If
Loop
[/CODE]
I have a error on the code "data1.recordse t.movefirst"
error "object variable or with block variable not set"
Please help me
Thanks
Jonjon
Comment