Results 1 to 2 of 2

Thread: Passing Parameter to DataEnvironment?

  1. #1
    Guest
    Okay, I would like to know if anyone has successfully been able to pass a parameter from a form in VB6 to a Data Environment in order to create a Data Report. Basically, I have done everything to create the report. It looks GREAT! But now I want to be able to pull this report based on a set of dates. >StartDate and <EndDate. Can this be done?!?!?!

  2. #2
    Hyperactive Member crosbj's Avatar
    Join Date
    Oct 2000
    Location
    Michigan
    Posts
    285
    I don't know about the data reports but this is what i used for a datagrid based on a dataenvironment parameter query

    With DE1
    If .rsqryPlatingRecords.State = adStateOpen Then
    .rsqryPlatingRecords.Close
    End If
    .qryPlatingRecords txtFields(1) '*SEE BELOW
    Set DataGrid1.DataSource = .rsqryPlatingRecords
    End With

    *'qryPlatingRecords is my parameter query - txtFields(1) is the parameter off the form used for the query

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width