Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    69

    Unanswered: report query parameter

    Ive made a report to show training expired between two dates. The report runs a query and the query prompts for start and end dates. On the report in the title I then use thease query star and end dates parameters on the report heading. This works fine if the query returns some records but if the query returns nothing the between dates refuse to print out on the report and are blank. Why

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You can use the Report's OnNoData event for this. For example

    PHP Code:
    Private Sub Report_NoData(Cancel As Integer)
        
    MsgBox "No data found! Closing report."
        
    Cancel True
    End Sub 
    In this case you will get the report not opend

Posting Permissions

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