Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts and Reports (2000)

    Hi, I have a report where the source is a query, a chart with same source is shown also. In addition I have further charts added to the same report where the source of those charts are other queries, these did, or at least I think they did, work fine. Now there are just blanks where these additonal charts should be. When I run the source sql query I get the message along the lines that jet does not recognise criteria on the source queryL, that criteria is forms!formname!date, where the user is entering a date range. How can I get around this if, at all?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Charts and Reports (2000)

    Have you tried to compact and repair the database?

    Is the form open when you try to open the query or report? If it isn't, forms!formname!date will not be recognised.

    Otherwise, could you post the row source of one of the "blank" charts?

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts and Reports (2000)

    Thanks Hans.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Charts and Reports (2000)

    Could you explain for the benefit of future readers of this thread whether the problem is solved, and if so, how? 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
  •