form03.frm

基于VB开

VERSION 5.00
Begin VB.Form Form03 
   BackColor       =   &H00FFC0C0&
   Caption         =   "Form1"
   ClientHeight    =   6510
   ClientLeft      =   60
   ClientTop       =   630
   ClientWidth     =   9480
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   6510
   ScaleWidth      =   9480
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "欢迎浏览"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   42
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   -1  'True
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00C0C0FF&
      Height          =   840
      Left            =   3360
      TabIndex        =   0
      Top             =   2400
      Width           =   3435
   End
   Begin VB.Menu mnuC 
      Caption         =   "C.账目查询"
      Index           =   3
      Begin VB.Menu mnuC1 
         Caption         =   "C1.分类查询"
      End
      Begin VB.Menu mnuC2 
         Caption         =   "C2.药费报销"
      End
   End
   Begin VB.Menu mnuT 
      Caption         =   "T.退出"
   End
End
Attribute VB_Name = "Form03"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

'     ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
'     ┃         Form03      浏览权限菜单窗口                   ┃
'     ┗━━━━━━━━━━━━━━━━━━━━━━━━━━━━┛


Private Sub Form_Load()                                                       ' 初始化

    If myF_ConnT(Db_fN2) = False Then Unload Me: Exit Sub   ' 连接库 T
             
    Me.Caption = " " & StrGum & StrShm
    Me.Top = (Screen.Height - Me.Height) / 2
    Me.Left = (Screen.Width - Me.Width) / 2

End Sub

Private Sub Form_Activate()                                                   ' ???
    StrT2 = "T_zm"                                          ' 检查帐目表
    If myF_ExistT(StrT2) < 1 Then
       MsgBox "  很抱歉，尚无数据可供查询 ...  ", , "  请注意"
       Unload Me
    End If
End Sub

Private Sub mnuC1_Click()
    FormC1.Show                                             ' 分类查询
End Sub

Private Sub mnuC2_Click()
    FormC2.Show                                             ' 查询药费
End Sub

Private Sub mnuT_Click()
    Unload Me                                               ' 结束程序
End Sub

Private Sub Form_Unload(Cancel As Integer)
 On Error Resume Next
    MyDb2.Close
End Sub


Private Sub bak()                                           ' 关闭对象 ???
    Dim Ws As Workspace
    Dim Db As Database
    Dim Rs As Recordset
    For Each Ws In Workspaces
        For Each Db In Ws.Databases
            'For Each Rs In Db.Recordset
            '    Rs.Close
            '    Set Rs = noting
            'Next
            Db.Close
            Set Db = noting
        Next
    Next
    End
End Sub