Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    154

    Unanswered: How to get rid of #Error

    I have some reports where if no data is returned from the query, I will get "#Error" in place of the section headers.

    Instead, I would like it to return something that says "No records found" as the body of the report...

    Thanks!

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    NoData Event

    Put this code in the NoData event of the report

    MsgBox "No data for this period...cancelling report.", vbOKOnly
    Cancel = True



    Voila!
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    154
    Dum da dee! I shoulda looked for something like that...

    THANKS!

Posting Permissions

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