📄 frminfo.frm
字号:
Height = 2535
Left = 360
Stretch = -1 'True
Top = 360
Width = 1950
End
Begin VB.Label Label22
Caption = "本人其他情况"
Height = 1185
Left = 2565
TabIndex = 42
Top = 1890
Width = 240
End
Begin VB.Label Label16
Caption = "孩子"
Height = 240
Left = 7740
TabIndex = 41
Top = 1395
Width = 420
End
Begin VB.Label Label15
Caption = "车"
Height = 195
Left = 5985
TabIndex = 39
Top = 1395
Width = 195
End
Begin VB.Label Label14
Caption = "住房"
Height = 195
Left = 3825
TabIndex = 37
Top = 1395
Width = 420
End
Begin VB.Label Label13
Caption = "收入"
Height = 195
Left = 2475
TabIndex = 35
Top = 1395
Width = 375
End
Begin VB.Label Label12
Caption = "职业"
Height = 195
Left = 8820
TabIndex = 33
Top = 900
Width = 375
End
Begin VB.Label Label11
Caption = "婚姻"
Height = 195
Left = 6840
TabIndex = 31
Top = 900
Width = 375
End
Begin VB.Label Label10
Caption = "户口"
Height = 240
Left = 5175
TabIndex = 29
Top = 870
Width = 465
End
Begin VB.Label Label9
Caption = "学历"
Height = 240
Left = 3870
TabIndex = 27
Top = 855
Width = 375
End
Begin VB.Label Label8
Caption = "体重"
Height = 195
Left = 2475
TabIndex = 25
Top = 855
Width = 375
End
Begin VB.Label Label6
Caption = "身高"
Height = 240
Left = 8820
TabIndex = 23
Top = 315
Width = 375
End
Begin VB.Label Label5
Caption = "出生日期"
Height = 195
Left = 6480
TabIndex = 21
Top = 315
Width = 780
End
Begin VB.Label Label4
Caption = "属相"
Height = 240
Left = 5220
TabIndex = 19
Top = 315
Width = 420
End
Begin VB.Label Label3
Caption = "年龄"
Height = 195
Left = 3870
TabIndex = 17
Top = 315
Width = 375
End
Begin VB.Label Label1
Caption = "编号"
Height = 195
Left = 2475
TabIndex = 15
Top = 300
Width = 375
End
Begin VB.Label Label20
Caption = "照片"
Height = 375
Left = 90
TabIndex = 13
Top = 1305
Width = 165
End
End
Begin VB.Frame Frame4
Height = 960
Left = 2295
TabIndex = 7
Top = 6615
Width = 1950
Begin MSComCtl2.UpDown UpDown1
Height = 285
Left = 1260
TabIndex = 10
Top = 405
Width = 240
_ExtentX = 450
_ExtentY = 503
_Version = 393216
Value = 1
AutoBuddy = -1 'True
BuddyControl = "Text18"
BuddyDispid = 196669
OrigLeft = 1215
OrigTop = 360
OrigRight = 1455
OrigBottom = 645
Max = 99999
Min = 1
SyncBuddy = -1 'True
BuddyProperty = 65547
Enabled = -1 'True
End
Begin VB.TextBox Text18
Alignment = 1 'Right Justify
BeginProperty DataFormat
Type = 1
Format = "0"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 1
EndProperty
Height = 285
Left = 675
MaxLength = 5
TabIndex = 9
Text = "1"
Top = 405
Width = 585
End
Begin VB.Label Label21
Caption = "号"
Height = 195
Left = 1575
TabIndex = 11
Top = 450
Width = 285
End
Begin VB.Label Label19
Caption = "到第"
Height = 240
Left = 225
TabIndex = 8
Top = 450
Width = 375
End
End
Begin VB.Frame Frame3
Height = 960
Left = 8910
TabIndex = 5
Top = 6615
Width = 1680
Begin VB.CommandButton Command1
Caption = "退出"
Height = 375
Left = 315
TabIndex = 6
Top = 315
Width = 975
End
End
Begin VB.Frame Frame2
Caption = "导航"
Height = 990
Left = 4320
TabIndex = 0
Top = 6615
Width = 4545
Begin VB.CommandButton Command5
Caption = "第一页"
Height = 375
Left = 135
TabIndex = 4
Top = 360
Width = 975
End
Begin VB.CommandButton Command6
Caption = "上一页"
Height = 375
Left = 1215
TabIndex = 3
Top = 360
Width = 975
End
Begin VB.CommandButton Command7
Caption = "下一页"
Height = 375
Left = 2295
TabIndex = 2
Top = 360
Width = 975
End
Begin VB.CommandButton Command8
Caption = "最后一页"
Height = 375
Left = 3375
TabIndex = 1
Top = 360
Width = 975
End
End
Begin MSAdodcLib.Adodc AdoQuery2
Height = 330
Left = 0
Top = 0
Visible = 0 'False
Width = 1455
_ExtentX = 2566
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
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 = "Adodc1"
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
Attribute VB_Name = "FrmInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Unload Me
End Sub
Private Sub Command5_Click()
On Error Resume Next
AdoQuery2.Recordset.MoveFirst
ShowImage Image1, AdoQuery2
LblCur.Caption = AdoQuery2.Recordset.Bookmark
End Sub
Private Sub Command6_Click()
On Error Resume Next
If AdoQuery2.Recordset.BOF = True Then
AdoQuery2.Recordset.MoveFirst
MsgBox "已是第一条记录！"
Else
AdoQuery2.Recordset.MovePrevious
If AdoQuery2.Recordset.BOF = True Then
AdoQuery2.Recordset.MoveFirst
MsgBox "已是第一条记录！"
End If
End If
ShowImage Image1, AdoQuery2
LblCur.Caption = AdoQuery2.Recordset.Bookmark
End Sub
Private Sub Command7_Click()
On Error Resume Next
If AdoQuery2.Recordset.EOF = True Then
AdoQuery2.Recordset.MoveLast
Else
AdoQuery2.Recordset.MoveNext
If AdoQuery2.Recordset.EOF = True Then
AdoQuery2.Recordset.MoveLast
MsgBox "已是最后一条记录！"
End If
End If
ShowImage Image1, AdoQuery2
LblCur.Caption = AdoQuery2.Recordset.Bookmark
End Sub
Private Sub Command8_Click()
On Error Resume Next
AdoQuery2.Recordset.MoveLast
ShowImage Image1, AdoQuery2
LblCur.Caption = AdoQuery2.Recordset.Bookmark
End Sub
Private Sub Form_Load()
FrmInfo.AdoQuery2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\mgydb.mdb;Persist Security Info=False"
FrmInfo.AdoQuery2.CommandType = adCmdText
FrmInfo.AdoQuery2.RecordSource = SearchStr
FrmInfo.AdoQuery2.Refresh
If FrmInfo.AdoQuery2.Recordset.EOF = False Then
ShowImage Image1, AdoQuery2
LblAll.Caption = AdoQuery2.Recordset.RecordCount
LblCur.Caption = AdoQuery2.Recordset.Bookmark
MsgBox "共查到 " & AdoQuery2.Recordset.RecordCount & " 条符合条件的记录。点击确定进行浏览。", vbInformation + vbOKOnly, "提示"
Else
LblAll.Caption = 0
LblCur.Caption = 0
End If
End Sub
Private Sub Form_Unload(Cancel As Integer)
SearchStr = "select * from mgydb where "
End Sub
Private Sub Text18_Change()
On Error Resume Next
Dim AddStr As String
If Len(Text18.Text) = 1 Then
AddStr = "0000"
ElseIf Len(Text18.Text) = 2 Then
AddStr = "000"
ElseIf Len(Text18.Text) = 3 Then
AddStr = "00"
ElseIf Len(Text18.Text) = 4 Then
AddStr = "0"
Else
AddStr = ""
End If
sqlStr = "select * from mgydb where 编号='" & AddStr & Text18.Text & "'"
FrmInfo.AdoQuery2.RecordSource = sqlStr
FrmInfo.AdoQuery2.Refresh
If FrmInfo.AdoQuery2.Recordset.EOF = False Then
ShowImage Image1, AdoQuery2
Else
FrmInfo.Image1.Picture = LoadPicture("")
End If
LblAll.Caption = AdoQuery2.Recordset.RecordCount
LblCur.Caption = AdoQuery2.Recordset.Bookmark
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -