Digital life
VERSION 5.00
Object = "{C932BA88-4374-101B-A56C-00AA003668DC}#1.1#0"; "MSMASK32.OCX"
Begin VB.Form FrmConf
Caption = "CONFORMATION FORM"
ClientHeight = 7065
ClientLeft = 60
ClientTop = 510
ClientWidth = 8820
HelpContextID = 1
LinkTopic = "Form4"
MDIChild = -1 'True
ScaleHeight = 7065
ScaleWidth = 8820
WindowState = 2 'Maximized
Begin VB.ComboBox Combo1
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Left = 3960
TabIndex = 1
Top = 960
Width = 2655
End
Begin VB.Frame Frame2
Caption = "MANIPULATION"
Height = 975
Left = 240
TabIndex = 19
Top = 5160
Width = 8295
Begin VB.CommandButton cmdsea
Caption = "&Search"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 5520
TabIndex = 26
Top = 360
Width = 1215
End
Begin VB.CommandButton command5
Caption = "&Cancel"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 6840
TabIndex = 24
Top = 360
Width = 1215
End
Begin VB.CommandButton cmdDel
Caption = "&Delete"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 4200
TabIndex = 23
Top = 360
Width = 1215
End
Begin VB.CommandButton cmdMod
Caption = "&Modify"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 2880
TabIndex = 22
Top = 360
Width = 1215
End
Begin VB.CommandButton cmdSave
Caption = "&Save"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 1560
TabIndex = 21
Top = 360
Width = 1215
End
Begin VB.CommandButton cmdNew
Caption = "New"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 240
TabIndex = 20
Top = 360
Width = 1215
End
End
Begin VB.CommandButton Command7
Caption = "&BACK"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 3720
TabIndex = 18
Top = 6360
Width = 1215
End
Begin VB.TextBox Text5
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3960
ScrollBars = 1 'Horizontal
TabIndex = 0
Text = " "
Top = 360
Width = 2655
End
Begin VB.Frame Frame1
Caption = "NAVIGATION"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 3615
Left = 7080
TabIndex = 17
Top = 480
Width = 1575
Begin VB.CommandButton Command4
Caption = "&Last"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 120
TabIndex = 10
Top = 2880
Width = 1215
End
Begin VB.CommandButton Command3
Caption = "&Previous"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 120
TabIndex = 9
Top = 2040
Width = 1215
End
Begin VB.CommandButton Command2
Caption = "&Next"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 120
TabIndex = 8
Top = 1200
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "&First"
BeginProperty Font
Name = "@Arial Unicode MS"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 120
TabIndex = 7
Top = 360
Width = 1215
End
End
Begin VB.TextBox Text4
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3960
TabIndex = 4
Text = " "
Top = 3000
Width = 2655
End
Begin VB.TextBox Text3
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3960
TabIndex = 6
Text = " "
Top = 4320
Width = 2655
End
Begin MSMask.MaskEdBox MaskEdBox1
Height = 375
Left = 3960
TabIndex = 5
Top = 3600
Width = 2655
_ExtentX = 4683
_ExtentY = 661
_Version = 393216
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "##/##/####"
PromptChar = "_"
End
Begin VB.TextBox Text2
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3960
TabIndex = 3
Text = " "
Top = 2280
Width = 2655
End
Begin VB.TextBox Text1
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3960
TabIndex = 2
Text = " "
Top = 1560
Width = 2655
End
Begin VB.ComboBox Combo2
Height = 315
Left = 3960
TabIndex = 27
Text = " "
Top = 960
Width = 2655
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "Customer name"
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 480
TabIndex = 25
Top = 960
Width = 1410
End
Begin VB.Label Label7
AutoSize = -1 'True
Caption = "Designation of Employee"
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 480
TabIndex = 16
Top = 3120
Width = 2310
End
Begin VB.Label Label6
AutoSize = -1 'True
Caption = "Name of Employee"
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 480
TabIndex = 15
Top = 240
Width = 1770
End
Begin VB.Label Label5
AutoSize = -1 'True
Caption = "Place"
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 480
TabIndex = 14
Top = 4440
Width = 480
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "Date"
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 480
TabIndex = 13
Top = 3840
Width = 435
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "BO ID Alloted To the Client"
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 480
TabIndex = 12
Top = 2280
Width = 2745
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "UCC Code Alloted To the Client"
BeginProperty Font
Name = "Comic Sans MS"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 480
TabIndex = 11
Top = 1680
Width = 3075
End
End
Attribute VB_Name = "FrmConf"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdDel_Click()
a = MsgBox("Are u sure u want to delete?", vbYesNo)
If a = vbYes Then
RS3.Delete
RS3.Update
MsgBox "Data deleted"
Else
MsgBox "Data not deleted"
End If
End Sub
Private Sub cmdMod_Click()
a = MsgBox("want to update?", vbYesNo)
If a = vbYes Then
RS3.Update
Call accept4
MsgBox "Record updated"
Call Cancel
Else
MsgBox "Record not updated"
Call Cancel
End If
End Sub
Private Sub cmdNew_Click()
Call Cancel
Text5.SetFocus
End Sub
Private Sub cmdsave_Click()
a = MsgBox("do u want to save?", vbYesNo)
If a = vbYes Then
RS3.AddNew
Call accept4
RS3.Update
MsgBox "Data submitted"
Call Cancel
Text5.SetFocus
Else
MsgBox "Data not saved"
Call Cancel
Combo1.SetFocus
End If
End Sub
Private Sub cmdsea_Click()
Combo1.Visible = False
Combo2.Visible = True
Dim rs5 As New ADODB.Recordset
sql = "select cname from cofacc"
rs5.Open sql, cn, adOpenDynamic, adLockOptimistic
Do While Not rs5.EOF
Combo2.AddItem rs5!cname
rs5.MoveNext
Loop
rs5.Close
End Sub
Private Sub Combo2_Click()
Set rs5 = New ADODB.Recordset
sql = "select * from cofacc where cname='" & Trim(Combo2.Text) & "'"
rs5.Open sql, cn, adOpenDynamic, adLockOptimistic
Do While Not rs5.EOF
Call show4
rs5.MoveNext
Loop
rs5.Close
Combo1.Visible = True
Combo2.Visible = False
End Sub
Private Sub Combo1_Click()
RS3.MoveFirst
Do While Not RS3.EOF = True
If (RS3.Fields("cname") = Trim(Combo1.Text)) Then
MsgBox "code already submitted"
flag = 1
Call Cancel
Exit Sub
Else
RS3.MoveNext
flag = 0
End If
Loop
End Sub
Private Sub Command1_Click()
RS3.MoveFirst
Call show4
End Sub
Private Sub Command2_Click()
RS3.MoveNext
If RS3.EOF Then
MsgBox "this is last record"
RS3.MoveLast
Else
Call show4
End If
End Sub
Public Sub accept4()
RS3.Fields(0) = Text5.Text
RS3.Fields(1) = Combo1.Text
RS3.Fields(2) = Text1.Text
RS3.Fields(3) = Text2.Text
RS3.Fields(4) = Text4.Text
RS3.Fields(5) = MaskEdBox1
RS3.Fields(6) = Text3.Text
End Sub
Public Sub show4()
Text5.Text = RS3("ename")
Combo1.Text = RS3("cname")
Text1.Text = RS3("ucccode")
Text2.Text = RS3("BOID")
Text4.Text = RS3("desig")
'MaskEdBox1.Text = RS3("cdate")'
Text3.Text = RS3("place")
End Sub
Public Sub Cancel()
Text5.SetFocus
Combo1.Text = " "
Text5.Text = ""
Text1.Text = ""
Text2.Text = ""
Text4.Text = " "
Text3.Text = " "
End Sub
Private Sub Command3_Click()
RS3.MovePrevious
If RS3.BOF Then
MsgBox "this is first record"
RS3.MoveFirst
Else
Call show4
End If
End Sub
Private Sub Command4_Click()
RS3.MoveLast
Call show4
End Sub
Private Sub Command5_Click()
Call Cancel
End Sub
Private Sub Command7_Click()
Unload Me
End Sub
Private Sub Form_Load()
Combo2.Visible = False
Call connectdb
RS1.Close
RS2.Close
RS3.Close
rs.Close
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\stockexchan\customerinfo.mdb;Persist Security Info=False"
rs.Open "customer", db, 1, 3
While (rs.EOF = False)
Combo1.AddItem rs.Fields("fnAME")
rs.MoveNext
Wend
rs.Close
db.Close
RS3.Open
End Sub
Private Sub Form_Unload(Cancel As Integer)
RS3.Close
End Sub
Comments
Post a Comment