📄 frminfo2.frm
字号:
End
Begin VB.Label Label15
Caption = "车"
Height = 195
Left = 5985
TabIndex = 42
Top = 1395
Width = 195
End
Begin VB.Label Label16
Caption = "孩子"
Height = 240
Left = 7740
TabIndex = 41
Top = 1395
Width = 420
End
Begin VB.Label Label22
Caption = "本人其他情况"
Height = 1185
Left = 2565
TabIndex = 40
Top = 1890
Width = 240
End
Begin VB.Image Image1
BorderStyle = 1 'Fixed Single
Height = 2535
Left = 495
Stretch = -1 'True
Top = 360
Width = 1815
End
End
Begin VB.Frame Frame6
Caption = "要求对方"
Height = 3120
Left = 90
TabIndex = 5
Top = 3465
Width = 10500
Begin VB.TextBox Text17
DataField = "要求年龄"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 330
Left = 810
TabIndex = 14
Top = 405
Width = 1320
End
Begin VB.TextBox Text19
DataField = "要求身高"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 330
Left = 3330
TabIndex = 13
Top = 405
Width = 1230
End
Begin VB.TextBox Text20
DataField = "要求学历"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 330
Left = 5715
TabIndex = 12
Top = 360
Width = 960
End
Begin VB.TextBox Text21
DataField = "要求婚姻"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 330
Left = 8325
TabIndex = 11
Top = 405
Width = 1185
End
Begin VB.TextBox Text22
DataField = "要求户口"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 330
Left = 810
TabIndex = 10
Top = 990
Width = 1320
End
Begin VB.TextBox Text23
DataField = "要求住房"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 330
Left = 3330
TabIndex = 9
Top = 1035
Width = 1230
End
Begin VB.TextBox Text24
DataField = "要求职业"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 330
Left = 5715
TabIndex = 8
Top = 1035
Width = 960
End
Begin VB.TextBox Text25
DataField = "要求孩子"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 330
Left = 8325
TabIndex = 7
Top = 1035
Width = 1185
End
Begin VB.TextBox Text26
DataField = "其他要求"
DataSource = "AdoQuery2"
Enabled = 0 'False
Height = 1365
Left = 765
TabIndex = 6
Top = 1575
Width = 9465
End
Begin VB.Label Label2
Caption = "年龄"
Height = 195
Left = 315
TabIndex = 23
Top = 450
Width = 375
End
Begin VB.Label Label18
Caption = "身高"
Height = 240
Left = 2745
TabIndex = 22
Top = 450
Width = 375
End
Begin VB.Label Label23
Caption = "学历"
Height = 240
Left = 5085
TabIndex = 21
Top = 450
Width = 375
End
Begin VB.Label Label24
Caption = "婚姻"
Height = 195
Left = 7740
TabIndex = 20
Top = 450
Width = 375
End
Begin VB.Label Label25
Caption = "户口"
Height = 240
Left = 315
TabIndex = 19
Top = 1035
Width = 465
End
Begin VB.Label Label26
Caption = "住房"
Height = 195
Left = 2745
TabIndex = 18
Top = 1080
Width = 420
End
Begin VB.Label Label27
Caption = "职业"
Height = 195
Left = 5085
TabIndex = 17
Top = 1080
Width = 375
End
Begin VB.Label Label28
Caption = "孩子"
Height = 195
Left = 7740
TabIndex = 16
Top = 1080
Width = 375
End
Begin VB.Label Label29
Alignment = 2 'Center
Caption = "其 他 要 求"
Height = 1320
Left = 315
TabIndex = 15
Top = 1620
Width = 240
End
End
Begin VB.Frame Frame1
Height = 960
Left = 90
TabIndex = 0
Top = 6615
Width = 2175
Begin VB.Label LblAll
Alignment = 2 'Center
Caption = "0"
ForeColor = &H000000FF&
Height = 195
Left = 720
TabIndex = 1
Top = 225
Width = 645
End
Begin VB.Label LblCur
Alignment = 2 'Center
Caption = "0"
ForeColor = &H000000FF&
Height = 195
Left = 900
TabIndex = 2
Top = 585
Width = 600
End
Begin VB.Label Label17
Alignment = 2 'Center
Caption = "共有 条记录"
Height = 195
Left = 225
TabIndex = 4
Top = 225
Width = 1770
End
Begin VB.Label Label30
Alignment = 2 'Center
Caption = "当前是第 条记录"
Height = 195
Left = 135
TabIndex = 3
Top = 585
Width = 1950
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 = "FrmInfo2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim i As Integer
For i = Forms.Count - 1 To 1 Step -1
Unload Forms(i)
Next
Unload Me
End Sub
Private Sub Command5_Click()
On Error Resume Next
AdoQuery2.Recordset.MoveFirst
ShowImage Image1, AdoQuery2
LblCur.Caption = FrmInfo2.AdoQuery2.Recordset.Bookmark
End Sub
Private Sub Command6_Click()
On Error Resume Next
If AdoQuery2.Recordset.BOF = True Then
MsgBox "已是第一条记录！"
AdoQuery2.Recordset.MoveFirst
Else
AdoQuery2.Recordset.MovePrevious
If AdoQuery2.Recordset.BOF = True Then
MsgBox "已是第一条记录！"
AdoQuery2.Recordset.MoveFirst
End If
End If
ShowImage Image1, AdoQuery2
LblCur.Caption = FrmInfo2.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
MsgBox "已是最后一条记录！"
AdoQuery2.Recordset.MoveLast
End If
End If
ShowImage Image1, AdoQuery2
LblCur.Caption = FrmInfo2.AdoQuery2.Recordset.Bookmark
End Sub
Private Sub Command8_Click()
On Error Resume Next
AdoQuery2.Recordset.MoveLast
ShowImage Image1, AdoQuery2
LblCur.Caption = FrmInfo2.AdoQuery2.Recordset.Bookmark
End Sub
Private Sub Form_Load()
FrmInfo2.AdoQuery2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\mgydb.mdb;Persist Security Info=False"
FrmInfo2.AdoQuery2.CommandType = adCmdText
FrmInfo2.AdoQuery2.RecordSource = SearchStr2
FrmInfo2.AdoQuery2.Refresh
If FrmInfo2.AdoQuery2.Recordset.EOF = False Then
ShowImage Image1, AdoQuery2
LblAll.Caption = FrmInfo2.AdoQuery2.Recordset.RecordCount
LblCur.Caption = FrmInfo2.AdoQuery2.Recordset.Bookmark
MsgBox "共查到 " & AdoQuery2.Recordset.RecordCount & " 条符合条件的记录。点击确定进行浏览。", vbInformation + vbOKOnly, "提示"
Else
LblAll.Caption = 0
LblCur.Caption = 0
End If
End Sub
Private Sub Text18_Change()
End Sub
Private Sub Text12_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 & Text12.Text & "'"
FrmInfo2.AdoQuery2.RecordSource = sqlStr
FrmInfo2.AdoQuery2.Refresh
If FrmInfo2.AdoQuery2.Recordset.EOF = False Then
ShowImage Image1, AdoQuery2
Else
FrmInfo2.Image1.Picture = LoadPicture("")
End If
LblAll.Caption = FrmInfo2.AdoQuery2.Recordset.RecordCount
LblCur.Caption = FrmInfo2.AdoQuery2.Recordset.Bookmark
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -