choosetable.frm

一个管理系统系统,进销存等,功能比较完善,界面还可以

VERSION 5.00
Begin VB.Form Form3 
   Caption         =   "Form3"
   ClientHeight    =   5445
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   7980
   LinkTopic       =   "Form3"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Moveable        =   0   'False
   Picture         =   "choosetable.frx":0000
   ScaleHeight     =   5445
   ScaleWidth      =   7980
   StartUpPosition =   3  'Windows Default
   Begin VB.Timer Timer1 
      Interval        =   2000
      Left            =   840
      Top             =   3720
   End
   Begin VB.Label Label2 
      Caption         =   "本软件由孙涛开发"
      BeginProperty Font 
         Name            =   "黑体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   5040
      TabIndex        =   1
      Top             =   4560
      Width           =   2175
   End
   Begin VB.Image Image3 
      Height          =   780
      Left            =   2400
      Picture         =   "choosetable.frx":42B3
      Top             =   600
      Width           =   3180
   End
   Begin VB.Image Image2 
      Height          =   1665
      Left            =   120
      Picture         =   "choosetable.frx":9355
      Stretch         =   -1  'True
      Top             =   120
      Width           =   1935
   End
   Begin VB.Image Image1 
      Height          =   1665
      Left            =   5880
      Picture         =   "choosetable.frx":F3AC
      Stretch         =   -1  'True
      Top             =   120
      Width           =   1935
   End
   Begin VB.Label Label1 
      Caption         =   "欢迎使用商品流动管理系统"
      BeginProperty Font 
         Name            =   "华文彩云"
         Size            =   21.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   855
      Left            =   1440
      TabIndex        =   0
      Top             =   1800
      Width           =   5295
   End
End
Attribute VB_Name = "Form3"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
If Combo1.ListIndex = -1 Then
   MsgBox ("请选择数据表!")
Else
    Form4.Show
    If Combo1.Text = "第一学期成绩表" Then
       Form4.Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\学生成绩管理.mdb;Persist Security Info=False"
       Form4.Adodc1.CommandType = adCmdUnknown
       Form4.Adodc1.RecordSource = "select * from 第一学期成绩表 order by 学号"
       Set Form4.DataGrid1.DataSource = Form4.Adodc1
       Form4.Label1.Caption = "第一学期成绩表"
    End If
    If Combo1.Text = "第二学期成绩表" Then
       Form4.Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\学生成绩管理.mdb;Persist Security Info=False"
       Form4.Adodc1.CommandType = adCmdUnknown
       Form4.Adodc1.RecordSource = "select * from 第二学期成绩表 order by 学号"
       Set Form4.DataGrid1.DataSource = Form4.Adodc1
       Form4.Label1.Caption = "第二学期成绩表"
    End If
    If Combo1.Text = "第三学期成绩表" Then
       Form4.Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\学生成绩管理.mdb;Persist Security Info=False"
       Form4.Adodc1.CommandType = adCmdUnknown
       Form4.Adodc1.RecordSource = "select * from 第三学期成绩表 order by 学号"
       Set Form4.DataGrid1.DataSource = Form4.Adodc1
       Form4.Label1.Caption = "第三学期成绩表"
End If
    If Combo1.Text = "第四学期成绩表" Then
      Form4.Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\学生成绩管理.mdb;Persist Security Info=False"
      Form4.Adodc1.CommandType = adCmdUnknown
      Form4.Adodc1.RecordSource = "select * from 第四学期成绩表 order by 学号"
      Set Form4.DataGrid1.DataSource = Form4.Adodc1
      Form4.Label1.Caption = "第四学期成绩表"
    End If
    If Combo1.Text = "第五学期成绩表" Then
      Form4.Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\学生成绩管理.mdb;Persist Security Info=False"
      Form4.Adodc1.CommandType = adCmdUnknown
      Form4.Adodc1.RecordSource = "select * from 第五学期成绩表 order by 学号"
      Set Form4.DataGrid1.DataSource = Form4.Adodc1
      Form4.Label1.Caption = "第五学期成绩表"
    End If
End If
End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()

Top = 3000
Left = 3500
End Sub

Private Sub Timer1_Timer()
Unload Me
Form2.Show
Unload Form1
End Sub