form33.frm

This project is to design the automated system for the inventory of Al-Ahmad Cotton and Oil Mills si

VERSION 5.00
Begin VB.Form Form33 
   Caption         =   "Form33"
   ClientHeight    =   5490
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   7545
   LinkTopic       =   "Form33"
   ScaleHeight     =   5490
   ScaleWidth      =   7545
   StartUpPosition =   3  'Windows Default
   Begin VB.CommandButton Command1 
      Caption         =   "Preview"
      BeginProperty Font 
         Name            =   "Times New Roman"
         Size            =   12
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   960
      TabIndex        =   1
      Top             =   2760
      Width           =   1575
   End
   Begin VB.OptionButton Option2 
      Caption         =   "All Dates"
      BeginProperty Font 
         Name            =   "Times New Roman"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   1320
      TabIndex        =   0
      Top             =   1320
      Width           =   1815
   End
End
Attribute VB_Name = "Form33"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs As New ADODB.Recordset
'Public callingform As Object
Private Sub Command1_Click()
If Option2.Value = True Then
If rs.State = adStateOpen Then rs.Close
rs.Open "SELECT * from Customer_Table ", cnn, adOpenStatic, adLockReadOnly
Set Form16.Report = New CrystalReport3
Form16.Report.Database.SetDataSource rs, 3, 1
Form16.Show


End If
End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()
If cnn.State = adStateOpen Then cnn.Close
cnn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=hussain"
End Sub