📄 frmverdatainput1.frm
字号:
VERSION 5.00
Begin VB.Form FrmVerDataInput1
Caption = "观测数据输入(1/2)"
ClientHeight = 7560
ClientLeft = 60
ClientTop = 450
ClientWidth = 10380
LinkTopic = "Form1"
ScaleHeight = 7560
ScaleWidth = 10380
StartUpPosition = 3 '窗口缺省
Begin VB.TextBox TxtPotNum
Height = 495
Left = 6960
TabIndex = 21
Top = 4440
Width = 1215
End
Begin VB.CommandButton Cmddownpage
Caption = "下一页"
Height = 495
Left = 6960
TabIndex = 19
Top = 6000
Width = 1215
End
Begin VB.CommandButton Cmdsave1
Caption = "保存"
Height = 495
Left = 3000
TabIndex = 18
Top = 6000
Width = 1215
End
Begin VB.TextBox TxtObsNum
Height = 495
Left = 2160
TabIndex = 17
Top = 4440
Width = 1215
End
Begin VB.TextBox TxtCalData
Height = 495
Left = 8040
TabIndex = 15
Top = 2040
Width = 1215
End
Begin VB.TextBox TxtObsName
Height = 495
Left = 8040
TabIndex = 13
Top = 840
Width = 1215
End
Begin VB.TextBox TxtInsNum
Height = 495
Left = 6960
TabIndex = 12
Top = 3240
Width = 1215
End
Begin VB.TextBox TxtCalName
Height = 495
Left = 4920
TabIndex = 11
Top = 2040
Width = 1215
End
Begin VB.TextBox TxtLoc
Height = 495
Left = 4920
TabIndex = 10
Top = 840
Width = 1215
End
Begin VB.TextBox TxtInsName
Height = 495
Left = 2160
TabIndex = 9
Top = 3240
Width = 1215
End
Begin VB.TextBox TxtObsData
Height = 495
Left = 2220
TabIndex = 8
Top = 2080
Width = 1215
End
Begin VB.TextBox TxtPro
Height = 495
Left = 2220
TabIndex = 7
Top = 840
Width = 1215
End
Begin VB.Label Label3
Caption = "网点数:"
Height = 495
Left = 5280
TabIndex = 20
Top = 4440
Width = 1215
End
Begin VB.Label Label11
Caption = "观测值个数: "
Height = 495
Left = 600
TabIndex = 16
Top = 4440
Width = 1215
End
Begin VB.Label Label10
Caption = "计算日期:"
Height = 495
Left = 6600
TabIndex = 14
Top = 2040
Width = 1215
End
Begin VB.Label Label9
Caption = "观测者:"
Height = 495
Left = 6720
TabIndex = 6
Top = 840
Width = 1215
End
Begin VB.Label Label8
Caption = "仪器编号:"
Height = 495
Left = 5280
TabIndex = 5
Top = 3240
Width = 975
End
Begin VB.Label Label6
Caption = "计算者:"
Height = 495
Left = 3720
TabIndex = 4
Top = 2040
Width = 975
End
Begin VB.Label Label5
Caption = "项目地点:"
Height = 495
Left = 3720
TabIndex = 3
Top = 840
Width = 1095
End
Begin VB.Label Label4
Caption = "仪器名称:"
Height = 495
Left = 600
TabIndex = 2
Top = 3240
Width = 1215
End
Begin VB.Label Label2
Caption = "观测日期:"
Height = 495
Left = 600
TabIndex = 1
Top = 2120
Width = 1215
End
Begin VB.Label Label1
Caption = "项目名称:"
Height = 495
Left = 600
TabIndex = 0
Top = 840
Width = 1215
End
End
Attribute VB_Name = "FrmVerDataInput1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim FileName As String
Private Sub Cmddownpage_Click()
Call VerDataInput1Save
Load FrmVerDataInput2
FrmVerDataInput2.Show
Unload Me
End Sub
Private Sub Cmdsave1_Click()
Call VerDataInput1Save
End Sub
Private Sub Form_Load()
Dim tmp As String
Me.Left = (Screen.Width - Me.Width) / 2
Me.Top = (Screen.Height - Me.Height) / 2
Set arecord = g_d_Base.OpenRecordset("基本信息表", dbOpenTable)
With arecord
If .RecordCount > 0 Then
.MoveFirst
If .Fields(0) <> "" Then g_Pro = .Fields(0)
If .Fields(1) <> "" Then g_Loc = .Fields(1)
If .Fields(2) <> "" Then g_ObsName = .Fields(2)
If .Fields(3) <> "" Then g_ObsData = .Fields(3)
If .Fields(4) <> "" Then g_CalName = .Fields(4)
If .Fields(5) <> "" Then g_CalData = .Fields(5)
If .Fields(6) <> "" Then g_InsName = .Fields(6)
If .Fields(7) <> "" Then g_InsNum = .Fields(7)
g_PotNum = .Fields(8)
g_ObsNum = .Fields(9)
End If
End With
arecord.Close
If g_ObsData = "" Then g_ObsData = Format(Date, "yyyy-mm-dd")
If g_CalData = "" Then g_CalData = Format(Date, "yyyy-mm-dd")
TxtObsData.Text = Format(g_ObsData, "yyyy-mm-dd")
TxtCalData.Text = Format(g_CalData, "yyyy-mm-dd")
TxtCalData.Text = g_CalData
TxtCalName.Text = g_CalName
TxtInsName.Text = g_InsName
TxtInsNum.Text = g_InsNum
TxtLoc.Text = g_Loc
TxtObsData.Text = g_ObsData
TxtObsName.Text = g_ObsName
TxtObsNum.Text = Str(g_ObsNum)
TxtPro.Text = g_Pro
TxtPotNum.Text = Str(g_PotNum)
End Sub
Private Sub TxtCalData_LostFocus()
g_CalData = TxtCalData.Text
End Sub
Private Sub TxtCalName_LostFocus()
g_CalName = TxtCalName.Text
End Sub
Private Sub TxtInsName_Change()
g_InsName = TxtInsName.Text
End Sub
Private Sub TxtInsNum_Change()
g_InsNum = TxtInsNum.Text
End Sub
Private Sub TxtLoc_Change()
g_Loc = TxtLoc.Text
End Sub
Private Sub TxtObsData_Change()
g_ObsData = TxtObsData.Text
End Sub
Private Sub TxtObsName_Change()
g_ObsName = TxtObsName.Text
End Sub
Private Sub TxtObsNum_Change()
g_ObsNum = Val(TxtObsNum.Text)
End Sub
Private Sub TxtPotNum_Change()
g_PotNum = Val(TxtPotNum.Text)
End Sub
Private Sub TxtPro_Change()
g_Pro = TxtPro.Text
End Sub
Private Sub VerDataInput1Save()
If g_PotNum <= 0 Then
MsgBox "必须输入网点数!", , "信息提示!"
Exit Sub
End If
If g_ObsNum <= 0 Then
MsgBox "必须输入观测值的个数!", , "信息提示!"
Exit Sub
End If
Set arecord = g_d_Base.OpenRecordset("基本信息表", dbOpenTable)
With arecord
If .RecordCount > 0 Then
.MoveFirst
.Delete
End If
.AddNew
If g_Pro <> "" Then .Fields(0) = g_Pro
If g_Loc <> "" Then .Fields(1) = g_Loc
If g_ObsName <> "" Then .Fields(2) = g_ObsName
If g_ObsData <> "" Then .Fields(3) = g_ObsData
If g_CalName <> "" Then .Fields(4) = g_CalName
If g_CalData <> "" Then .Fields(5) = g_CalData
If g_InsName <> "" Then .Fields(6) = g_InsName
If g_InsNum <> "" Then .Fields(7) = g_InsNum
.Fields(8) = g_PotNum
.Fields(9) = g_ObsNum
.Update
.Bookmark = .LastModified
.Close
End With
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -