📄 查询单个号码.frm
字号:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{E95A2510-F3D1-416D-823B-4F840FE98091}#3.0#0"; "Command.ocx"
Begin VB.Form Form15
BorderStyle = 1 'Fixed Single
Caption = "号码查询中心"
ClientHeight = 7785
ClientLeft = 45
ClientTop = 585
ClientWidth = 10155
KeyPreview = -1 'True
LinkTopic = "Form15"
LockControls = -1 'True
MaxButton = 0 'False
MDIChild = -1 'True
ScaleHeight = 7785
ScaleWidth = 10155
Begin VB.Frame Frame4
Caption = "搜索结果"
Height = 1230
Left = 120
TabIndex = 19
Top = 6450
Width = 2775
Begin VB.Label Label5
AutoSize = -1 'True
BackStyle = 0 'Transparent
ForeColor = &H00800000&
Height = 180
Left = 1050
TabIndex = 23
Top = 360
Width = 90
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
ForeColor = &H00C00000&
Height = 180
Left = 135
TabIndex = 21
Top = 615
Width = 90
End
Begin VB.Label Label3
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "结果类别："
Height = 180
Left = 135
TabIndex = 20
Top = 360
Width = 900
End
End
Begin VB.Frame Frame3
Caption = "选择搜索的范围"
Height = 2175
Left = 105
TabIndex = 6
Top = 4185
Width = 2790
Begin VB.CheckBox Check1
Caption = "直到搜索到为止"
ForeColor = &H000000FF&
Height = 255
Left = 120
TabIndex = 18
Top = 1815
Value = 1 'Checked
Width = 1740
End
Begin VB.OptionButton Option9
Caption = "家庭电话"
Height = 195
Left = 120
TabIndex = 15
Top = 1470
Width = 1020
End
Begin VB.OptionButton Option1
Caption = "企业电话"
Height = 255
Left = 120
TabIndex = 14
Top = 330
Value = -1 'True
Width = 1110
End
Begin VB.OptionButton Option2
Caption = "企业传真"
Height = 255
Left = 1275
TabIndex = 13
Top = 315
Width = 1185
End
Begin VB.OptionButton Option3
Caption = "手机号码"
Height = 255
Left = 120
TabIndex = 12
Top = 600
Width = 1095
End
Begin VB.OptionButton Option4
Caption = "小灵通"
Height = 255
Left = 1275
TabIndex = 11
Top = 600
Width = 1185
End
Begin VB.OptionButton Option5
Caption = "办公电话"
Height = 255
Left = 120
TabIndex = 10
Top = 870
Width = 1080
End
Begin VB.OptionButton Option6
Caption = "办公传真"
Height = 255
Left = 1275
TabIndex = 9
Top = 870
Width = 1185
End
Begin VB.OptionButton Option7
Caption = "QQ号码"
Height = 255
Left = 120
TabIndex = 8
Top = 1155
Width = 1050
End
Begin VB.OptionButton Option8
Caption = "其他说明"
Height = 255
Left = 1275
TabIndex = 7
Top = 1155
Width = 1185
End
Begin VB.Line Line1
BorderColor = &H00FFFFFF&
X1 = 30
X2 = 2760
Y1 = 1710
Y2 = 1710
End
End
Begin VB.Frame Frame2
Height = 7620
Left = 2970
TabIndex = 3
Top = 60
Width = 7080
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 7470
Left = 15
TabIndex = 5
ToolTipText = "双击查看详细信息。"
Top = 105
Width = 7035
_ExtentX = 12409
_ExtentY = 13176
_Version = 393216
RowHeightMin = 300
BackColorBkg = 14737632
ScrollTrack = -1 'True
SelectionMode = 1
AllowUserResizing= 1
BorderStyle = 0
Appearance = 0
End
End
Begin VB.Frame Frame1
Caption = "输入号码关键字"
Height = 1275
Left = 105
TabIndex = 0
Top = 2790
Width = 2790
Begin CSCommand.Command Command3
Height = 375
Left = 120
TabIndex = 17
Top = 750
Width = 1095
_ExtentX = 1931
_ExtentY = 661
IconAlign = 0
Icon = "查询单个号码.frx":0000
Caption = "清空 &C"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin CSCommand.Command Command1
Height = 375
Left = 1575
TabIndex = 16
Top = 750
Width = 1095
_ExtentX = 1931
_ExtentY = 661
IconAlign = 0
Icon = "查询单个号码.frx":001C
Caption = "查找 &S"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.CommandButton Command2
Caption = "停止 &T"
Height = 450
Left = 3990
TabIndex = 4
Top = 225
Visible = 0 'False
Width = 1230
End
Begin VB.TextBox Text1
Height = 285
Left = 990
TabIndex = 2
Top = 315
Width = 1680
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "输入号码："
Height = 180
Left = 120
TabIndex = 1
Top = 375
Width = 900
End
End
Begin MSComctlLib.ProgressBar ProgressBar1
Height = 225
Left = 270
TabIndex = 22
Top = 2370
Width = 2550
_ExtentX = 4498
_ExtentY = 397
_Version = 393216
Appearance = 0
End
Begin VB.Shape Shape1
BorderColor = &H00FF00FF&
Height = 285
Left = 240
Shape = 4 'Rounded Rectangle
Top = 2340
Width = 2595
End
Begin VB.Image Image2
Height = 1275
Left = 510
Picture = "查询单个号码.frx":0038
Top = 390
Width = 1800
End
End
Attribute VB_Name = "Form15"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'****************************************************************************
'人人为我，我为人人
'枕善居收藏整理
'发布日期：2007/12/24
'描 述：商务名片及客户资料管理系统 Ver 1.73
'网 站：http://www.Mndsoft.com/ (VB6源码博客)
'网 站：http://www.VbDnet.com/ (VB.NET源码博客,主要基于.NET2005)
'e-mail ：Mndsoft@163.com
'e-mail ：Mndsoft@126.com
'OICQ ：88382850
' 如果您有新的好的代码别忘记给枕善居哦!
'****************************************************************************
Option Explicit
'Static STOPB As Boolean
Private Sub Command1_Click()
Dim bm As String
Dim zw As String
Dim fj As String
Dim xm As String
Label5.Caption = ""
On Error GoTo a
dd: Command3.Enabled = False
Me.Enabled = False
'ChaZhaoNum (Text1.Text)
'Exit Sub
Dim SumRs As Double
If Trim(Text1.Text) = "" Then
Command3.Enabled = True
Me.Enabled = True
Exit Sub
End If
'''''''''开始搜索商家信息表中的"企业电话"字段 ...
Dim Db2 As Database
Dim rs2 As Recordset
Set Db2 = OpenDatabase(MdbPath)
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase(MdbPath)
If Option1.Value = True Then '如果搜索的范围为企业电话字段
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -