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

Popular posts from this blog