seguridad.frm

Grafica por cordenadas basicas

VERSION 5.00
Object = "{75D4F767-8785-11D3-93AD-0000832EF44D}#3.1#0"; "FAST2001.ocx"
Begin VB.Form Seguridad 
   Caption         =   "Control de Usuarios"
   ClientHeight    =   1260
   ClientLeft      =   2460
   ClientTop       =   3450
   ClientWidth     =   5265
   Icon            =   "Seguridad.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   1260
   ScaleWidth      =   5265
   Begin FLWCtrls.FWButton cmdEntrar 
      Height          =   495
      Left            =   3480
      TabIndex        =   4
      Top             =   600
      Width           =   1575
      _ExtentX        =   2778
      _ExtentY        =   873
      ButtonType      =   3
      Caption         =   "Entrar"
   End
   Begin VB.TextBox txtUsuario 
      Height          =   285
      IMEMode         =   3  'DISABLE
      Left            =   1440
      TabIndex        =   0
      Top             =   120
      Width           =   2895
   End
   Begin VB.TextBox txtPassword 
      Height          =   285
      IMEMode         =   3  'DISABLE
      Left            =   1440
      PasswordChar    =   "*"
      TabIndex        =   1
      Top             =   600
      Width           =   1575
   End
   Begin VB.Label Label1 
      Caption         =   "Usuario:"
      BeginProperty Font 
         Name            =   "Palatino Linotype"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   240
      TabIndex        =   3
      Top             =   120
      Width           =   855
   End
   Begin VB.Label Label2 
      Caption         =   "Contrase馻:"
      BeginProperty Font 
         Name            =   "Palatino Linotype"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   240
      TabIndex        =   2
      Top             =   600
      Width           =   1095
   End
End
Attribute VB_Name = "Seguridad"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim bandera As Boolean
'Dim rUsuario As Recordset

Private Sub cmdEntrar_Click()
    Dim seleccion As String
    Dim rbuscar As New ADODB.Recordset
    seleccion = "select * from seguridad"
    Set rbuscar = CrearTabla(seleccion)
    Do While Not rbuscar.EOF
        If (rbuscar.Fields("Usuario").Value = txtUsuario.Text) And (rbuscar.Fields("Contrase馻").Value = txtPassword.Text) Then
            bandera = True
            VolveraMostrar = False
        End If
        rbuscar.MoveNext
    Loop
    If bandera = True Then
            Unload Me
            HabilitarBotones
    Else
            MsgBox "El Usuario y Contrase馻 no coinciden", vbInformation, "INFORMACION INCORRECTA"
            txtUsuario.Text = ""
            txtPassword.Text = ""
            txtUsuario.SetFocus
    End If
End Sub

Private Sub Form_Load()
    VolveraMostrar = False
End Sub

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
    Dim valor As String
    ' Unload Me
    Select Case UnloadMode
        Case 0
            valor = MsgBox("EL PROGRAMA SE CERRARA,