pooldata.frm

Call centeer gestion de usuarios todo ello gratis y bajo windows

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form PoolData 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "Update Pool"
   ClientHeight    =   2895
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   5925
   Icon            =   "PoolData.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2895
   ScaleWidth      =   5925
   StartUpPosition =   2  'CenterScreen
   Begin VB.TextBox data 
      Alignment       =   2  'Center
      BackColor       =   &H00FFC0C0&
      BeginProperty Font 
         Name            =   "Century Gothic"
         Size            =   9
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   405
      Index           =   2
      Left            =   1680
      MaxLength       =   8
      TabIndex        =   5
      Top             =   1080
      Width           =   3735
   End
   Begin VB.TextBox data 
      Alignment       =   2  'Center
      BackColor       =   &H00FFC0C0&
      BeginProperty Font 
         Name            =   "Century Gothic"
         Size            =   9
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   405
      Index           =   1
      Left            =   1680
      TabIndex        =   4
      Top             =   600
      Width           =   3735
   End
   Begin MSComctlLib.Toolbar Toolbar1 
      Height          =   570
      Left            =   1920
      TabIndex        =   3
      Top             =   1800
      Width           =   2490
      _ExtentX        =   4392
      _ExtentY        =   1005
      ButtonWidth     =   2064
      ButtonHeight    =   1005
      Appearance      =   1
      Style           =   1
      TextAlignment   =   1
      ImageList       =   "ImageList1"
      _Version        =   393216
      BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
         NumButtons      =   3
         BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "Cancel"
            Key             =   "Cancel"
            ImageIndex      =   1
         EndProperty
         BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "Update"
            Key             =   "Update"
            ImageIndex      =   2
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   600
      Top             =   1800
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   32
      ImageHeight     =   32
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   2
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "PoolData.frx":0BC2
            Key             =   ""
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "PoolData.frx":1014
            Key             =   ""
         EndProperty
      EndProperty
   End
   Begin VB.TextBox data 
      Alignment       =   2  'Center
      BackColor       =   &H00FFC0C0&
      BeginProperty Font 
         Name            =   "Century Gothic"
         Size            =   9
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   405
      Index           =   0
      Left            =   1680
      TabIndex        =   2
      Top             =   3360
      Width           =   855
   End
   Begin VB.Label Label2 
      Caption         =   "Price"
      BeginProperty Font 
         Name            =   "Century Gothic"
         Size            =   9
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   480
      TabIndex        =   1
      Top             =   1080
      Width           =   1935
   End
   Begin VB.Label Label1 
      Caption         =   "Description"
      BeginProperty Font 
         Name            =   "Century Gothic"
         Size            =   9
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   480
      TabIndex        =   0
      Top             =   600
      Width           =   1935
   End
   Begin VB.Shape Shape1 
      BackColor       =   &H8000000F&
      BackStyle       =   1  'Opaque
      BorderColor     =   &H00FF8080&
      BorderWidth     =   7
      Height          =   2415
      Left            =   240
      Top             =   240
      Width           =   5415
   End
End
Attribute VB_Name = "PoolData"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.key
'=======
Case "Cancel"
Unload Me
'=======
Case "Update"
'On Error GoTo r
Dim p As Integer
p = 0
If data(1) = "" Then
MsgBox "Please enter the pool description...", vbInformation, "HMS"
data(1).SetFocus
Exit Sub
ElseIf data(2) = "" Then
MsgBox "Please enter the pool price...", vbInformation, "HMS"
data(2).SetFocus
Exit Sub
End If

If data(2) <> "" Then
  If Not IsNumeric(data(2).Text) Then
      MsgBox "The pool price you entered is invalid...", vbInformation, "HMS"
      data(2).SetFocus
      Exit Sub
   End If
End If
'================
If frmOthers2.ron = "add" Then
check_RStemp
rstemp.Open "select * from swimmingpool", Cnn
'================
While rstemp.RecordCount > 0
check_RStemp
p = p + 1
rstemp.Open "select * from swimmingpool where swimmingpool_no = " & p, Cnn
Wend
'================
Cnn.Execute "INSERT INTO swimmingpool (swimmingpool_no,description,price) VALUES (" & p & ", '" & data(1).Text & "', '" & data(2).Text & "')" '
'================
ElseIf frmOthers2.ron = "edit" Then
Cnn.Execute "update swimmingpool set description = '" & data(1) & "', price = '" & data(2) & "' where swimmingpool_no = " & data(0)
End If
rs.Requery 1
frmOthers2.fillPool
Unload Me
'r:
'=======
End Select

End Sub