We need you!

We're working hard on the next version of Developer Fusion. Let us know what you think we should be up to!

Members

Technology Zones

Articles

Hosted By

MaximumASP

Info

about generation of data report

Last post 04-03-2008 2:26 PM by Jugatsu. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-01-2008 8:37 AM

    • SIRISHVB
    • Not Ranked
    • Joined on 04-01-2008
    • India
    • New Member
    • Points 10

    about generation of data report

    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.

    • Post Points: 10
  • 04-03-2008 2:26 PM In reply to

    • Jugatsu
    • Top 500 Contributor
    • Joined on 02-15-2006
    • Member
    • Points 365

    Re: about generation of data report

    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

     

     

    • Post Points: 5
Page 1 of 1 (2 items)