frmbz.frm

民间标会的会员管理用的软件。是为一个顾客定做的！

VERSION 5.00
Begin VB.Form frmBZ 
   Caption         =   "附加信息"
   ClientHeight    =   6750
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   10020
   LinkTopic       =   "Form1"
   ScaleHeight     =   6750
   ScaleWidth      =   10020
   StartUpPosition =   2  'CenterScreen
   Begin VB.PictureBox Picture1 
      Align           =   2  'Align Bottom
      BorderStyle     =   0  'None
      Height          =   1035
      Left            =   0
      ScaleHeight     =   1035
      ScaleWidth      =   10020
      TabIndex        =   1
      Top             =   5715
      Width           =   10020
      Begin VB.CommandButton Command3 
         Caption         =   "字体设置"
         Height          =   375
         Left            =   900
         TabIndex        =   4
         Top             =   360
         Width           =   1095
      End
      Begin VB.CommandButton Command1 
         Caption         =   "确 定 "
         Height          =   375
         Left            =   6720
         TabIndex        =   3
         Top             =   300
         Width           =   1035
      End
      Begin VB.CommandButton Command2 
         Caption         =   "取 消"
         Height          =   375
         Left            =   8280
         TabIndex        =   2
         Top             =   300
         Width           =   915
      End
   End
   Begin VB.TextBox txtBz 
      Appearance      =   0  'Flat
      BackColor       =   &H00F7F7F7&
      ForeColor       =   &H00000000&
      Height          =   5715
      Left            =   0
      MaxLength       =   65535
      MultiLine       =   -1  'True
      ScrollBars      =   2  'Vertical
      TabIndex        =   0
      Top             =   0
      Width           =   10035
   End
End
Attribute VB_Name = "frmBZ"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim IsChanged   As Boolean

Private Sub Command1_Click()

If IsChanged = True Then
    Savebz
End If

Unload Me

End Sub

Private Sub Command2_Click()
Unload Me

End Sub

Private Sub Command3_Click()

frmMain.CD1.Flags = cdlCFScreenFonts
frmMain.CD1.ShowFont

With txtBz.Font
    .Size = frmMain.CD1.FontSize
    .Name = frmMain.CD1.FontName
    .Underline = frmMain.CD1.FontUnderline
    .Bold = frmMain.CD1.FontBold
    .Italic = frmMain.CD1.FontItalic
    .Strikethrough = frmMain.CD1.FontStrikethru
End With
End Sub

Private Sub Form_Load()
Dim SQL As String

Dim Tmp As Variant

SQL = "SELECT 备注 FROM 客户表 WHERE 客户编号=" & FrmDj2.Client

Tmp = GetValue(SQL)

If Not IsNull(Tmp) Then txtBz.Text = CStr(Tmp)


IsChanged = False


End Sub

Private Sub Form_Resize()
On Error Resume Next

txtBz.Width = Me.ScaleWidth
txtBz.Height = Me.ScaleHeight - Picture1.Height - txtBz.Top

End Sub

Private Sub txtBz_Change()
IsChanged = True
End Sub


Private Sub Savebz()
Dim Tmp As String

Tmp = txtBz.Text

CheckSQL Tmp

ExecSQL "Update 客户表 Set 备注='" & Tmp & "' WHERE 客户编号=" & FrmDj2.Client

End Sub