frmdataexport.frm

很好用的通用库存管理程序

VERSION 5.00
Begin VB.Form FrmDataExport 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "Data Export"
   ClientHeight    =   5355
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   4695
   ControlBox      =   0   'False
   LinkTopic       =   "FrmDataExport"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   5355
   ScaleWidth      =   4695
   Begin VB.CommandButton Command2 
      Caption         =   "取 消"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   330
      Left            =   105
      TabIndex        =   2
      Top             =   4965
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "下一步 >>"
      Enabled         =   0   'False
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   330
      Left            =   3225
      TabIndex        =   1
      Top             =   4965
      Width           =   1335
   End
   Begin VB.ListBox lstTables 
      Height          =   3660
      Left            =   90
      MultiSelect     =   2  'Extended
      TabIndex        =   0
      Top             =   1125
      Width           =   4470
   End
   Begin VB.Label Label2 
      Caption         =   "库存列表"
      Height          =   210
      Left            =   120
      TabIndex        =   4
      Top             =   840
      Width           =   1560
   End
   Begin VB.Label Label1 
      Alignment       =   2  'Center
      Caption         =   "请选择需要输出表："
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   12
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   330
      Left            =   120
      TabIndex        =   3
      Top             =   240
      Width           =   4335
   End
End
Attribute VB_Name = "FrmDataExport"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdClose_Click()
Unload Me

End Sub


Private Sub Command1_Click()
Me.Enabled = False

Load FrmDataFields

End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()
Me.Top = MDIFrmMain.Height / 2 - Me.Height / 2 - 1000
Me.Left = MDIFrmMain.Width / 2 - Me.Width / 2
DataLocation = App.Path & "\kcgl.mdb"
'open the database
Set gdbCurrentDB = Workspaces(0).OpenDatabase(DataLocation)
'Me.Top = 0
'Me.Left = 0

 GetTableList FrmDataExport.lstTables, False, False, True

End Sub

Private Sub lstTables_Click()

Command1.Enabled = True
End Sub

Private Sub lstTables_DblClick()
Me.Enabled = False

Load FrmDataFields

End Sub