用数据库保存程序设置.frm

个人VB学习源码精选,自己学习时的一些编程小程序,希望对大家有帮助

VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "COMDLG32.OCX"
Begin VB.Form Form1 
   Caption         =   "Form1"
   ClientHeight    =   3195
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "颜色设置"
      Height          =   435
      Left            =   1500
      TabIndex        =   0
      Top             =   1080
      Width           =   1515
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access 2000;"
      DatabaseName    =   ""
      DefaultCursorType=   0  '缺省游标
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   345
      Left            =   0
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   2820
      Visible         =   0   'False
      Width           =   1155
   End
   Begin MSComDlg.CommonDialog CommonDialog1 
      Left            =   1140
      Top             =   2700
      _ExtentX        =   847
      _ExtentY        =   847
      _Version        =   393216
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
    CommonDialog1.ShowColor
    On Error GoTo ErrDeal
    Data1.Recordset.Edit
ErrDeal:
    If Err.Number = 3021 Then
        Data1.Recordset.AddNew
    End If
    Data1.Recordset.Fields("FormBC") = CommonDialog1.Color
    Data1.Recordset.Update
    Form1.BackColor = CommonDialog1.Color
End Sub

Private Sub Form_Activate()
    On Error Resume Next
    Form1.BackColor = Data1.Recordset.Fields("FormBC")
    CommonDialog1.Color = Data1.Recordset.Fields("FormBC")
    Resume
End Sub

Private Sub Form_Load()
    Data1.DatabaseName = App.Path & IIf(Len(App.Path) > 3, "\PrgSet.mdb", "PrgSet.mdb")
    Data1.RecordSource = "ColorSet"
End Sub