frm_acc_del.frm

codding for pszone one can use it at playstation zones

VERSION 5.00
Begin VB.Form frmaccdelete 
   BackColor       =   &H00000040&
   Caption         =   "Delete Account..."
   ClientHeight    =   1785
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   6570
   ForeColor       =   &H8000000E&
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   1785
   ScaleWidth      =   6570
   Begin VB.CommandButton Command2 
      Caption         =   "Back"
      Height          =   315
      Left            =   4260
      TabIndex        =   5
      Top             =   840
      Width           =   1395
   End
   Begin VB.CommandButton Command1 
      Caption         =   "Delete"
      Height          =   315
      Left            =   4260
      TabIndex        =   4
      Top             =   300
      Width           =   1395
   End
   Begin VB.TextBox Text2 
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   285
      Left            =   2220
      TabIndex        =   2
      Top             =   840
      Width           =   1815
   End
   Begin VB.TextBox Text1 
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   285
      Left            =   2220
      TabIndex        =   0
      Top             =   300
      Width           =   1815
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      BackColor       =   &H00000040&
      Caption         =   "Verification name:-"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00C0C0C0&
      Height          =   240
      Left            =   240
      TabIndex        =   3
      Top             =   900
      Width           =   1950
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackColor       =   &H00000040&
      Caption         =   "Enter Code no:-"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00C0C0C0&
      Height          =   240
      Left            =   540
      TabIndex        =   1
      Top             =   360
      Width           =   1620
   End
End
Attribute VB_Name = "frmaccdelete"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False


Private Sub Command1_Click()
    Set RECS = New ADODB.Recordset
    RECS.Open "SELECT * FROM PSZONE_MEMBERS WHERE CUSTOMER_NO = '" & Text1.Text & "'", ADO, adOpenDynamic, adLockOptimistic
    Text1.Text = RECS!CUSTOMER_NO
    Text2.Text = RECS!Name
    yy = MsgBox("are u sure u wanna delete recs of " & Text2.Text & " ???")
    If yy = vbYes Then
    RECS.Delete
    RECS.Update
    End If
End Sub

Private Sub Command2_Click()
    Unload Me
End Sub

Private Sub Form_ACTIVATE()
    Set ADO = New ADODB.Connection
    Set RS = New ADODB.Recordset
    ADO.CursorLocation = adUseClient
    ADO.ConnectionString = "provider = MSDAORA; user id =SCOTT; password =TIGER;"
    ADO.Open
    RS.Open "PSZONE_MEMBERS", ADO, adOpenDynamic, adLockOptimistic, adCmdTable
End Sub