VERSION 5.00
Object = "{65E121D4-0C60-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCHRT20.OCX"
Begin VB.Form Form1 
   Appearance      =   0  'Flat
   BackColor       =   &H80000005&
   Caption         =   "用Mschat圖表顯示數據(方法一)"
   ClientHeight    =   4800
   ClientLeft      =   1095
   ClientTop       =   825
   ClientWidth     =   10770
   FillStyle       =   2  'Horizontal Line
   BeginProperty Font 
      Name            =   "宋體"
      Size            =   7.5
      Charset         =   134
      Weight          =   400
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   LinkTopic       =   "Form1"
   PaletteMode     =   2  'Custom
   ScaleHeight     =   4800
   ScaleWidth      =   10770
   StartUpPosition =   1  '所有者中心
   Begin VB.CommandButton Command1 
      BackColor       =   &H00E0E0E0&
      Caption         =   "退出"
      BeginProperty Font 
         Name            =   "宋體"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   510
      Left            =   8145
      Style           =   1  'Graphical
      TabIndex        =   1
      Top             =   4110
      Width           =   2040
   End
   Begin MSChart20Lib.MSChart msChart1 
      Height          =   4155
      Left            =   165
      OleObjectBlob   =   "Form1.frx":0000
      TabIndex        =   0
      Top             =   -45
      Width           =   10635
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private nums As Integer

Private Sub Form_Load()
  Dim db As Database
  Dim rs As Recordset
  Dim dbname As String
  Dim i As Integer
  dbname = App.Path
  If Right$(dbname, 1) <> "\" Then dbname = dbname & "\"       '判斷數據庫是否在根目錄
  dbname = dbname & "data.mdb"
  Set db = OpenDatabase(dbname)                                '打開數據庫
  Set rs = db.OpenRecordset("銷售表", dbOpenTable)             '打開數據表
  rs.MoveLast
  rs.MoveFirst
  nums = rs.RecordCount
  ReDim arrValues(1 To nums, 1 To 3)                           '定義動態數組
  For i = 1 To nums                                            '給數組賦值
   arrValues(i, 1) = " " & rs!年份
   arrValues(i, 2) = rs!銷售額
   arrValues(i, 3) = rs!利潤
 rs.MoveNext
 Next i
 msChart1.ChartData = arrValues                               '圖表顯示數據
 msChart1.Title = "明日科技 1988--2002銷售額、利潤額（單位：萬元）圖表"   '圖表名稱
End Sub
Private Sub Command1_Click()
  End
End Sub