1 Replies - 4145 Views - Last Post: 31 August 2012 - 04:00 PM Rate Topic: -----

#1 thefifthhjohn  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 13-July 12

arguments are of the wrong type

Posted 20 August 2012 - 07:46 PM

hi I'm having arguments are of the wrong type I'm having errors in rs.Open "SELECT * FROM [tbladmin] WHERE [username] = '" & txtUsername.Text & "' AND [password] = '" & txtPassword.Text & "'", con, adOpenStatic, adLockOptimistic
Dim con As New ADODB.Command
Dim rs As New ADODB.Recordset

Private Sub cmdlogin_Click()
OpenCon
rs.Open "SELECT * FROM [tbladmin] WHERE [username] = '" & txtUsername.Text & "' AND [password] = '" & txtPassword.Text & "'", con, adOpenStatic, adLockOptimistic
If rs.RecordCount <> 0 Then
MsgBox "the user has login", vbOKOnly + vbInformation, "LOGIN"
frmadmin.Show
ElseIf rs.RecordCount <> 1 Then
MsgBox "please re-enter your username/password"
End If
End Sub



Is This A Good Question/Topic? 0
  • +

Replies To: arguments are of the wrong type

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: arguments are of the wrong type

Posted 31 August 2012 - 04:00 PM

The reason that you're not getting any responses is because you haven't explained your problem clearly enough. Please go into a bit more detail.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1