about generation of data report

• • Reply

  12 years ago

  by serfabroj

  Fabian Rojas

  , Argentina

  Joined 13 years ago

  I facing a problem when I am going to generate a data report in the vb.

  I want to generate a data report in vb according the date provided by me.

  In two text boxes I am giving the from date and to date, then I want the report

  by clicking the vewreport comand button.

  I am new in vb so please help me to doing this.

  Report abuse
• • Reply

  12 years ago

  by Jugatsu

  Jugatsu

  , United Kingdom

  Joined 15 years ago

  Form = frmReport
  Textbox name = txtFromDate 

  Create a button & paste in this code

  
  Dim sFromDate As String
  sFromDate = Form_frmReport.txtFromDate

  ' Preview the report and pass in the values
  ' fromDate is the feild name from the table (or Query)

      Dim stDocName As String
      stDocName = "Report"

  DoCmd.OpenReport stDocName, acViewPreview, , "fromDate = " & sFromDate

   

   

  Report abuse