www.pudn.com > 档案管理系统源码VB.zip > frmGuestDispaly.frm
VERSION 5.00
Begin VB.Form frmGuestDisplay
BackColor = &H00C0C0C0&
BorderStyle = 3 'Fixed Dialog
Caption = "客户详细档案表"
ClientHeight = 4140
ClientLeft = 1095
ClientTop = 330
ClientWidth = 5880
Icon = "frmGuestDispaly.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4140
ScaleWidth = 5880
ShowInTaskbar = 0 'False
StartUpPosition = 1 '所有者中心
Begin VB.PictureBox Picture1
AutoRedraw = -1 'True
BackColor = &H00808000&
Height = 540
Left = 135
ScaleHeight = 480
ScaleWidth = 5520
TabIndex = 20
Top = 75
Width = 5580
Begin VB.CommandButton ExitB
Cancel = -1 'True
Caption = "关 闭(&C)"
Height = 480
Left = 3825
TabIndex = 21
Top = 0
Width = 1695
End
Begin VB.Label lblGuestName
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "》详细表"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H0000FFFF&
Height = 240
Left = 480
TabIndex = 22
Top = 120
Width = 960
End
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 9
Left = 1275
Locked = -1 'True
MaxLength = 50
TabIndex = 19
TabStop = 0 'False
Top = 3720
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 8
Left = 1275
Locked = -1 'True
MaxLength = 10
TabIndex = 17
TabStop = 0 'False
Top = 3405
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 7
Left = 1275
Locked = -1 'True
MaxLength = 50
TabIndex = 15
TabStop = 0 'False
Top = 3075
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 6
Left = 1275
Locked = -1 'True
MaxLength = 100
TabIndex = 13
TabStop = 0 'False
Top = 2760
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 5
Left = 1275
Locked = -1 'True
MaxLength = 80
TabIndex = 11
TabStop = 0 'False
Top = 2445
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 4
Left = 1275
Locked = -1 'True
MaxLength = 50
TabIndex = 9
TabStop = 0 'False
Top = 2115
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 3
Left = 1275
Locked = -1 'True
MaxLength = 100
TabIndex = 7
TabStop = 0 'False
Top = 1800
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 2
Left = 1275
Locked = -1 'True
MaxLength = 100
TabIndex = 5
TabStop = 0 'False
Top = 1485
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 1
Left = 1275
Locked = -1 'True
MaxLength = 100
TabIndex = 3
TabStop = 0 'False
Top = 1155
Width = 4425
End
Begin VB.TextBox txtFields
BackColor = &H00C0C0C0&
ForeColor = &H00FF0000&
Height = 285
Index = 0
Left = 1275
Locked = -1 'True
MaxLength = 18
TabIndex = 1
TabStop = 0 'False
Top = 840
Width = 4425
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "所在城市:"
ForeColor = &H000000C0&
Height = 180
Index = 9
Left = 255
TabIndex = 18
Top = 3780
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "邮政编码:"
ForeColor = &H000000C0&
Height = 180
Index = 8
Left = 255
TabIndex = 16
Top = 3465
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "客户类型:"
ForeColor = &H000000C0&
Height = 180
Index = 7
Left = 255
TabIndex = 14
Top = 3135
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "公司网址:"
ForeColor = &H000000C0&
Height = 180
Index = 6
Left = 255
TabIndex = 12
Top = 2820
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "公司邮件:"
ForeColor = &H000000C0&
Height = 180
Index = 5
Left = 255
TabIndex = 10
Top = 2505
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "公司传真:"
ForeColor = &H000000C0&
Height = 180
Index = 4
Left = 255
TabIndex = 8
Top = 2175
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "公司电话:"
ForeColor = &H000000C0&
Height = 180
Index = 3
Left = 255
TabIndex = 6
Top = 1860
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "公司地址:"
ForeColor = &H000000C0&
Height = 180
Index = 2
Left = 255
TabIndex = 4
Top = 1545
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "公司名称:"
ForeColor = &H000000C0&
Height = 180
Index = 1
Left = 255
TabIndex = 2
Top = 1215
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "客户姓名:"
ForeColor = &H000000C0&
Height = 180
Index = 0
Left = 255
TabIndex = 0
Top = 900
Width = 810
End
End
Attribute VB_Name = "frmGuestDisplay"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub ExitB_Click()
Unload Me
End Sub
Private Sub Form_Load()
lblGuestName.Caption = frmFindDisplay.Grid1.Text + "《" + PublicFindstr + lblGuestName.Caption
Dim DB As Database, Ef As Recordset, TempStr As String, x As Single
Set DB = OpenDatabase(Browser + "data\file.MDB", False, False, ConStr)
Set Ef = DB.OpenRecordset("Select * From Main Where 文件姓名='" & PublicFindstr & "'", dbOpenDynaset)
x = 0
For x = 0 To Ef.Fields.Count - 1
If Not IsNull(Ef.Fields(x).Value) Then
txtFields(x).Text = Ef.Fields(x).Value
End If
Next
DB.Close
End Sub