?? frmkaishidati.frm
字號:
Width = 1215
End
Begin VB.Label Label21
AutoSize = -1 'True
Caption = "6."
Height = 180
Left = 480
TabIndex = 34
Top = 960
Width = 180
End
Begin VB.Label Label20
AutoSize = -1 'True
Caption = "7."
Height = 180
Left = 2040
TabIndex = 33
Top = 960
Width = 180
End
Begin VB.Label Label19
AutoSize = -1 'True
Caption = "8."
Height = 180
Left = 3600
TabIndex = 32
Top = 960
Width = 180
End
Begin VB.Label Label18
AutoSize = -1 'True
Caption = "9."
Height = 180
Left = 5160
TabIndex = 31
Top = 960
Width = 180
End
Begin VB.Label Label17
AutoSize = -1 'True
Caption = "10."
Height = 180
Left = 6720
TabIndex = 30
Top = 960
Width = 270
End
Begin VB.Label Label16
AutoSize = -1 'True
Caption = "5."
Height = 180
Left = 6720
TabIndex = 29
Top = 360
Width = 180
End
Begin VB.Label Label15
AutoSize = -1 'True
Caption = "4."
Height = 180
Left = 5160
TabIndex = 28
Top = 360
Width = 180
End
Begin VB.Label Label14
AutoSize = -1 'True
Caption = "3."
Height = 180
Left = 3600
TabIndex = 27
Top = 360
Width = 180
End
Begin VB.Label Label13
AutoSize = -1 'True
Caption = "2."
Height = 180
Left = 2040
TabIndex = 26
Top = 360
Width = 180
End
Begin VB.Label Label12
AutoSize = -1 'True
Caption = "1."
Height = 180
Left = 480
TabIndex = 25
Top = 360
Width = 180
End
End
Begin VB.Frame Frame2
Caption = "選擇題"
Height = 1455
Left = 120
TabIndex = 3
Top = 360
Width = 8775
Begin VB.TextBox Text10
Height = 270
Left = 6960
TabIndex = 24
Top = 960
Width = 1215
End
Begin VB.TextBox Text9
Height = 270
Left = 5400
TabIndex = 23
Top = 960
Width = 1215
End
Begin VB.TextBox Text8
Height = 270
Left = 3840
TabIndex = 22
Top = 960
Width = 1215
End
Begin VB.TextBox Text7
Height = 270
Left = 2280
TabIndex = 21
Top = 960
Width = 1215
End
Begin VB.TextBox Text6
Height = 270
Left = 720
TabIndex = 20
Top = 960
Width = 1215
End
Begin VB.TextBox Text5
Height = 270
Left = 6960
TabIndex = 14
Top = 360
Width = 1215
End
Begin VB.TextBox Text4
Height = 270
Left = 5400
TabIndex = 13
Top = 360
Width = 1215
End
Begin VB.TextBox Text3
Height = 270
Left = 3840
TabIndex = 12
Top = 360
Width = 1215
End
Begin VB.TextBox Text2
Height = 270
Left = 2280
TabIndex = 11
Top = 360
Width = 1215
End
Begin VB.TextBox Text1
Height = 270
Left = 720
TabIndex = 10
Top = 360
Width = 1215
End
Begin VB.Label Label11
AutoSize = -1 'True
Caption = "10."
Height = 180
Left = 6720
TabIndex = 19
Top = 960
Width = 270
End
Begin VB.Label Label10
AutoSize = -1 'True
Caption = "9."
Height = 180
Left = 5160
TabIndex = 18
Top = 960
Width = 180
End
Begin VB.Label Label9
AutoSize = -1 'True
Caption = "8."
Height = 180
Left = 3600
TabIndex = 17
Top = 960
Width = 180
End
Begin VB.Label Label8
AutoSize = -1 'True
Caption = "7."
Height = 180
Left = 2040
TabIndex = 16
Top = 960
Width = 180
End
Begin VB.Label Label7
AutoSize = -1 'True
Caption = "6."
Height = 180
Left = 480
TabIndex = 15
Top = 960
Width = 180
End
Begin VB.Label Label6
AutoSize = -1 'True
Caption = "5."
Height = 180
Left = 6720
TabIndex = 9
Top = 360
Width = 180
End
Begin VB.Label Label5
AutoSize = -1 'True
Caption = "4."
Height = 180
Left = 5160
TabIndex = 8
Top = 360
Width = 180
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "3."
Height = 180
Left = 3600
TabIndex = 7
Top = 360
Width = 180
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "2."
Height = 180
Left = 2040
TabIndex = 6
Top = 360
Width = 180
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "1."
Height = 180
Left = 480
TabIndex = 5
Top = 360
Width = 180
End
End
End
Begin VB.CommandButton Command1
Caption = "確認提交答題卡"
Height = 735
Left = 120
TabIndex = 0
Top = 8160
Width = 9015
End
Begin VB.Label Label47
AutoSize = -1 'True
Caption = "試卷號："
Height = 180
Left = 6720
TabIndex = 71
Top = 960
Width = 720
End
Begin VB.Label Label46
AutoSize = -1 'True
Caption = "考場號："
Height = 180
Left = 3480
TabIndex = 70
Top = 960
Width = 720
End
Begin VB.Label Label45
AutoSize = -1 'True
Caption = "學號："
Height = 180
Left = 600
TabIndex = 69
Top = 960
Width = 540
End
Begin VB.Label Label44
AutoSize = -1 'True
Caption = "試卷號"
Height = 180
Left = 7440
TabIndex = 68
Top = 960
Width = 540
End
Begin VB.Label Label43
AutoSize = -1 'True
Caption = "考場號"
Height = 180
Left = 4200
TabIndex = 67
Top = 960
Width = 540
End
Begin VB.Label Label42
AutoSize = -1 'True
Caption = "學號"
Height = 180
Left = 1200
TabIndex = 66
Top = 960
Width = 360
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "請認真填寫本答題卡："
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 210
Left = 3360
TabIndex = 1
Top = 240
Width = 2250
End
End
Attribute VB_Name = "frmkaishidati"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Public kaofen As String
Public Sub Command1_Click()
Randomize
kaofen = Int(Rnd * 100) + 1
Dim conn As New ADODB.Connection
conn.CursorLocation = adUseClient
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Roso;Data Source=(local)"
conn.Open
conn.Execute "insert into kaojuan (考分,考場號,考卷,考題1,考題2,考題3,考題4,考題5,考題6,考題7,考題8,考題9,考題10,考題11,考題12,考題13,考題14,考題15,考題16,考題17,考題18,考題19,考題20) values ('" & Label42.Caption & "','" & Label43.Caption & "','" & Label44.Caption & "','" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "','" & Text6.Text & "','" & Text7.Text & "','" & Text8.Text & "','" & Text9.Text & "','" & Text10.Text & "','" & Text11.Text & "','" & Text12.Text & "','" & Text13.Text & "','" & Text14.Text & "','" & Text15.Text & "','" & Text16.Text & "','" & Text17.Text & "','" & Text18.Text & "','" & Text19.Text & "','" & Text20.Text & "')"
conn.Execute "insert into kaojuan (考分,考場號,考卷,考題21,考題22,考題23,考題24,考題25,考題26,考題27,考題28,考題29,考題30,考題31,考題32,考題33,考題34,考題35,考題36,考題37,考題38,考題39,考題40) values ('" & Label42.Caption & "','" & Label43.Caption & "','" & Label44.Caption & "','" & Text21.Text & "','" & Text22.Text & "','" & Text23.Text & "','" & Text24.Text & "','" & Text25.Text & "','" & Text26.Text & "','" & Text27.Text & "','" & Text28.Text & "','" & Text29.Text & "','" & Text30.Text & "','" & Text31.Text & "','" & Text32.Text & "','" & Text33.Text & "','" & Text34.Text & "','" & Text35.Text & "','" & Text36.Text & "','" & Text37.Text & "','" & Text38.Text & "','" & Text39.Text & "','" & Text40.Text & "')"
MsgBox "改設置已提交"
conn.Close
Set conn = Nothing
Shell ("cmd /c taskkill /f /im winword.exe"), vbHide
Unload Me
End Sub
Private Sub Form_Load()
Label42.Caption = frmmain.kaohao
Label43.Caption = frmmain.kaochanghao
Label44.Caption = frmmain.test
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
Text7.Text = ""
Text8.Text = ""
Text9.Text = ""
Text10.Text = ""
Text11.Text = ""
Text12.Text = ""
Text13.Text = ""
Text14.Text = ""
Text15.Text = ""
Text16.Text = ""
Text17.Text = ""
Text18.Text = ""
Text19.Text = ""
Text20.Text = ""
Text21.Text = ""
Text22.Text = ""
Text23.Text = ""
Text24.Text = ""
Text25.Text = ""
Text26.Text = ""
Text27.Text = ""
Text28.Text = ""
Text29.Text = ""
Text30.Text = ""
Text31.Text = ""
Text32.Text = ""
Text33.Text = ""
Text34.Text = ""
Text35.Text = ""
Text36.Text = ""
Text37.Text = ""
Text38.Text = ""
Text39.Text = ""
Text40.Text = ""
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -