frmpurchasesreport.frm

This file came from Planet-Source-Code.com...the home millions of lines of source code You can view

         Left            =   600
         Style           =   2  'Dropdown List
         TabIndex        =   7
         Top             =   480
         Width           =   2295
      End
      Begin VB.CommandButton cmdViewReport3 
         BackColor       =   &H00FFFFFF&
         Caption         =   "View Report"
         Height          =   1095
         Left            =   6960
         Picture         =   "frmPurchasesReport.frx":101C
         Style           =   1  'Graphical
         TabIndex        =   6
         Top             =   240
         Width           =   1095
      End
      Begin VB.Label Label5 
         BackColor       =   &H00FF8080&
         Caption         =   " = "
         BeginProperty Font 
            Name            =   "Verdana"
            Size            =   8.25
            Charset         =   0
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00FFFFFF&
         Height          =   375
         Left            =   3240
         TabIndex        =   9
         Top             =   480
         Width           =   375
      End
   End
   Begin VB.Frame Frame4 
      BackColor       =   &H00FF8080&
      Caption         =   "Supplier ID"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   8.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FFFFFF&
      Height          =   1575
      Left            =   360
      TabIndex        =   1
      Top             =   6480
      Width           =   8175
      Begin VB.TextBox txtCustomerID 
         Height          =   375
         Left            =   3840
         TabIndex        =   3
         Top             =   360
         Width           =   2415
      End
      Begin VB.CommandButton cmdViewReport4 
         BackColor       =   &H00FFFFFF&
         Caption         =   "View Report"
         Height          =   1095
         Left            =   6960
         Picture         =   "frmPurchasesReport.frx":15A8
         Style           =   1  'Graphical
         TabIndex        =   2
         Top             =   240
         Width           =   1095
      End
      Begin VB.Label Label6 
         AutoSize        =   -1  'True
         BackColor       =   &H00FF8080&
         Caption         =   "Supplier ID"
         BeginProperty Font 
            Name            =   "Verdana"
            Size            =   8.25
            Charset         =   0
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00FFFFFF&
         Height          =   195
         Left            =   600
         TabIndex        =   4
         Top             =   360
         Width           =   1095
      End
   End
   Begin Crystal.CrystalReport crPurchase 
      Left            =   840
      Top             =   360
      _ExtentX        =   741
      _ExtentY        =   741
      _Version        =   348160
      WindowControlBox=   -1  'True
      WindowMaxButton =   -1  'True
      WindowMinButton =   -1  'True
      PrintFileLinesPerPage=   60
      WindowShowSearchBtn=   -1  'True
      WindowShowRefreshBtn=   -1  'True
   End
   Begin ActiveResizeCtl.ActiveResize ActiveResize1 
      Left            =   120
      Top             =   360
      _ExtentX        =   847
      _ExtentY        =   847
      Resolution      =   4
      ScreenHeight    =   1024
      ScreenWidth     =   1280
      ScreenHeightDT  =   1024
      ScreenWidthDT   =   1280
      FormHeightDT    =   9975
      FormWidthDT     =   8970
      FormScaleHeightDT=   9465
      FormScaleWidthDT=   8850
      ResizeFormBackground=   -1  'True
      ResizePictureBoxContents=   -1  'True
   End
   Begin VB.Label Label7 
      AutoSize        =   -1  'True
      BackColor       =   &H00FF8080&
      Caption         =   "PURCHASE REPORTS"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   18
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FFFFFF&
      Height          =   435
      Left            =   2400
      TabIndex        =   0
      Top             =   240
      Width           =   4170
   End
End
Attribute VB_Name = "frmPurchasesReport"
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 cmdViewReport1_Click()
Dim strReport As String
strReport = App.Path & "\Reports\Pharmacy\Purchase.rpt"


crPurchase.ReportFileName = App.Path & "\Reports\Pharmacy\Purchase.rpt"
crPurchase.DiscardSavedData = True
crPurchase.ReplaceSelectionFormula ("{Purchase_Orders.PurchaseOrderDate}   >=#" & DTPFrom & "#  and {Purchase_Orders.PurchaseOrderDate}  <=#" & DTPTo & "#  ")

crPurchase.WindowState = crptMaximized
crPurchase.Action = 1
End Sub

Private Sub cmdViewReport2_Click()
Dim strReport As String
strReport = App.Path & "\Reports\Pharmacy\Purchase.rpt"

crPurchase.ReportFileName = App.Path & "\Reports\Pharmacy\Purchase.rpt"
crPurchase.DiscardSavedData = True
crPurchase.ReplaceSelectionFormula ("{Purchase_Orde_Details.NetValue}   >=" & Val(txtTotalFrom) & "  and {Purchase_Orde_Details.NetValue}  <=" & Val(txtTotalto) & "")


crPurchase.WindowState = crptMaximized
crPurchase.Action = 1
End Sub

Private Sub cmdViewReport3_Click()
Dim strReport As String
strReport = App.Path & "\Reports\Pharmacy\Purchase.rpt"


crPurchase.ReportFileName = App.Path & "\Reports\Pharmacy\Purchase.rpt"
crPurchase.DiscardSavedData = True

If cmbOrder.ListIndex = 3 Or cmbOrder.ListIndex = 4 Or cmbOrder.ListIndex = 5 Or cmbOrder.ListIndex = 6 Then
crPurchase.ReplaceSelectionFormula ("{Purchase_Orde_Details." & cmbOrder & "}  =" & txtOrder & "")
Else
crPurchase.ReplaceSelectionFormula ("{Purchase_Orde_Details." & cmbOrder & "}  ='" & txtOrder & "'")
End If

crPurchase.WindowState = crptMaximized
crPurchase.Action = 1
End Sub

Private Sub cmdViewReport4_Click()
Dim strReport As String
strReport = App.Path & "\Reports\Pharmacy\Purchase.rpt"


crPurchase.ReportFileName = App.Path & "\Reports\Pharmacy\Purchase.rpt"
crPurchase.DiscardSavedData = True

crPurchase.ReplaceSelectionFormula ("{Purchase_Orders.PurchaseSupplierID}  ='" & txtCustomerID & "'")


crPurchase.WindowState = crptMaximized
crPurchase.Action = 1

End Sub

Private Sub Form_Load()
Dim rsadd As Recordset
Set rsadd = New ADODB.Recordset

rsadd.Open "Select * from Purchase_Orde_Details", cnPatients, adOpenDynamic, adLockReadOnly

For i = 0 To rsadd.Fields.Count - 1 Step 1
    cmbOrder.AddItem rsadd.Fields(i).name, i
Next
rsadd.Close
End Sub
Private Sub Form_KeyPress(KeyAscii As Integer)
    If KeyAscii = 22 Then KeyAscii = 0: Exit Sub
    KeyAscii = DataEntryValidation(KeyAscii, ActiveControl.Tag)
End Sub