📄 student_frm.frm
字号:
Left = -74880
TabIndex = 12
Top = 600
Width = 7530
Begin MSMask.MaskEdBox masktel
Height = 300
Left = 3240
TabIndex = 64
Top = 840
Width = 1575
_ExtentX = 2778
_ExtentY = 529
_Version = 393216
MaxLength = 14
Mask = "(####)########"
PromptChar = "_"
End
Begin VB.Frame Frame6
Height = 615
Left = 1200
TabIndex = 43
Top = 1200
Width = 3495
Begin VB.ComboBox cboyear
Height = 300
Left = 120
TabIndex = 60
Text = "Combo3"
Top = 200
Width = 735
End
Begin VB.ComboBox cbomonth
Height = 300
Left = 1200
TabIndex = 48
Text = "Combo4"
Top = 200
Width = 735
End
Begin VB.ComboBox cboDay
Height = 300
Left = 2280
TabIndex = 44
Text = "cboDay"
Top = 200
Width = 612
End
Begin VB.Label Label1
Caption = "月"
Height = 216
Index = 2
Left = 2040
TabIndex = 47
Top = 240
Width = 240
End
Begin VB.Label Label1
Caption = "年"
Height = 210
Index = 1
Left = 960
TabIndex = 46
Top = 240
Width = 240
End
Begin VB.Label Label1
Caption = "日"
Height = 210
Index = 7
Left = 3000
TabIndex = 45
Top = 240
Width = 240
End
End
Begin MSComDlg.CommonDialog CommonDialog1
Left = 4800
Top = 1080
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.TextBox Text5
Height = 270
Left = 4920
TabIndex = 27
Text = "Text5"
Top = 840
Visible = 0 'False
Width = 1455
End
Begin VB.TextBox Text4
Height = 270
Left = 4800
TabIndex = 26
Text = "Text4"
Top = 360
Visible = 0 'False
Width = 1095
End
Begin VB.TextBox Text2
Height = 270
Left = 3240
TabIndex = 25
Text = "Text2"
Top = 360
Width = 1335
End
Begin VB.TextBox Text1
Height = 270
Left = 1200
TabIndex = 24
Text = "Text1"
Top = 360
Width = 1095
End
Begin VB.TextBox Text6
Height = 270
Left = 1200
TabIndex = 14
Text = "Text6"
Top = 2040
Width = 3975
End
Begin VB.ComboBox Combo1
Height = 300
Left = 1200
TabIndex = 13
Text = "Combo1"
Top = 840
Width = 1170
End
Begin RichTextLib.RichTextBox RichTextBox1
Height = 975
Left = 1200
TabIndex = 15
Top = 2520
Width = 3975
_ExtentX = 7011
_ExtentY = 1720
_Version = 393217
Enabled = -1 'True
TextRTF = $"student_frm.frx":54F47
End
Begin VB.Image Image1
Height = 2775
Left = 5400
Stretch = -1 'True
Top = 360
Width = 2055
End
Begin VB.Label Label8
Caption = "电话："
Height = 255
Left = 2520
TabIndex = 23
Top = 840
Width = 615
End
Begin VB.Label Label7
Caption = "照片:"
Height = 255
Left = 4800
TabIndex = 22
Top = 360
Width = 615
End
Begin VB.Label Label6
Caption = "备注:"
Height = 255
Left = 240
TabIndex = 21
Top = 2520
Width = 615
End
Begin VB.Label Label5
Caption = "家庭地址："
Height = 255
Left = 240
TabIndex = 20
Top = 2040
Width = 975
End
Begin VB.Label Label4
Caption = "出生年月："
Height = 255
Left = 240
TabIndex = 19
Top = 1440
Width = 1005
End
Begin VB.Label Label3
Caption = "性别："
Height = 255
Left = 240
TabIndex = 18
Top = 840
Width = 675
End
Begin VB.Label Label2
Caption = "姓名："
Height = 255
Left = 2520
TabIndex = 17
Top = 360
Width = 765
End
Begin VB.Label Label1
Caption = "学号："
Height = 255
Index = 0
Left = 240
TabIndex = 16
Top = 345
Width = 720
End
End
Begin VB.Frame Frame3
Caption = "编辑"
Height = 828
Left = -73560
TabIndex = 7
Top = 4440
Width = 5175
Begin VB.CommandButton cmdexit
Caption = "退出"
Height = 420
Left = 3840
TabIndex = 11
Top = 240
Width = 1065
End
Begin VB.CommandButton cmdsave
Caption = "保存"
Height = 420
Left = 2640
TabIndex = 10
Top = 240
Width = 1065
End
Begin VB.CommandButton cmdcancel
Caption = "取消"
Height = 420
Left = 1440
TabIndex = 9
Top = 240
Width = 1065
End
Begin VB.CommandButton cmdadd
Caption = "添加"
Height = 420
Left = 240
TabIndex = 8
Top = 240
Width = 1065
End
End
Begin VB.Frame Frame4
Caption = "编辑"
Height = 828
Left = 1440
TabIndex = 2
Top = 4440
Width = 5055
Begin VB.CommandButton Command6
Caption = "退出"
Height = 420
Left = 3840
TabIndex = 6
Top = 240
Width = 1065
End
Begin VB.CommandButton Command4
Caption = "删除"
Height = 420
Left = 2640
TabIndex = 5
Top = 240
Width = 1065
End
Begin VB.CommandButton Command3
BackColor = &H80000008&
Caption = "修改"
Height = 420
Left = 1440
MaskColor = &H00FF0000&
TabIndex = 4
Top = 240
Width = 1065
End
Begin VB.CommandButton Command1
BackColor = &H8000000D&
Caption = "添加"
Height = 420
Left = 240
MaskColor = &H00FF0000&
TabIndex = 3
Top = 240
Width = 1065
End
End
Begin MSDataGridLib.DataGrid DataGrid1
Bindings = "student_frm.frx":54FD6
Height = 3735
Left = 120
TabIndex = 1
Top = 600
Width = 7815
_ExtentX = 13785
_ExtentY = 6588
_Version = 393216
AllowUpdate = 0 'False
DefColWidth = 57
ForeColor = -2147483641
HeadLines = 1
RowHeight = 15
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 2
BeginProperty Column00
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
EndProperty
BeginProperty Column01
EndProperty
EndProperty
End
End
End
Attribute VB_Name = "student_frm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
'Dim rs As New ADODB.Recordset
Dim cmd As New ADODB.Command
Dim SaveUpdate_flag As Boolean
Dim strQuery As String '查询内容
Dim strQuery2 As String
Dim strField As String '查询字段
Dim isEdit As Boolean
Private Sub Disable_proc()
Dim ctl As Control '控件对象变量
For Each ctl In Controls
If TypeOf ctl Is TextBox Or TypeOf ctl Is RichTextBox Or TypeOf ctl Is ComboBox Then
ctl.Enabled = False
End If
Next ctl
End Sub
Private Sub Enable_proc()
Dim ctl As Control '控件对象变量
For Each ctl In Controls
If TypeOf ctl Is TextBox Or TypeOf ctl Is RichTextBox Or TypeOf ctl Is ComboBox Then
ctl.Enabled = True
End If
Next ctl
End Sub
Private Sub ShowClear()
Text1.Text = Empty
Text2.Text = Empty
Text4.Text = Empty
Text5.Text = Empty
Text6.Text = Empty
RichTextBox1.Text = Empty
Image1.Picture = LoadPicture("")
End Sub
Public Sub Refresh_data()
Adodc1.RecordSource = "SELECT sno As 学号,sname As 姓名, Sex As 性别, " & _
"birth As 出生年月, tel As 电话,address As 家庭地址, " & _
"m As 备注,photo " & _
"FROM studentinfo ORDER BY sno"
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1.Recordset
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub cmdque_Click()
Dim rs As New ADODB.Recordset
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -