geovannefarell

Login

Nov 13th, 2012
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Private Sub cmdExit_Click()
  2.     End
  3. End Sub
  4.  
  5. Private Sub cmdOK_Click()
  6. Call Koneksi
  7.     If txtNama.Text = "" Then
  8.         MsgBox "NAMA USER MASIH KOSONG !", vbCritical + vbOKOnly, "Error"
  9.         txtNama.SetFocus
  10.     ElseIf txtPassword.Text = "" Then
  11.         MsgBox "PASSWORD MASIH KOSONG !", vbCritical + vbOKOnly, "Error"
  12.         txtPassword.SetFocus
  13.     Else
  14.         SQL = ""
  15.         SQL = "SELECT * FROM user " _
  16.             & "WHERE Nama='" & txtNama.Text & "' " _
  17.             & " AND Password='" & txtPassword.Text & "'"
  18.             Set rsPeriksa = conn.Execute(SQL)
  19.                    
  20.         If Not rsPeriksa.BOF Then
  21.             Unload Me
  22.             frmUtama.Show
  23.         Else
  24.                 MsgBox "ANDA BUKAN USER YANG BERHAK!", vbCritical + vbOKOnly, "Error"
  25.         End If
  26.     End If
  27. End Sub
Advertisement
Add Comment
Please, Sign In to add comment