📄 yy_khzl.frm
字号:
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 14
Left = 5100
TabIndex = 44
Top = 5430
Width = 1095
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "客户编号:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Index = 0
Left = 150
TabIndex = 31
Top = 345
Width = 1095
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "登记日期:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 1
Left = 120
TabIndex = 30
Top = 5430
Width = 1455
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "币 制:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 2
Left = 120
TabIndex = 29
Top = 5025
Width = 975
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "乡（镇）:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 3
Left = 5190
TabIndex = 28
Top = 810
Width = 1335
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "市(区)/县:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 4
Left = 120
TabIndex = 27
Top = 810
Width = 1215
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "国(州省):"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 5
Left = 5220
TabIndex = 26
Top = 360
Width = 1575
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "登记员:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 6
Left = 2790
TabIndex = 25
Top = 5430
Width = 855
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "结算方式:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 7
Left = 5100
TabIndex = 24
Top = 5010
Width = 1095
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "汇率:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 8
Left = 3000
TabIndex = 23
Top = 5025
Width = 855
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "传真:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 9
Left = 4710
TabIndex = 22
Top = 3510
Width = 705
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "电 话:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 10
Left = 120
TabIndex = 21
Top = 3075
Width = 975
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "中文地址:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 11
Left = 120
TabIndex = 20
Top = 2160
Width = 1095
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "联 系 人:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 12
Left = 120
TabIndex = 19
Top = 3525
Width = 975
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
Caption = "客户名称:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 13
Left = 120
TabIndex = 18
Top = 1260
Width = 1215
End
End
Begin MSAdodcLib.Adodc Adoprimaryrs
Height = 735
Left = 2880
Top = 120
Width = 4215
_ExtentX = 7435
_ExtentY = 1296
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 = "Adoprimaryrs"
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 = "yy_khzl"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub CMd_Find_Click()
On Error Resume Next
Set CX_FrM_SjY = yy_khzl.Adoprimaryrs
CX_SJy = "select * from yy_khzl where not khmc is null "
With SEC_Dialog
.Combo1(0).Clear
.Combo1(1).Clear
.Combo1(0).AddItem ("khbh(客户编号）")
.Combo1(1).AddItem ("khbh(客户编号）")
.Combo1(0).AddItem ("khmc(客户名称）")
.Combo1(1).AddItem ("khmc(客户名称）")
.Combo1(0).AddItem ("sheng(省）")
.Combo1(1).AddItem ("sheng(省）")
.Combo1(0).AddItem ("shi(市）")
.Combo1(1).AddItem ("shi(市）")
.Combo1(0).AddItem ("zheng(镇）")
.Combo1(1).AddItem ("zheng(镇）")
.Combo1(0).AddItem ("lxr(联系人）")
.Combo1(1).AddItem ("lxr(联系人）")
End With
Load SEC_Dialog
SEC_Dialog.Show 1
End Sub
Private Sub CmdPrint_Click()
'ActiveReport1.DataControl1.ConnectionString = Conn_Str
khzl_rpt.DataControl1.ConnectionString = Conn_Str
khzl_rpt.DataControl1.Source = "select * from yy_khzl order by khbh " '"
khzl_rpt.Show VBRUN.FormShowConstants.vbModal
'ActiveReport1.DataControl1.Source = "select * from yy_khzl with (nolock) order by khbh " '"
'ActiveReport1.Show VBRUN.FormShowConstants.vbModal
End Sub
Private Sub Cmdreturn_Click()
Unload Me
End Sub
'*******************************************************
'* 曹汉华 2002.8.29 编写 *
'*******************************************************
Private Sub cmdnext_Click() '向后
On Error GoTo GoNextError
If Not Adoprimaryrs.Recordset.EOF Then Adoprimaryrs.Recordset.MoveNext
If Adoprimaryrs.Recordset.EOF And Adoprimaryrs.Recordset.RecordCount > 0 Then
Beep
Adoprimaryrs.Recordset.MoveLast
End If
Exit Sub
GoNextError:
MsgBox Err.Description
End Sub
Private Sub Cmdqd_Click() '首端
If Adoprimaryrs.Recordset.RecordCount > 0 Then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -