By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,632 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,632 IT Pros & Developers. It's quick & easy.

Run Time Error "91"

P: 3
how can i solve tis prob ?


Do Until Adodc1.Recordset.EOF Or login = True
If user = Adodc1.Recordset![StaffLoginName] And
pass =Adodc1.Recordset![StaffPassword] Then
Me.Hide
Form1.Show
login = True
End If
Adodc1.Recordset.MoveNext
Loop

its say object variabel and with block not set!!!
anyone can help me pls ?
Mar 24 '07 #1
Share this Question
Share on Google+
1 Reply


vijaydiwakar
100+
P: 579
how can i solve tis prob ?


Do Until Adodc1.Recordset.EOF Or login = True
If user = Adodc1.Recordset![StaffLoginName] And
pass =Adodc1.Recordset![StaffPassword] Then
Me.Hide
Form1.Show
login = True
End If
Adodc1.Recordset.MoveNext
Loop

its say object variabel and with block not set!!!
anyone can help me pls ?
if u have coded in the same way then
its wrong
try this
Expand|Select|Wrap|Line Numbers
  1. Do Until Adodc1.Recordset.EOF Or login = True
  2. If user = Adodc1.Recordset![StaffLoginName] And _
  3. pass =Adodc1.Recordset![StaffPassword] Then
  4. Me.Hide
  5. Form1.Show
  6. login = True
  7. End If
  8. Adodc1.Recordset.MoveNext
  9. Loop
  10.  
  11.  
check ur defination for user and pass
try it
Good Luck
Mar 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.