📄 frmtiankong.frm
字号:
End
Begin VB.CommandButton Command7
BackColor = &H00C0C0C0&
Caption = "修改(&M)"
Height = 375
Left = 5940
Style = 1 'Graphical
TabIndex = 8
Top = 210
Width = 795
End
Begin VB.CommandButton Command6
BackColor = &H00C0C0C0&
Caption = "添加(&X)"
Default = -1 'True
Height = 375
Left = 5160
Style = 1 'Graphical
TabIndex = 7
Top = 210
Width = 795
End
Begin VB.CommandButton Command5
BackColor = &H00C0C0C0&
Caption = "取消(&E)"
Enabled = 0 'False
Height = 375
Left = 4380
Style = 1 'Graphical
TabIndex = 6
Top = 210
Width = 795
End
Begin VB.CommandButton Command4
BackColor = &H00C0C0C0&
Caption = "更新(&U)"
Enabled = 0 'False
Height = 375
Left = 3600
Style = 1 'Graphical
TabIndex = 5
Top = 210
Width = 795
End
Begin MSAdodcLib.Adodc adodc1
Height = 375
Left = 3240
Top = 90
Visible = 0 'False
Width = 2325
_ExtentX = 4101
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = " 记录导航条"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
End
Begin VB.Frame Frame4
BackColor = &H00C0C0C0&
Caption = "难度(&H)"
Height = 885
Left = 8430
TabIndex = 19
Top = 360
Width = 1095
Begin VB.ComboBox Combo1
DataSource = "adodc1"
Height = 300
ItemData = "frmtiankong.frx":07C4
Left = 150
List = "frmtiankong.frx":07D4
Style = 2 'Dropdown List
TabIndex = 20
Top = 330
Width = 795
End
End
Begin VB.Frame Frame7
BackColor = &H00C0C0C0&
Height = 885
Left = 10560
TabIndex = 23
Top = 360
Width = 675
Begin VB.Label Label1
AutoSize = -1 'True
BackColor = &H00C0C0C0&
Caption = "加入每日提示"
ForeColor = &H00000000&
Height = 630
Left = 160
MousePointer = 99 'Custom
TabIndex = 24
Top = 210
Width = 450
WordWrap = -1 'True
End
End
Begin MSDataGridLib.DataGrid DataGrid1
Bindings = "frmtiankong.frx":07E4
Height = 3045
Left = 270
TabIndex = 29
TabStop = 0 'False
Top = 3510
Width = 10995
_ExtentX = 19394
_ExtentY = 5371
_Version = 393216
AllowUpdate = 0 'False
BackColor = 16777215
Enabled = -1 'True
HeadLines = 1
RowHeight = 15
FormatLocked = -1 'True
AllowDelete = -1 'True
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 = "neirong"
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 = "daan"
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
ScrollBars = 2
ScrollGroup = 2
BeginProperty Column00
Locked = -1 'True
ColumnWidth = 7409.764
EndProperty
BeginProperty Column01
ColumnWidth = 2954.835
EndProperty
EndProperty
End
Begin MSAdodcLib.Adodc Adodc3
Height = 330
Left = 9690
Top = 150
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = " 记录导航条"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
End
End
Attribute VB_Name = "frmtiankong"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public presskey As String
Private Sub Combo1_Click()
Dim frmcaption As String
presskey = "换表"
Dim linkku As String
linkku = "tiankongti" + Trim(Str(Combo1.ListIndex + 1))
adodc1.RecordSource = linkku
adodc1.Refresh
recordc = adodc1.Recordset.RecordCount
If Combo1.ListIndex > 1 Then
Frame3.Caption = "程序设计填空...难度" + Trim(Str(Combo1.ListIndex - 1))
Text7.DataField = "addneirong"
Else
Frame3.Caption = "基础填空...难度" + Trim(Str(Combo1.ListIndex + 1))
Text7.DataField = ""
End If
If recordc <> 0 Then
recordnum = 1
stats = "当前记录：" + Str(recordnum) + "/" + Str(recordc) + " 浏览状态"
Else
recordnum = 0
stats = "当前记录：BOF/EOF (空库，无记录)"
End If
fMainForm.sbStatusBar.Panels(1).Text = stats
End Sub
Private Sub Combo1_KeyPress(KeyAscii As Integer)
Combo1_Click
End Sub
Private Sub Command1_Click()
Dim spos, lens, textlen As Integer
Dim te As String
spos = Text3.SelStart
lens = Text3.SelLength
textlen = Len(Text3.Text)
Text3.Text = Mid(Text3.Text, 1, spos) + "_" + Mid(Text3.Text, spos + lens + 1, textlen - spos - lens + 1)
Text3.SetFocus
Text3.SelStart = spos + 1
End Sub
Private Sub Command10_Click()
If recordnum = recordc Then
MsgBox "己到记录尾", vbInformation, "查询"
Else
For i = recordnum + 1 To recordc
Command13_Click
lookfor
If find1 And find2 Then
Exit Sub
End If
If i = recordc Then
MsgBox "没有找到符合条件的记录！", vbInformation, "无此记录"
End If
Next i
End If
End Sub
Private Sub Command11_Click()
presskey = "移动"
If Text1.Text = "" Or recordc = 1 Then
Else
If recordc >= 1 Then
recordnum = 1
Else
recordnum = 0
End If
adodc1.Recordset.MoveFirst
End If
stats = "当前记录：" + Str(recordnum) + "/" + Str(recordc) + " 浏览状态"
fMainForm.sbStatusBar.Panels(1).Text = stats
End Sub
Private Sub Command12_Click()
presskey = "移动"
If Text1.Text = "" Or recordc = 1 Then
Else
recordnum = recordnum - 1
adodc1.Recordset.MovePrevious
If Text1.Text = "" Then
adodc1.Recordset.MoveNext
recordnum = recordnum + 1
End If
End If
stats = "当前记录：" + Str(recordnum) + "/" + Str(recordc) + " 浏览状态"
fMainForm.sbStatusBar.Panels(1).Text = stats
End Sub
Private Sub Command13_Click()
presskey = "移动"
If Text1.Text = "" Or recordc = 1 Then
Else
recordnum = recordnum + 1
adodc1.Recordset.MoveNext
If Text1.Text = "" Then
adodc1.Recordset.MovePrevious
recordnum = recordnum - 1
End If
End If
stats = "当前记录：" + Str(recordnum) + "/" + Str(recordc) + " 浏览状态"
fMainForm.sbStatusBar.Panels(1).Text = stats
End Sub
Private Sub Command14_Click()
presskey = "移动"
If Text1.Text = "" Or recordc = 1 Then
Else
recordnum = adodc1.Recordset.RecordCount
adodc1.Recordset.MoveLast
End If
stats = "当前记录：" + Str(recordnum) + "/" + Str(recordc) + " 浏览状态"
fMainForm.sbStatusBar.Panels(1).Text = stats
End Sub
Public Sub Command15_Click()
Dim biao As String
biao = "yxuanze" + Trim(Str(Combo1.ListIndex + 1))
Adodc3.RecordSource = biao
Adodc3.Refresh
Adodc2.RecordSource = "select * from " + biao + " where " + "neirong= '" + Text1.Text + "'"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -