renpasswordfrm.frm

一个票务管理软件

VERSION 5.00
Begin VB.Form printfrm 
   BackColor       =   &H8000000E&
   ClientHeight    =   7770
   ClientLeft      =   945
   ClientTop       =   750
   ClientWidth     =   10260
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   7791.949
   ScaleMode       =   0  'User
   ScaleWidth      =   10357.1
   Begin VB.CommandButton Command3 
      Caption         =   "返    回"
      Height          =   375
      Left            =   2400
      TabIndex        =   2
      Top             =   7200
      Width           =   1215
   End
   Begin VB.CommandButton Command2 
      Caption         =   "退    出"
      Height          =   375
      Left            =   5520
      TabIndex        =   1
      Top             =   7200
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "打    印"
      Height          =   375
      Left            =   3960
      TabIndex        =   0
      Top             =   7200
      Width           =   1215
   End
End
Attribute VB_Name = "printfrm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim cnnjinbin As New ADODB.Connection
Dim rstjinbin As New ADODB.Recordset
Dim cmdjinbin As New ADODB.Command
Dim strcnn As String

Private Sub Command1_Click()
With cnnjinbin
    If .State = adStateOpen Then
        .Close
    End If
        .Provider = "microsoft.jet.oledb.4.0"
        .ConnectionString = App.Path & "\jinbin.mdb"
        .Open
End With

With rstjinbin
    If .State = adStateOpen Then
        .Close
    End If
    .LockType = adLockReadOnly
    .CursorLocation = adUseClient
    .CursorType = adOpenDynamic
    .ActiveConnection = cnnjinbin
    .Source = "select * from data order by bh desc "
    .Open
    
  wt.prn
   
End With

'清空复选框
datafrm.Check1.Value = Unchecked

'清空起止号
datafrm.txt5b.Text = ""
datafrm.txt5e.Text = ""
datafrm.txt10b.Text = ""
datafrm.txt10e.Text = ""
datafrm.txt15b.Text = ""
datafrm.txt15e.Text = ""
datafrm.txt20b.Text = ""
datafrm.txt20e.Text = ""
datafrm.txt30b.Text = ""
datafrm.txt30e.Text = ""
datafrm.txtsfname.Text = ""
datafrm.txtgonghao.Text = ""
datafrm.txtgonghao1.Text = ""
checkfrm.txt5b1.Text = ""
checkfrm.txt5e1.Text = ""
checkfrm.txt5b2.Text = ""
checkfrm.txt5e2.Text = ""
checkfrm.txt10b1.Text = ""
checkfrm.txt10e1.Text = ""
checkfrm.txt10b2.Text = ""
checkfrm.txt10e2.Text = ""
checkfrm.txt15b1.Text = ""
checkfrm.txt15e1.Text = ""
checkfrm.txt15b2.Text = ""
checkfrm.txt15e2.Text = ""
checkfrm.txt20b1.Text = ""
checkfrm.txt20e1.Text = ""
checkfrm.txt20b2.Text = ""
checkfrm.txt20e2.Text = ""
checkfrm.txt30b1.Text = ""
checkfrm.txt30e1.Text = ""
checkfrm.txt30b2.Text = ""
checkfrm.txt30e2.Text = ""


printfrm.Hide
Unload Me
End Sub


Private Sub Command2_Click()

'清空复选框
datafrm.Check1.Value = Unchecked

'清空起止号
datafrm.txt5b.Text = ""
datafrm.txt5e.Text = ""
datafrm.txt10b.Text = ""
datafrm.txt10e.Text = ""
datafrm.txt15b.Text = ""
datafrm.txt15e.Text = ""
datafrm.txt20b.Text = ""
datafrm.txt20e.Text = ""
datafrm.txt30b.Text = ""
datafrm.txt30e.Text = ""
datafrm.txtsfname.Text = ""
datafrm.txtgonghao.Text = ""
datafrm.txtgonghao1.Text = ""
checkfrm.txt5b1.Text = ""
checkfrm.txt5e1.Text = ""
checkfrm.txt5b2.Text = ""
checkfrm.txt5e2.Text = ""
checkfrm.txt10b1.Text = ""
checkfrm.txt10e1.Text = ""
checkfrm.txt10b2.Text = ""
checkfrm.txt10e2.Text = ""
checkfrm.txt15b1.Text = ""
checkfrm.txt15e1.Text = ""
checkfrm.txt15b2.Text = ""
checkfrm.txt15e2.Text = ""
checkfrm.txt20b1.Text = ""
checkfrm.txt20e1.Text = ""
checkfrm.txt20b2.Text = ""
checkfrm.txt20e2.Text = ""
checkfrm.txt30b1.Text = ""
checkfrm.txt30e1.Text = ""
checkfrm.txt30b2.Text = ""
checkfrm.txt30e2.Text = ""


printfrm.Hide
Unload Me
End Sub

Private Sub Command3_Click()

strcnn = "delete from data where sxm='" & datafrm.txtsfname & "' and bz='" & datafrm.Combobz & "' and riqi=#" & (datafrm.txtrq) & "#"
 With cnnjinbin
        If .State = adStateOpen Then
           .Close
        End If
        .Provider = "microsoft.jet.oledb.4.0"
        .ConnectionString = App.Path & "\jinbin.mdb"
        .ConnectionTimeout = 10
        .Open
 End With


 With cmdjinbin
        .ActiveConnection = cnnjinbin
        .CommandType = adCmdText
        .CommandText = strcnn
        .Execute
 End With

printfrm.Hide
Unload Me

End Sub