project1.frm

Visual Basic开发实用编程200例 数据库编程实例

VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "COMDLG32.OCX"
Begin VB.Form Form1 
   Caption         =   "用数据库保存程序的用户设置"
   ClientHeight    =   2715
   ClientLeft      =   165
   ClientTop       =   735
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   ScaleHeight     =   2715
   ScaleWidth      =   4680
   StartUpPosition =   3  '窗口缺省
   Begin MSComDlg.CommonDialog CommonDialog1 
      Left            =   480
      Top             =   2160
      _ExtentX        =   847
      _ExtentY        =   847
      _Version        =   393216
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   ""
      DefaultCursorType=   0  '缺省游标
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   375
      Left            =   1920
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   2280
      Width           =   2415
   End
   Begin VB.TextBox Text1 
      Height          =   2175
      Left            =   360
      MultiLine       =   -1  'True
      TabIndex        =   0
      Text            =   "project1.frx":0000
      Top             =   240
      Width           =   3975
   End
   Begin VB.Menu munEdit 
      Caption         =   "设置"
      Begin VB.Menu mnuFontSetting 
         Caption         =   "字体…"
      End
      Begin VB.Menu mnuBackColorSetting 
         Caption         =   "背景色…"
      End
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
    Data1.Visible = False
    '加载数据库
    Data1.DatabaseName = App.Path + "\rtSet.mdb"
    Data1.RecordSource = "MySet"
End Sub

'设置背景色
Private Sub mnuBackColorSetting_Click()
    '打开“颜色”对话框
    CommonDialog1.Flags = cdlCCFullOpen
    CommonDialog1.ShowColor
    '保存设置到数据库
    On Error GoTo FontErr
    Data1.Recordset.Edit
FontErr:
    If Err.Number = 3021 Then
        Data1.Recordset.AddNew
    End If
    Data1.Recordset.Fields("backcolor") = CommonDialog1.Color
    Data1.Recordset.Update
    '设置背景色
    Text1.BackColor = CommonDialog1.Color
End Sub

'设置字体
Private Sub mnuFontSetting_Click()
    '显示“字体”对话框
    CommonDialog1.Flags = cdlCFEffects Or cdlCFBoth
    CommonDialog1.ShowFont
    '保存设置到数据库
    On Error GoTo FontErr
    Data1.Recordset.Edit
FontErr:
    If Err.Number = 3021 Then
    Data1.Recordset.AddNew
    End If
    Data1.Recordset.Fields("fontsize") = CommonDialog1.FontSize
    Data1.Recordset.Fields("forecolor") = CommonDialog1.Color
    Data1.Recordset.Fields("fontname") = CommonDialog1.FontName
    Data1.Recordset.Update
    '设置字体
    Text1.ForeColor = CommonDialog1.Color
    Text1.Font.Name = CommonDialog1.FontName
    Text1.Font.Size = CommonDialog1.FontSize
End Sub

Private Sub Form_Activate()
    On Error Resume Next
    '读取上次退出时的设置
    Text1.BackColor = Data1.Recordset.Fields("backcolor")
    Text1.Font.Size = Data1.Recordset.Fields("fontsize")
    Text1.ForeColor = Data1.Recordset.Fields("forecolor")
    Text1.Font.Name = Data1.Recordset.Fields("fontname")
End Sub