frmdatafields.frm

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

VERSION 5.00
Begin VB.Form FrmDataFields 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "Data Fields"
   ClientHeight    =   6240
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   7215
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   6240
   ScaleWidth      =   7215
   Begin VB.Timer Timer1 
      Interval        =   100
      Left            =   3360
      Top             =   5385
   End
   Begin VB.CommandButton Command4 
      Caption         =   "<<"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   435
      Left            =   3360
      TabIndex        =   5
      ToolTipText     =   "Remove ALL Fields"
      Top             =   3465
      Width           =   495
   End
   Begin VB.CommandButton Command3 
      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            =   180
      TabIndex        =   4
      Top             =   5850
      Width           =   1485
   End
   Begin VB.CommandButton Command2 
      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            =   5520
      TabIndex        =   3
      Top             =   5850
      Width           =   1485
   End
   Begin VB.CommandButton Command1 
      Caption         =   ">>"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   435
      Left            =   3360
      TabIndex        =   2
      ToolTipText     =   "Select ALL Fields"
      Top             =   2805
      Width           =   495
   End
   Begin VB.ListBox ExportList 
      Height          =   4380
      Left            =   3945
      TabIndex        =   1
      Top             =   1185
      Width           =   3090
   End
   Begin VB.ListBox lstFields 
      Height          =   4380
      Left            =   150
      TabIndex        =   0
      Top             =   1185
      Width           =   3090
   End
   Begin VB.Label Label5 
      Caption         =   "双击克移除"
      Height          =   285
      Left            =   5880
      TabIndex        =   10
      Top             =   960
      Width           =   1080
   End
   Begin VB.Label Label4 
      Caption         =   "双击可选择"
      Height          =   255
      Left            =   2040
      TabIndex        =   9
      Top             =   960
      Width           =   1065
   End
   Begin VB.Label Label3 
      Caption         =   "需要输出的字段"
      Height          =   240
      Left            =   3960
      TabIndex        =   8
      Top             =   960
      Width           =   1365
   End
   Begin VB.Label Label2 
      Caption         =   "可输出的字段"
      Height          =   255
      Left            =   120
      TabIndex        =   7
      Top             =   960
      Width           =   1305
   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          =   405
      Left            =   120
      TabIndex        =   6
      Top             =   240
      Width           =   6705
   End
End
Attribute VB_Name = "FrmDataFields"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
For x = 0 To lstFields.ListCount
    ExportList.AddItem (lstFields.List(x)), x
Next x
End Sub

Private Sub Command2_Click()
Timer1.Enabled = False
Me.Enabled = False
Load FrmDataExportType
FrmDataExportType.Show
End Sub

Private Sub Command3_Click()
FrmDataExport.Enabled = True
Unload Me
End Sub

Private Sub Command4_Click()
ExportList.Clear
End Sub

Private Sub ExportList_DblClick()
lstFields.AddItem (ExportList.Text)
ExportList.RemoveItem (ExportList.ListIndex)
End Sub

Private Sub Form_Load()
Me.Top = FrmDataExport.Top + 400
Me.Left = FrmDataExport.Left + 400

    Set gtdfTableDef = gdbCurrentDB.TableDefs(FrmDataExport.lstTables.Text)
    ListItemNames gtdfTableDef.Fields, lstFields, False
    lstFields.ListIndex = 0

End Sub

Private Sub lstFields_DblClick()
ExportList.AddItem (lstFields.Text)
lstFields.RemoveItem (lstFields.ListIndex)

End Sub


Private Sub Timer1_Timer()
If ExportList.ListCount > 0 Then
    Command2.Enabled = True
Else
    Command2.Enabled = False
End If
End Sub