📄 frmcustomer.frm
字号:
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 12
Left = 4440
TabIndex = 28
Top = 720
Width = 960
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "ContactTitle:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00C00000&
Height = 210
Index = 3
Left = 120
TabIndex = 27
Top = 720
Width = 1035
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "ID No:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 4
Left = 2400
TabIndex = 26
Top = 720
Width = 570
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Customer ID:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 0
Left = 75
TabIndex = 25
Top = 120
Width = 1080
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "First Name:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 1
Left = 2025
TabIndex = 24
Top = 120
Width = 930
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Last Name:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 2
Left = 4455
TabIndex = 23
Top = 120
Width = 915
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Opening Balance"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 14
Left = 2760
TabIndex = 22
Top = 1440
Width = 1365
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Account Type:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 13
Left = 240
TabIndex = 21
Top = 1440
Width = 1170
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 5
Left = 3810
TabIndex = 20
Top = 1440
Width = 45
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Address:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 6
Left = 240
TabIndex = 19
Top = 2160
Width = 765
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "PostalCode:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 7
Left = 2040
TabIndex = 18
Top = 2160
Width = 990
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Town:"
BeginProperty Font
Name = "Arial"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00C00000&
Height = 210
Index = 8
Left = 5160
TabIndex = 17
Top = 2160
Width = 510
End
Begin VB.Label Label1
Caption = "Home phone"
BeginProperty Font
Name = "Arial Black"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00C00000&
Height = 255
Left = 360
TabIndex = 16
Top = 2760
Width = 1455
End
Begin VB.Label Label2
Caption = "Mobile"
BeginProperty Font
Name = "Arial Black"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00C00000&
Height = 255
Left = 2280
TabIndex = 15
Top = 2760
Width = 1575
End
Begin VB.Label Label3
Caption = "Email"
BeginProperty Font
Name = "Arial Black"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Index = 0
Left = 4440
TabIndex = 14
Top = 2760
Width = 1935
End
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Bindings = "frmcustomer.frx":0017
Height = 2775
Left = 120
TabIndex = 0
Top = 4440
Width = 11415
_ExtentX = 20135
_ExtentY = 4895
_Version = 393216
End
End
Attribute VB_Name = "frmcustomer"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdadd_Click(Index As Integer)
On Error Resume Next
Data1.Recordset.AddNew
End Sub
Private Sub cmddelete_Click(Index As Integer)
On Error Resume Next
If Data1.Recordset.EOF Then
Data1.Recordset.MoveLast
MsgBox "last record"
Else
If MsgBox("are you sure to delete this number", vbQuestion + vbOKCancel, "confirm delete....") = vbOK Then
Data1.Recordset.Delete
MsgBox ("seccesfuly Deleted")
End If
End If
Data1.Refresh
End Sub
Private Sub cmdedit_Click(Index As Integer)
On Error Resume Next
Data1.UpdateRecord
Data1.Recordset.Bookmark = Data1.Recordset.LastModified
MsgBox ("seccsifuly EDited")
Data1.Refresh
End Sub
Private Sub cmdsave_Click(Index As Integer)
On Error Resume Next
If MsgBox("are you sure to save this record", vbQuestion + vbYesNo, "Saving") = vbYes Then
Data1.Recordset.Update
MsgBox "Saving compeleted"
Data1.Refresh
End If
End Sub
Private Sub cmdSearch_Click(Index As Integer)
Data1.Recordset.FindFirst ("customerid = " + Text4.Text)
Data1.Recordset.FindFirst ("firstname = " + Text5.Text)
End Sub
Private Sub Command1_Click()
Data1.Refresh
End Sub
Private Sub Command2_Click()
Data1.Recordset.MoveNext
End Sub
Private Sub Command3_Click()
Data1.Recordset.MovePrevious
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -